Sending Personal.xls Files To Multiple Users
 

Dave,

Thanks for your reply, but I don't think this approach will work fo
me.
My application is as follows:
Using some financial software that we subscribe to, a report o
selected securities is created. One of the report options is to outpu
to an Excel workbook; thus, a new workbook is opened each time th
report is run. My objective is for each network user to have access t
shared macros that would operate on this workbook. Access would be vi
clicking-on Custom Menu Buttons on the Standard Toolbar; these button
would be linked to various shared macros.

This objective can be achieved by e-mailing each user a workbook (wit
a name anything other than Personal.xls) that would be stored in eac
user's XLSTART folder. The e-mailed workbook would include a macro t
store the file in the appropriate folder (would have to be customize
for each user on the network).
Each user's Standard Toolbar contains buttons linked to specific macro
in the common workbook (identical except for the customized sav
macro).

Gord indicated that saving the workbook as an .xla file on a share
network drive as an alternative. I am still pursuing that solution.

Thanks again,
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

Sending Personal.xls Files To Multiple Users
 

It sounds like you have the code duplicated in each of the workbooks you open.

If that's the case, it might be time well spent to separate your code from the
data.

It's a real pain to fix code in who knows how many workbooks--instead of just
fixing it in the addin (I like Gord's idea) once and either redistributing it
(or updating the network location).

But take a look at John Walkenbach's menumaker. I still think that it may do
what you want.

Chuckles123 wrote:

Dave,

Thanks for your reply, but I don't think this approach will work for
me.
My application is as follows:
Using some financial software that we subscribe to, a report on
selected securities is created. One of the report options is to output
to an Excel workbook; thus, a new workbook is opened each time the
report is run. My objective is for each network user to have access to
shared macros that would operate on this workbook. Access would be via
clicking-on Custom Menu Buttons on the Standard Toolbar; these buttons
would be linked to various shared macros.

This objective can be achieved by e-mailing each user a workbook (with
a name anything other than Personal.xls) that would be stored in each
user's XLSTART folder. The e-mailed workbook would include a macro to
store the file in the appropriate folder (would have to be customized
for each user on the network).
Each user's Standard Toolbar contains buttons linked to specific macros
in the common workbook (identical except for the customized save
macro).

Gord indicated that saving the workbook as an .xla file on a shared
network drive as an alternative. I am still pursuing that solution.

Thanks again,
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