I have several workbooks all containing the macro "Update". As part of other code stored in my personal workbook, I want to run the "update" macro. How can I execute "Update" from the personal folder, on several files with different file names? Each workbook, one at a time, will be individually opened when the code is executed. Thanks.
You need to post the code.
basically you will need to make sure the code runs with ActiveWorkbook otherwise it will try to run with the personal workbook
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
From what you have written, the code is already in the Personal Macro Workbook.
Press Alt & F8, select the macro to run.
Do you mean that you want to automate the opening of each file, run the code, save & close. Be more specific with the question
Below is the code (CyRegCasesConvert2010) that is stored within my personal workbook. I want to open several files, manually and one at a time, make some manual adjustments and then run CyRegCasesConvert2010 on the open workbook. At the end of the CyRegCasesConvert2010 procedure, I want to start another Sub, named "Update". The update sub is stored within whatever workbook is open, and is slighlty different for each file so I cant just add that code to the end of CyRegCasesConvert2010.
I would add a line like
but the file name is obviously different for each time.
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks