• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Search Macro needed for Excel

T

thilanliyan

Lifer
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.
 
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).
 
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?
 
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?

 
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.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top