PDA

View Full Version : Automatic Opening, Saving Closing a Workbook...



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.