Question Using SaveAs Method

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
 
C

Chip Pearson

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
 
Top