Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: doneitagain
- Order by date
-
Running a MSQuery in Excel using VBA...
I am trying to run a MSQuery using VBA code in Excel 2000. I use the query to access our informix database and return data into Excel. I need to run the query in a for/next loop to return data based on a range of cells. The data returned is then copied to the appropriate cells in the worksheet...- doneitagain
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Query Prompts for Parameters??
You need to put the prompt in square brackets in the criteria section of the query (if using Access). eg. [Please input the date.] (In Microsoft Query in Excel the prompt goes in the value section) When you run the query it will prompt for the date. Hope this helps- doneitagain
- Post #4
- Forum: Microsoft: Office
-
Running a Microsoft Query with VBA
How can I run a microsoft query in an excel 2000 application using VBA coding. Looked in various books found no answer. Tried to record a macro, actually recorded no instance of the microsoft query actions. Desperately need some guidance. Thanks in advance- doneitagain
- Thread
- Replies: 1
- Forum: Microsoft: Office
