T
Tony
I am trying to use a command button to save a spreadsheet using cell values
as the file name from the tab Master. For example I want to use cells B2
(Tony.Dungate) and F2 (2010.March) to create a file name of
Tony.Dungate.2010.March.xls. Essentialy I would need something like :
Master!B2&.&Master!G2&".xls"
Can someone advise me on the correct code to do this. I have been trying to
use the following without success:
Const sRoot As String = "V:\Database Logs\"
With ActiveWorkbook
.SaveAs Filename:=sRoot & _
.Worksheets("Master").Range("B2").Text, _
FileFormat:=xlExcel8
.Close
as the file name from the tab Master. For example I want to use cells B2
(Tony.Dungate) and F2 (2010.March) to create a file name of
Tony.Dungate.2010.March.xls. Essentialy I would need something like :
Master!B2&.&Master!G2&".xls"
Can someone advise me on the correct code to do this. I have been trying to
use the following without success:
Const sRoot As String = "V:\Database Logs\"
With ActiveWorkbook
.SaveAs Filename:=sRoot & _
.Worksheets("Master").Range("B2").Text, _
FileFormat:=xlExcel8
.Close