Invoking 'BeforeSave' from macro in another Workbook

jasonking · Apr 25th, 2002, 09:14 AM

- I have a Workbook 'A' that contains a macro, which places data into Workbook 'B'.
(Note that both Workbooks are loaded in Excel).

- B contains code in it's 'BeforeSave' event, which protects the sheets before it is saved.

- The last command of the macro in A, saves B. So, the 'BeforeSave' event is invoked.

- However, Excel happily runs the code in the 'BeforeSave' but doesn't actually perform the commands! The result is no protected sheets in B.

The 'BeforeSave' event code works fine on its own, but doesn't seem to work when invoked by another macro??

Note: I am using Excel 2000 with all the latest patches installed.

Please could anyone help.

Many thanks,
Jason

[ This Message was edited by: jasonking on 2002-04-25 08:24 ]

nancyo · Apr 25th, 2002, 10:48 AM

I am new to macros, and have NO programming experience. Most of the simple macros I use are modified from others, if I can figure out how to modify it. How does one go about saving data from workbook A in workbook B?

I have to do this in excel (one worksheet only from A into B, but be must be created and saved with the macro).

I have posted a similar question before on how to do this from excel to word, and was never able to figure that our either...

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 09:14 AM	#1
jasonking New Member Join Date: Apr 2002 Posts: 3	- I have a Workbook 'A' that contains a macro, which places data into Workbook 'B'. (Note that both Workbooks are loaded in Excel). - B contains code in it's 'BeforeSave' event, which protects the sheets before it is saved. - The last command of the macro in A, saves B. So, the 'BeforeSave' event is invoked. - However, Excel happily runs the code in the 'BeforeSave' but doesn't actually perform the commands! The result is no protected sheets in B. The 'BeforeSave' event code works fine on its own, but doesn't seem to work when invoked by another macro?? Note: I am using Excel 2000 with all the latest patches installed. Please could anyone help. Many thanks, Jason [ This Message was edited by: jasonking on 2002-04-25 08:24 ]

Apr 25th, 2002, 10:48 AM	#2
nancyo Board Regular Join Date: Mar 2002 Location: Massachusetts, USA Posts: 255	I am new to macros, and have NO programming experience. Most of the simple macros I use are modified from others, if I can figure out how to modify it. How does one go about saving data from workbook A in workbook B? I have to do this in excel (one worksheet only from A into B, but be must be created and saved with the macro). I have posted a similar question before on how to do this from excel to word, and was never able to figure that our either...