How come my macro works if I pause and play again?

K

Kenji

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
 
B

Bob Phillips

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)
 
T

Tushar Mehta

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
 
Top