| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How come my macro works if I pause and play again?
When and how is the code executed? Is it part of an event procedure?
-- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , kenji4861 @burningmail.com says... I have this code ---- ThisWorkbook.SaveCopyAs Application.DefaultFilePath + "\" + "temp.xls" ---- When I run the macro from the front page, it'll give an, "Method 'SaveCopyAs' of object '_Workbook' failed. however, if I click debug and hit "play" again, the code will go through just fine. Is there a fix for this? Kenji |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pause a macro | Excel Discussion (Misc queries) | |||
| How do I pause a macro? | Excel Discussion (Misc queries) | |||
| Pause Macro 2 | Excel Discussion (Misc queries) | |||
| Pause during a Macro | Excel Programming | |||
| Pause macro | Excel Programming | |||
Hybrid Mode
