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/