Hi,
I am fairly new to the whole Macro scene and need some help please. I am looking for a macro that will copy a sheet from 1 workbook and copy it into several closed workbooks, all saved in the same folder. I have been playing with the below but can't seem to get it to work. Any help greatly appreciated.
Please Login or Register to view this content.
Last edited by jeffreybrown; 05-18-2016 at 07:22 AM. Reason: Please use code tags when posting code
How is the code not working?
If posting code please use code tags, see here.
Hi,
It does not seem to be doing anything. I click on Run and no error messages or anything but the files in the folder also haven't been updated. All the tabs on the destination workbooks are hidden if that makes a difference? Thanks
In the first If statement for checking the file extension you have ThisExt, surely it should be FileExt.
By the way, those if statements seem a wee bit convoluted, what are you actually checking for?Please Login or Register to view this content.
To be honest mate I picked the code off the web to try and resolve the issue. I'm more than happy to start from scratch to solve my problem if anyone can point me in the right direction.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks