Dear experts
I have N number of xlsb workbooks in target path i want add four sheets in every closed workbook from particular file. i getting tired by doing manually for this task
i have files like Jan,Feb,Mar,....etc in path folder C:\Users\Zionscar\Desktop\fy-16. and
i have saved separate workbook called zonefile.xlsb in separate path with four sheet zone1,2,3,4 i want add these four sheets into every files in target path.
please find the attachment
Hi breadwinner
I've assumed this is a one time shot (there's no error checking to see if the Worksheet already exists).
Change the File Paths for the Source and Target Folders.
Place the Attached Code Book anywhere you please; click the Button. I'd strongly suggest you run the Code on copies of your Target Files.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks