How to copy a field of A excel file to B Excel file automatically?

D

Dot Dot Dog

I need to copy some fields of A.xls to B.xls every night at 12:00. how can I
do that?
 
S

Stephen Knapp

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.

Steve in Ohio
 
D

Dave Peterson

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.
 
Top