-
Automatic Opening, Saving Closing a Workbook...
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.
Sorry for being so incompetent, I just need help from some smart people.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules