Till yesterday this code was working fine. We had an update in our company and somehow the DLLs changed and now i am not able to save some sheets from a directory to a master workbook by adding the right names of those excel files.
Somehow this line of code doesn't do it's job anymore.I would appreciate is someone could advise.
Please Login or Register to view this content.
Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you.
Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
What was the error?
What were the values of i and m when it failed?
If this is code that was working previously the change is more likely to be in the workbooks being manipulated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks