Hi,
I have an excel template that is macro enabled. However, when I save a new copy of the template under a different file name the macros are still linked to the original template name, is there a way to ensure that when a copy of the template is saved that the macros automatically update to that new file name and thus still work?
Many thanks,
Jaymie
It shouldn't work like that. The code should not link to another file, if written properly. Can you either post the file, or show all the code? And describe what module contains what code?
To post a file:
- Under the text box where you type your reply click the Go Advanced button.
- In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
- In the pop-up, click Add then Select to select a file from your local drive
- Click the Upload button to upload the file
- Click Done to attach it.
It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.
I don't know if it possible but I have a template that people can use however have to save a new copy of the template to be able to use it. Ideally the macro that is in the template would be transferable to what ever the person changed the file name to.
For example in the attached image "eeeeeeeeeeee.xltm" would become the new file name, therefore enabling the new macro to work?
I hope this makes sense.
Jaymie
An image is not useful. Attach your file, or at a minimum paste in your code, and use CODE tags.
Please Login or Register to view this content.
The correct way to use a template is to create a new Excel file using the template. Then you have a new file called Book1.xlsm that you can save. They should not be opening the template directly. If you want a file they can open directly then make a copy of, a different approach is required.
If this file is used as a true template, then the following changes would be required for the code and the file name doesn't matter.
Which worksheets in each of the workbooks do you want to work with? Explicitly identifying worksheets is much better than depending on what window is open. I have assumed that you are working with Sheet1 in both cases, but you will need to tailor that to your situation.
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