Dave,
The code and data are totally separated. The data is generated, in
standard format, each time that the non-Microsoft software is used t
produce a report and the custom report option of output to an Exce
workbook is selected -- at this point, there is zero code in th
workbook. Then when a Custom Button is clicked-on, the linked macr
that is stored in an .xls or .xla file is executed (this .xls or .xl
file has zero data).
I am still pursuing the .xla solution. Part of the difficulty is th
instability of whether there is a check-mark next to the appropriat
Add-In on the menu displayed after selecting ToolsAdd-Ins.
By the way, we are using Excel 2002, SP-2.
Regards,
Chuckles12
--
Chuckles12
-----------------------------------------------------------------------
Chuckles123's Profile:
http://www.excelforum.com/member.php...fo&userid=1494
View this thread:
http://www.excelforum.com/showthread.php?threadid=26591