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