Save As Dialog box in the way

**jomili** · 06-04-2010, 01:12 PM

I have a series of macros, the first of which askes the user to save two other workbooks by pulling up the "Save As" dialog box. Once they've hit the last "Save" a combo box allows them to pick a region they want to work on. My problem is that my combo box comes before the Save As box goes away, and I don't want my users to be seeing the Save As box the entire time the macro is running.

I tried adding a timer to wait for the SA box to go away, but that's a very inefficient way to time it. Is there a way to trigger my next macro (the combo box) by looking at when the SA dialog box finishes?

I've posted my current code below. I've tried setting a timer, but since I have 20 different users on machines of varying speeds I don't know exactly where to set it.

First part of code (workbook open). After the SaveAPR, I have a macro perform substitutions in another spreadsheet, then I load my popup.

Please Login or Register  to view this content.

Next part. Notice I set a timer at the end of the SaveAPR code. I don't know if that's the best place for it.

Please Login or Register  to view this content.

I appreciate any help I can get on this. Thanks in advance.

**royUK** · 06-04-2010, 01:15 PM

What do you do with the saveas dialog?

**jomili** · 06-04-2010, 01:21 PM

My main workbook pulls and manipulates data from two other workbbooks that are generated on a weekly basis. These two workbooks have variable names depending on the time and date they were created. The Save As is to renamed them as APR .xls and ESS.xls so I can call them consistently throughout my routine.

**jomili** · 06-04-2010, 02:26 PM

Well, sometimes I'm just too stupid for words. I fixed it, and it was way too easy. In my "SaveAPR" macro, at the beginning I turned off screen updating, and never turned it back on, so my SaveAs box stayed up. Turning off the screen updating made all the difference, and I'm good to go now.