Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating MS Query
Hello,
I have an Excel spreadsheet that uses MS Query to pull data from a SQL database. Each month the user has to go in to each separate query (there are 12) to enter the appropriate date range. I'm looking for ideas on how to automate this. Either have a pop-up box where they enter the date one time, or somehow have the queries refresh with the most current month end. I need some ideas on where to even begin. I know a little VBA, but only from recording my macros and then editing the code. I've never coded from scratch. Any ideas would be great! Thanks! Jen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating a calendar | Excel Discussion (Misc queries) | |||
Automating using VBA | Excel Worksheet Functions | |||
VBA Automating vlookups | Excel Programming | |||
AUTOMATING CHARTS W/VBA | Excel Programming | |||
Automating PP from XL | Excel Programming |