Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to relax workbook links??
Hi,
is there a way to relax Excel's treatment of workbook links? I've made a plug-in authored in VBA, saved as an XLA file. It contains some custom functions that are used to retrieve data from the web app. When the user chooses a menu item in the web app, JavaScript in the page instantiates Excel and downloads the plug-in simply by opening it from a url; i.e. Excel.Workbooks.Open(pluginURL). My problem occurs when a user saves her spreadsheet, later reconnects to the web, starts Excel from the menu (so the plug-in is loaded) and re-opens the saved spreadsheet. If the plug-in is opened from the exact same url everything is fine. But if it is a different web server (or simply an alias, e.g. example.net instead of www.example.net) it does not. Excel then complains about broken workbook links. In the formula bar, references to plug-in functions are "fully qualified" with the url after re-opening a saved workbook, e.g. "http://www.exampleUrl.net/myplugin.xla!myfunction (args)". Removing the workbook reference so only "myfunction(args)" remains rectifies the problem; however it's back next time the book is opened. So what I need is one of the following: - save workbook with function references without workbook qualifiers. - have Excel ignore the workbook qualifier in function references - programatically remove workbook qualifier from formulas in the spreadsheet. Any help would be greatly appreciated. Happy coding, Dag Johansen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook links | Excel Discussion (Misc queries) | |||
Links to other workbook | Excel Worksheet Functions | |||
My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
Workbook Links | Excel Worksheet Functions | |||
Possible to relax workbook links?? | Excel Programming |