pausing a "save as" macro

  • Thread starter Thread starter mocc
  • Start date Start date
M

mocc

im trying to pause a macro so i can have the final say which folder my
document goes. i have to save a document on a daily basis. i want it to save
it as 'todays' date and name of my choice. i want ithe macro to run untill
the 2008 folder then stop. and give me the final say what month to put it in.
any ideas?
 
It sounds like you simply want to show the SaveAs dialog box... you can do as
follows:

Sub Example()
Dim oDialogSaveAs As FileDialog

Set oDialogSaveAs = Application.FileDialog(msoFileDialogSaveAs)

With oDialogSaveAs
.InitialFileName = Format(Date, "ddmmmyyyy")
.Show

End With
End Sub

If that's not it. Post the code you have.

--
Best regards
Robert, Excel MVP
Author of RibbonX: Customizing the Office 2007 Ribbon:
Find me at http://www.msofficegurus.com - be part of it!
FORUM: http://www.msofficegurus.com/forum/
 
Back
Top