Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Signing a Code that uses a Custom XLA file (Location problem)
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code for Select a file and save it in a different location | Excel Programming | |||
how to request Code-signing certificate | Excel Programming | |||
Security Signing of VBA Code | Excel Programming | |||
File Location code | Excel Programming | |||
VBA Code Signing | Excel Programming |