I'm trying to save the file with the amount from cell A2 but instead it keeps saving as "Cells(2, 1).Value & FuelTaxReport." Any thoughts?
Sub Macro3()
'
' Macro3 Macro
'
' Keyboard Shortcut: Ctrl+i
'
ChDir _
"\\FS2\Departme nts\GOP\Tax\200 9 Compliance\Fuel Excise Tax Report 09\FuelTaxRepor ts"
ActiveWorkbook. SaveAs Filename:= _
"\\FS2\Departme nts\GOP\Tax\200 9 Compliance\Fuel Excise Tax Report 09\FuelTaxRepor ts\Cells(2, 1).Value & FuelTaxReport" _
, FileFormat:=xlE xcel8, Password:="", WriteResPasswor d:="", _
ReadOnlyRecomme nded:=False, CreateBackup:=F alse
End Sub
Sub Macro3()
'
' Macro3 Macro
'
' Keyboard Shortcut: Ctrl+i
'
ChDir _
"\\FS2\Departme nts\GOP\Tax\200 9 Compliance\Fuel Excise Tax Report 09\FuelTaxRepor ts"
ActiveWorkbook. SaveAs Filename:= _
"\\FS2\Departme nts\GOP\Tax\200 9 Compliance\Fuel Excise Tax Report 09\FuelTaxRepor ts\Cells(2, 1).Value & FuelTaxReport" _
, FileFormat:=xlE xcel8, Password:="", WriteResPasswor d:="", _
ReadOnlyRecomme nded:=False, CreateBackup:=F alse
End Sub