Extract data from another excel file using a macro

Posted by jgm on January 03, 2001 7:43 PM

I would like to pull data from another excel file using a macro without opening the file i am pulling data from.

Posted by Dave on January 04, 2001 2:13 AM

Hi jgm

You may find the easiest way in the long run is to have a macro insert a simple =Book1!A1 and copy it down and across acordingly.
OzGrid Business Applications