saving a file

C

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.
 
F

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. *
Click to expand...
 
Top