Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is Add-In path associated with save location
Using Excel 2003 with an Add-In I created. Here is the behavior I am trying
to understand. The Add-In is located in the Microsoft Add-Ins folder under My Documents. I create a workbook and save it to drive C (CreatedOnDriveC.xls). I create another workbook and save it to drive F (CreatedOnDriveF.xls). Both workbooks use functions from the Add-In. I now copy the workbook created on drive C to drive F and copy the workbook created on drive F to drive C. Each drive now contains copies of both files. I can open both files from drive C and they update properly. I can open the file created on drive F from drive F and it updates properly. The problem arises when I open the file created on drive C and then copied to drive F from drive F. When I try to open CreatedOnDriveC.xls from its location on drive F, I get the update links message. The problem is that the links now refer to a path on drive F that does not exist (F:\....\AddIn.xla!FunctionName()). The path is correct except for the drive letter. Why would Excel change the drive reference when it knows where the Add-In is installed? This is confusing because Excel had no problem opening the drive F file from it location on drive C. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you assign a Workbook Location Path to a cell? | Excel Worksheet Functions | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
Excel 2007 - File Path location | Excel Discussion (Misc queries) | |||
print file path and location in a footer | New Users to Excel | |||
how do i set file location path? | Excel Programming |