thanks for this. It worked.
"tjtjjtjt" wrote:
Andy,
I just copied the filepath from your post--
As the other posts show, if you are on a Windows machine, the slashes from
your filepath are going the wrong way.
tj
"tjtjjtjt" wrote:
How about something like this:
Sub SvFile()
ActiveWorkbook.SaveAs Filename:= _
"R:/SALES/Team 318" & Range("B1").Value _
& "\" & Range("A1").Value & ".xls"
End Sub
tj
"Andy" wrote:
Hi
Two cells A1 & B2
I am trying to create a Macro to attach to a button to Save an .xls as
"A1".xls in directory R:/SALES/Team 318/"B2"
instead of typing it in all of the time....
Any helpers? Past attempts at this have failed.....the winner will get a big
MVP vote!
Absolute respect
Andy
|