Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Add-in problem; button changes add-in path
I recently created some new EXCEL VB tools that are becoming popular in
my office. I put all in one workbook and saved it as an XLA file. This file is then copied under the c:\program files\ directory in every users PC. I have created excel workbook templates that interface this software. These templates have several macro buttons on the spread sheets that call the sub procedures in the add-in. Note, when assigning the macro, the list does not show the addin sub procedures. I just typed in the name of the sub in the assign Macro dialog box. This works great until I found a little problem. When the template is copied from the server to the hard drive and then back to the server, Excel tries to "fix" the relative reference for the marco assigned to the buttons. Now the button is looking for the add-in in \\serveraddress\program files\ instead of c:\program files\. This is quit annoying since now the template buttons needs to be re-assigned back to the marcos. How can I keep the Excel from changing the address of the add-in marco. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the path behind a button | Excel Discussion (Misc queries) | |||
Problem with references while opening Excel from IE using UNC path | Links and Linking in Excel | |||
Browse button on form for folder path | Excel Discussion (Misc queries) | |||
UNC Path length problem opening a file in excel 2002 or 2003 | Excel Discussion (Misc queries) | |||
Path\File name length problem Excel Crash on save as | Excel Discussion (Misc queries) |