Invoking 'BeforeSave' from macro in another Workbook

[jasonking]

- 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]

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...