Changing macro localisation permamently

[Szwadron6]

Hi,

I am facing a little problem with the connection my macros to the original file.

1. I created the file on my "C:" drive
2. When it was all settled down I transferred it to the common drive in my organisation "U:"
3. One of thing that my macro does is to change a new workbook and saves it in the specific location.
4. The new created workbook also contains macro which is the part of the original workbook and that macro can be enabled by clicking the right button. The problem is that this new created file refers to the original path of the workbook "C:\Urlopy" instead of the new path of the workbook U:\Urlopy

I did not copy the original file to the new localization. I cut it and pasted it. So there is no file like that in the original localization.

The question is:
How can I change localisation of the macro? The problem also attached.

[dflak]

This code has been marginally tested. If all you are changing is the drive letter (the path is the same), then this code should work. If you are changing more than you need to identify the full path to the workbook in both the old and new directory structures.

Please Login or Register  to view this content.