File naming using cell reference

[constructor_ac]

Please help me with the syntax to reference a cell's contents when saving a file. I want to write a macro that will automatically save a file with a file name that is a combination of two cells in my spreadsheet.

So far I have:
ActiveWorkbook.SaveAs Filename:= _"CReference Cells F2+F5 Here).xls"

What do I insert into ( ) above to make th filename reference Cells F2 and F5 and combine the two into a single filename?

 

[Dragon_SDC]

I assume you mean the value of the cells (the contents) that will serve as parts of filename, separately - not as a sum of 2 values. Try this:

Sub save()

With ThisWorkbook.Worksheets("Sheet1")
ThisWorkbook.SaveAs Filename:="d:" & .Range("F2").Value & .Range("F5").Value & ".xls"
End With

End Sub

Also this assumes that the code is within the file being saved. Naturally, you need to change "Sheet1" to the worksheet name.

Hope this helps.

P.S. there is only 1 backslash - the other gets inserted by the webpage.

To boardmaster people: Why does this keep happening? It is rather annoying and confusing
This message was edited by Dragon_SDC on 2002-08-23 15:58