ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sending Personal.xls Files To Multiple Users (https://www.excelbanter.com/excel-programming/312759-sending-personal-xls-files-multiple-users.html)

Chuckles123[_22_]

Sending Personal.xls Files To Multiple Users
 

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


Dave Peterson[_3_]

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



All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com