I'd try one of two methods. First, use the MS Windows "scheduler" to
fire off you spreadsheet at midnight (make sure to leave the computer turned
on) and have a VBA macro triggered when the workbook is opened to perform the
data movement. A second, albeit more difficult method, would be to write VBA
code to structure an internal timer that would watch for midnight. In this
case, you'd have to open the workbook before going home for the day, and
activate the macro that sets up and runs the timer.
I think I'd try to use a Windows Scheduling program (may be included in your
version of windows) that opens a workbook that contains a macro named:
Auto_open.
This auto_open macro would open both A.xls and B.xls and do the copy, then close
(and save??) the workbooks.
I think I'd start by recording a macro that did the work. Then test the heck
out of it by running the macro manually.
If you need help with your recorded macro, post back.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
