C
Chris Smith
Hello all!
I have a DB with a query that I need to get the data out to excel while autogenerating the file name with a field. Initially, I wanted a date range if possible...
IE. NewGradList_01-01-08_to_11-01-08.xls
Previously, I was using a date stamp ->
="NewGradList_" & Format(Date(),"mmddyy") ; however now I need to use a range. These ranges will vary each time the report is ran by the 'end-user'. When the Parameters are entered ->
[Enter Start Day ~ Example mm/dd/yy] and [Enter End Day ~ Example mm/dd/yy] I was going to append those to the table and pull those dates into the File name, then once the Query is finished I was using a SendObject-Range only function to include all fields except for the date paramenters I just appended to the query.
Not sure if that all made any sense =) I know its a lot of loaded questions! Any assistance or insight would be most appreciated! I am willing to do it in SQL or VB... just not sure of the steps.
Thank you all!
I have a DB with a query that I need to get the data out to excel while autogenerating the file name with a field. Initially, I wanted a date range if possible...
IE. NewGradList_01-01-08_to_11-01-08.xls
Previously, I was using a date stamp ->
="NewGradList_" & Format(Date(),"mmddyy") ; however now I need to use a range. These ranges will vary each time the report is ran by the 'end-user'. When the Parameters are entered ->
[Enter Start Day ~ Example mm/dd/yy] and [Enter End Day ~ Example mm/dd/yy] I was going to append those to the table and pull those dates into the File name, then once the Query is finished I was using a SendObject-Range only function to include all fields except for the date paramenters I just appended to the query.
Not sure if that all made any sense =) I know its a lot of loaded questions! Any assistance or insight would be most appreciated! I am willing to do it in SQL or VB... just not sure of the steps.
Thank you all!