Posted to microsoft.public.excel.programming
|
|
Sending Personal.xls Files To Multiple Users
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
|