MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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