LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default Add-Ins: remote macro updates

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A macro that shows updates - PLEASE HELP! Sapphire69 Excel Programming 0 June 8th 06 02:51 PM
Macro updates Glen Mettler[_4_] Excel Programming 3 June 29th 05 01:02 AM
Macro updates and link goes #REF! ??? Rob Smith Links and Linking in Excel 1 February 16th 05 01:03 PM
Calling a macro on a remote computer Maury Markowitz Excel Programming 0 February 10th 05 05:21 PM
Macro crashes excell from remote location Josh[_10_] Excel Programming 0 July 14th 04 03:41 PM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"