pausing a "save as" macro

[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?

 

[Robert Martim, Excel]

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/