Pausing macro while saving (XLM)

I

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?
 
B

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top