atermeer
09-02-2007, 10:03 PM
Hello -
Hope this is in the right place...
I need help with a workbook I have that automatically updates from an external database:
The workbook needs to open every day automatically and, at 8:00 AM needs to save with the filename including yesterday's date. My problem on the next external refresh after 8:00 AM, instead of populating the last row of cells with 8:00 AM data, the query changes the date to the current date (correctly) and the 8:00 AM info now reverts back to the top row of data...
I need it to populate the last row to complete a day's cycle (8:00 AM to 8:00 AM, yesterday to today), save as "Excelfile yyddmm" to specified network folder, and then revert to the new day's file.:doh:
Sorry for being so incompetent, I just need help from some smart people.
Hope this is in the right place...
I need help with a workbook I have that automatically updates from an external database:
The workbook needs to open every day automatically and, at 8:00 AM needs to save with the filename including yesterday's date. My problem on the next external refresh after 8:00 AM, instead of populating the last row of cells with 8:00 AM data, the query changes the date to the current date (correctly) and the 8:00 AM info now reverts back to the top row of data...
I need it to populate the last row to complete a day's cycle (8:00 AM to 8:00 AM, yesterday to today), save as "Excelfile yyddmm" to specified network folder, and then revert to the new day's file.:doh:
Sorry for being so incompetent, I just need help from some smart people.