Question Using SaveAs Method

  • Thread starter Thread starter R3df1sh
  • Start date Start date
R

R3df1sh

I am trying to accomplish a saveas routine for a workbook that whe
clicked as a button, it will compose the filename from combining th
values of multiple fields (Cells A1 + A2 + A3 & ".Xls")and save to
designated area as a new copy. Could anyone help me with the coding fo
this? I am relatively new to Excel XP VB Useage and have picked up th
basic functions, but fall short in this area.

Much Thanks to those that can hel
 
Try something like

Dim FName As String
FName = Range("A1").Value & Range("A2").Value & _
Range("A3").Value & ".xls"
ThisWorkbook.SaveAs Filename:=FName

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Back
Top