M
Manoj Sheth
Hi,
Here is what I want to do. I have a library of functions in XLA file and I
have several XLS files with their VB programming - that uses the XLA file. I
need to distribute the XLS files to my users through a website. I need to
sign macro code in my XLS file.
It seems to be a limitation that the XLA files reference have to be in a
fixed location for the macro signature to remain valid.
The problem that I face is that,
When I distribute my XLA files to customers - where should I ask them to put
it?
(a) c:\Documents and Settings\<user_name>\Application Data\Microsoft\Addins
is useless as it changes from user to user - and that makes my XLS signature
invalid.
(b) C:\Program Files\Microsoft Office\OFFICE11\Library is useless if the
user has Excel2000 with him (where the library location is different).
So how can I solve distribute my XLA without asking users to keep them in
one place and register them (and not have them reduce their Excel security)?
Here is what I want to do. I have a library of functions in XLA file and I
have several XLS files with their VB programming - that uses the XLA file. I
need to distribute the XLS files to my users through a website. I need to
sign macro code in my XLS file.
It seems to be a limitation that the XLA files reference have to be in a
fixed location for the macro signature to remain valid.
The problem that I face is that,
When I distribute my XLA files to customers - where should I ask them to put
it?
(a) c:\Documents and Settings\<user_name>\Application Data\Microsoft\Addins
is useless as it changes from user to user - and that makes my XLS signature
invalid.
(b) C:\Program Files\Microsoft Office\OFFICE11\Library is useless if the
user has Excel2000 with him (where the library location is different).
So how can I solve distribute my XLA without asking users to keep them in
one place and register them (and not have them reduce their Excel security)?