LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
jen jen is offline
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automating a calendar Lofty Excel Discussion (Misc queries) 0 November 28th 06 03:21 PM
Automating using VBA Automate my database Excel Worksheet Functions 1 September 1st 05 01:51 PM
VBA Automating vlookups Cory Excel Programming 2 May 27th 04 12:57 AM
AUTOMATING CHARTS W/VBA ibeetb Excel Programming 1 December 11th 03 04:16 PM
Automating PP from XL Keith R[_3_] Excel Programming 0 November 20th 03 08:42 PM


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"