Saving a file by cell value?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cannunzi
    New Member
    • Nov 2007
    • 6

    #1

    Saving a file by cell value?

    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
Working...