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

I still don't see a reason why menumaker wouldn't work.

Chuckles123 wrote:

Dave,
The code and data are totally separated. The data is generated, in a
standard format, each time that the non-Microsoft software is used to
produce a report and the custom report option of output to an Excel
workbook is selected -- at this point, there is zero code in the
workbook. Then when a Custom Button is clicked-on, the linked macro
that is stored in an .xls or .xla file is executed (this .xls or .xla
file has zero data).

I am still pursuing the .xla solution. Part of the difficulty is the
instability of whether there is a check-mark next to the appropriate
Add-In on the menu displayed after selecting ToolsAdd-Ins.

By the way, we are using Excel 2002, SP-2.

Regards,
Chuckles123

--
Chuckles123
------------------------------------------------------------------------
Chuckles123's Profile: http://www.excelforum.com/member.php...o&userid=14948
View this thread: http://www.excelforum.com/showthread...hreadid=265915

--

Dave Peterson