Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hey Guys :)
Austris hav push me a bit forward on this (thanks a lot), but I have to move further. I have a number of local/remote workbooks using macros. Once in a while I have/want to update/adjust these local mprograms. I understand that this can be done by using add-ins in the local files, but I am not comfortable with the method. My starting point is this: The file TEST.XLSM is saved as TEST.XLAM (Add-In) and the two files are identical. Now I want the (visible) TEST.XLSM to use the macros of the (invisible) TEST.XLAM. I understand that this will have the effect that macros in TEST.XLAM will be used on data in TEST.XLSM - am I right? This is the ending point of mine ..... The remaining questions a 1. How do I make the two files cooperate/how does it work? 2. Is it wise to delete the macros in TEST.XLSM when the files just use macros in TEST.XLAM? 3. If I - by occasion - rename the TEST.XLSM to TEST1.XLSM - will the macros still refere to TEST.XLAM? I hope someone will be kind to update my skills by guiding me on this one. Best regards Snoopy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A macro that shows updates - PLEASE HELP! | Excel Programming | |||
Macro updates | Excel Programming | |||
Macro updates and link goes #REF! ??? | Links and Linking in Excel | |||
Calling a macro on a remote computer | Excel Programming | |||
Macro crashes excell from remote location | Excel Programming |