How do I save an Excel file in VBA 1

[RyanScharfy]

using the name of a specific cell as the name of the file I want to save.

For example. Cell A1 has the text "Apple". The macro should save the file as "Apple" in the My Documents folder.

Thanks in advance.

 

[PHV]

Have a look at the SaveAs method

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886