LinkBack URL
About LinkBacks
There is a similar thread I found to this one but I can't seem to get it working, keeps saying that the file is already open.
Looking to go through a folder of files and open/run/save/close each macro:
Please Login or Register to view this content.
There is a similar thread I found to this one but I can't seem to get it working, keeps saying that the file is already open.
Looking to go through a folder of files and open/run/save/close each macro:
Please Login or Register to view this content.
Hi,
It seems that you open each file, but you don't close it again.
Greetings,
Cheetahke
The probllem is as Cheetahke says file is not closed but. Try adding
As you seems to operate on the opened workbook I assume you wish to save the changes done to that workbook. But if you are reading data from opened file to a master file then you should keep the opened workbook in it's original state i.e.Please Login or Register to view this content.
AlfPlease Login or Register to view this content.
Last edited by Alf; 10-21-2015 at 01:27 AM.
I am still getting problems with the below code:
I am getting a sub or fx not defined:Please Login or Register to view this content.
in the context of:
Please Login or Register to view this content.
Where is the sub UpdateData actually located?
Is it in the workbook the code is in or the workbook you are opening?
If posting code please use code tags, see here.
Hi Nor,
It is in the workbook I am opening.
So basically I want to open each workbook in a folder (one at a time)>run UpdateData macro>save&close.
You'll need to use Application.Run then.
Please Login or Register to view this content.
So in place of the subroutine?Please Login or Register to view this content.
Yes, that's right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks