Have you tried using the GetSaveAsFilename Method? I think this would be
a more straightforward way to go.

I hadn't thought of that one. That works fine in a module, but when I put
it in the Before save  event it prompts to save it twice even though I turn
off alerts before I save.

Any ideas  on that one?

Never seen that. Why not put it in a module then call the sub from
the event? Would that work?

Tried that. Still does the same thing.

Want to post the whole code  you're using including this new
method?

Sure....this is way one:

************************
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Dim weekending As Date, weektext As String
Dim filename  As String


weekending = Sheets("Corporate").Range("g5").Value2
weektext = Replace(weekending, "/", "")

filename = Application.GetSaveAsFilename("C:\Reports\Marketing\Top 50\top 50
w-class 1 " & weektext & ".xls")

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs filename, xlNormal

Application.DisplayAlerts = True

End Sub

This is way two - using the event  to call a sub

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)

End Sub


and this is the sub in a module:


Private Sub saveit()
Dim weekending As Date, weektext As String
Dim filename As String


weekending = Sheets("Corporate").Range("g5").Value2
weektext = Replace(weekending, "/", "")

filename = Application.GetSaveAsFilename("C:\Reports\Marketing\Top 50\top 50
w-class 1 " & weektext & ".xls")

Application.DisplayAlerts = False

ActiveWorkbook.SaveAs filename, xlNormal

Application.DisplayAlerts = True

End Sub

Any ideas? I'm pulling my hair out on this one.

Just a thought, but this event  triggers before the save, and doesn't
stop the save  which triggered it in the first place. Don't you need a
'Cancel' in there to stop the requested Save?

I just tried adding a cancel = true  line to each of the different ways I've
tried this (with and without calling a sub), and both of them still made me
save twice.

*sigh* At this point, I'm thinking I'll just add a line to the documentation
that says to click save  both times the "save as" box  pops up.

Not followed this thread really so fprgive me if it's off base but...
If it's a timing thing  a well placed DoEvents may solve it.

but I can't see that a Doevents wouldn't help here.
The problem is I have code  in an event  (beforesave), but it's prompting the
user with the saveas dialog  twice. If you have specifics on how the
DoEvents might work, I'd be happy to hear them.

While at this point I've basically given up trying to solve it before
turning over the project, I'm still open to ideas  anyone has on what's
causing that.