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.

i can make it for you

Chris wrote:
*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. *


---
Message posted from http://www.ExcelForum.com/

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


-----Original Message-----
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.
.