Search Macro needed for Excel

[thilanliyan]

Anyone know how to program a search macro in Excel using Visual Basic to just input a couple of fields in a database program?

I need to be able to automatically fill in a couple of fields in a database program.

 

[cprince]

Writing Macros for Excel isn't bad. Look in Excel's help file. I'm sure that you can find something there(or a way to do it).

 

[thilanliyan]

I found out how to do a search in Google but with Google you can see the exact URL needed to do a search so inputting the correct string into the URL using the macro is not a problem. However, with a database how do I know where to input the values?

 

[KLin]

1. what database engine(MySql, MS SQL Server, IBM DB/2, Oracle, etc) are you talking about?
2. Can you provide a little more information about what you're specifically trying to do?
3. Are the values stored in excel and you want to get them into the database fields?

 

[xtknight]

You can probably interface with Access to set a few cells of a "Report" to a certain value. There are more elegant ways to interface with a MS database like using a Jet database object from VBA.