Thread
:
Allowing user to choose to accept saveas option
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Allowing user to choose to accept saveas option
Why are you posting the same question with a different name 13 minutes
later?
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Tel" wrote in message
...
I've managed to create the "saveas Macro using cell contents".
However, it automatically saves it to my documents.
Here's my code
Sub save_it()
Dim fname
With ActiveWorkbook
fname = "VMRP_" & .Worksheets("TEST").Range("A1").Value & "_" &
.Worksheets("sheet2").Range("B3").Value & ".xls"
.SaveAs fname
End With
End Sub
Is it possible to insert a break which brings up the saveas dialog box and
enables the user to change the filename (possibly to match their naming
protocols and conventions and pick the location where they would store it?
Many thanks
Terry
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett