Excel2007 VBA macro copy all data from one excel file to another

Closed
THOMGALB Posts 1 Registration date Wednesday March 12, 2014 Status Member Last seen March 12, 2014 - Mar 12, 2014 at 04:56 PM
 Blocked Profile - Mar 12, 2014 at 05:52 PM
Hi all,

I'd like to create a macro in an excel file, that pulls all data from all sheets from another excel file without actually opening the other file.

Is this possible to do with a simple code? - the simpler the better....

Thanks!

Thomas

1 reply

Blocked Profile
Mar 12, 2014 at 05:52 PM
Thomas,

What a wonderful question. No.

You either need DDE [Dynamic Data Exchange(VBA)] or link them in software. Either way, the file HAS TO BE OPENED in order to be accessed, right?

You could dumb that excell file to a text file, and manipulate that, but it will still need to be opened. But the text file would be opened, and much easier to index then a complicated excel. Just a thought!

Have FUN!
0