Add-in udf

[Barry]

I've a spreadsheet that use functions in an add-in;
however, if I open it from Access vba it complains that
there are function links with another file and the cells
are showing #NAME# even I response with updating the
links. If I open the spreadsheet by hand everything's
fine. Anyone has idea what I can do to solve the problem?

 

[Rob Bovey]

Hi Barry,

What kind of add-in are you talking about. Is it an Excel workbook you
created, an add-in that comes with Excel, or something else? A better
solution might be to simply use xlApp.Workbooks.Open to directly open the
add-in file instead of using the AddIns.Installed method.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *