By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

excel macro to run sql query for specific date input and save the file

P: 1
Hi
Need help in automating the report.Let me give the explanation what i need that might help u in understanding it.

1 need excel macro to run a query to pull data from sql server for specific dates
for e.g it should take inputs from 2 cells such as data from 12/10/2007 (b1cell)-12/11/2007(b2 cell).
2 then it should autmatically save the file in the specific location with specific name.

3 need to run this process automatically every day at 4.00 pm to save the reports automatically to the specific location.

Also wanted to save only values in the output file not formulas.

Thanks in advance
Dec 11 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.