Pausing macro while saving (XLM)

[Ian Page]

I have a whole bunch of macros written in the old Excel 4 macro language (I
don't know VBA - sorry). These generally work fine under Excel X, but I have
one issue that I can't solve.

My code calls a Save As... dialogue. Under XL for OS9, the macro pauses
until the user has saved. Under XL for X, the macro just continues to run (I
guess because Save sheets in OS X aren't modal) - this produces errors in
the ensuing code, due to unsaved changes in the worksheet.

Has anyone a suggestion as to how I can get the macro to pause until the
Save As... has executed, and then resume without user intervention?

 

[Bob Greenblatt]

I have a whole bunch of macros written in the old Excel 4 macro language (I
don't know VBA - sorry). These generally work fine under Excel X, but I have
one issue that I can't solve.

My code calls a Save As... dialogue. Under XL for OS9, the macro pauses
until the user has saved. Under XL for X, the macro just continues to run (I
guess because Save sheets in OS X aren't modal) - this produces errors in
the ensuing code, due to unsaved changes in the worksheet.

Has anyone a suggestion as to how I can get the macro to pause until the
Save As... has executed, and then resume without user intervention?

Can you be a little more specific? Do you use a save.as?(...) what's
happening right after the save that causes the problem?