Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How come my macro works if I pause and play again?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How come my macro works if I pause and play again?
Kenji,
What's the value of "Application.DefaultFilePath" ? NickHK "Kenji" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How come my macro works if I pause and play again?
See my response in .Misc.
-- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Kenji" wrote in message ... 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 |
#4
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 |