Sorry for that Don, I looked at the date in April and wasn't sure whether it
would appear near the top of the list. I thought the listing was arranged in
date order of original post.

Apologies if I've done something wrong or against protocol. That wasn't my
intent.

:-(

Tel

"Don Guillett" wrote:

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