How can I Copy the first worksheet of one open worbook in the first worksheet of several other workbooks that are closed. Example : copy sheet 1 of workbook 1 in the first sheets of workbook 2, workbook 3, workbook4, etc , all them are closed
How can I do by code vba
try this code
Please Login or Register to view this content.
If solved remember to mark Thread as solved
Hi khracking,
unfortunately you did not write how the macro should know which files need to be opened. I have therefore assumes there is a separate worksheet (called "Files") which has the path (ending with a \) in column A and the filename in column B.
Please let me (and the other forum members) know if this works as expected - and don't forget to close the thread if it does.Please Login or Register to view this content.
Last edited by Fettertiger; 09-29-2012 at 05:39 PM.
Remember To Do the Following....
1. Upload sample files
2. Thank those who have helped you by clicking the Star below the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Your two separate threads have been merged. Do not post the same question multiple times, it leads to wasting people's time, and I'm sure that's not what you want to happen. Take a moment to read the Forum Rules. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks