Nick!
Thanks for the quick reply. I have already got:
Sub SaveAs1()
'
' SaveAs1 Macro
' Macro recorded 03/04/2006 by GB
'
' Keyboard Shortcut: Ctrl+e
'
ActiveWorkbook.SaveAs "C:\Windows\All users\desktop\" & Range("E2")
& ".xls"
End Sub
...which directly saves the workbook under the name in "E2". I am
trying to still generate the same file name but want to force a Save As
with the name coming up in dialog box and the destination file also.
User to click on Save As to complete.
Thanks for your input so far,
DS
--
dunescratcher
------------------------------------------------------------------------
dunescratcher's Profile:
http://www.excelforum.com/member.php...o&userid=33114
View this thread:
http://www.excelforum.com/showthread...hreadid=529322