On 27 Jan, 12:28, Alan wrote:
On Jan 27, 10:16*am, Snoopy wrote:





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

The remaining questions a
1. How do I make the two files cooperate/how does it work?

* *You need to "reference" the add-in from within TEST.XLSM

* * Go to the VBA editor for TEST.XLSM and goto <Tools<References
* * Browse to add your new add-in to the list and make sure that the
* * check box is ticked.

2. Is it wise to delete the macros in TEST.XLSM when the files just
use macros in TEST.XLAM?

* *When the add-in is operational the old code serves no purpose and
the fact that you effectively have two macros with the same names will
cause errors. You should delete it - if you feel unhappy about
pressing the delete button just comment the code out until you gain
confidence.

3. If I - by occasion - rename the TEST.XLSM to TEST1.XLSM - will the
macros still refere to TEST.XLAM?

* * Yes, it will still refer to the add-in because the newly named
file maintains it's reference.

A.– Skjul sitert tekst –

– Vis sitert tekst –

Thanks
I still strugle:

I have saved the add-ins as TEST.XLAM - directly to disc F:
Then I went to <Tools<References i in VBA editor of the TEST.XLSM
file
The browsing (Add Reference dialog box) will not visualize the add in
which look for Files of type = (*.olb,*tlb,*.dll)
By searching for all files I find my TEST.XLAM all right, but choosing
this one seems to generates a add-in called VBAProject.
All together this causes a VBA failure called Name conflicts with
existing module, project or object library

I feel I am close to the solution, but dont see what to do next,
kindly ask you guys for som more help and guiding :)
Best Regards
Snoopy