Re: How come my macro works if I pause and play again?
From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 02/26/04
- Next message: Shetty: "How to disable hide/unhise command by user?"
- Previous message: BrianB: "Re: Using "Like""
- In reply to: Kenji: "How come my macro works if I pause and play again?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 14:56:54 GMT
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 <#qxHjjE$DHA.3828@TK2MSFTNGP10.phx.gbl>, 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 > > >
- Next message: Shetty: "How to disable hide/unhise command by user?"
- Previous message: BrianB: "Re: Using "Like""
- In reply to: Kenji: "How come my macro works if I pause and play again?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
