Needing to move data from one document to another easiest way possible.
Hello Everyone,
Im trying move data from one excel document to another document. Is there any way to incorporate a Macro that can pull data from an excel document without it being open? ... or do i need to open the document and Move that data into a sheet and have it pull? I was thinking of keeping the name stagnant to see if it will pull?? anything??? ..
what is the best way to get this done?
suggestions and examples would be greatly apprecaited...
Thanks Everyone
Hi, Ernieballzbass,
IŽd go with opening a workbook from a dialog, copy and paste, close the workbook again.
Concerning copying from closed workbooks: have a look at Copy a range from closed workbooks (ADO) (with a sample file).
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks