saving a file

[Chris]

i want to take the contents of three cells and use that as
the file name when i use the saveas function in vba. how
do i do this...please help.
thank you.

exaple:

i have the number 9 in cell f2, the number 2 in cell f3
and the number 7 in cell f4. i want to have excel save my
file as 927.xls or whatever #'s i have in those cells. i
have a comand button to program the code into to do this
for me. thank you.

 

[fhunth]

i can make it for you

*i want to take the contents of three cells and use that as
the file name when i use the saveas function in vba. how
do i do this...please help.
thank you.

exaple:

i have the number 9 in cell f2, the number 2 in cell f3
and the number 7 in cell f4. i want to have excel save my
file as 927.xls or whatever #'s i have in those cells. i
have a comand button to program the code into to do this
for me. thank you. *

 

[Libby]

Sub commandbutton1_click()
ThisWorkbook.SaveAs [f2] & [f3] & [f4]
end sub