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
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