Code:Save as macro

Hi all

I found this macro to save a workbook with a filename already placed in the save as dialog box.it nearly does what i want but im pretty new to all this and i cant get it to do the following.

what id like to do is

1,place cell values A1 and b1 from the workbook into the save as filename instead of filename. but keep in the date
2,create a new folder in c:\temp with the cell value of b1

any help would be great.

Please Login or Register  to view this content.

thanks

Hello spanker,

Assuming you have validated the data in cells "A1" and "B1" and "A1" contains the path and "B1" contains the file name then this macro will add the date to the new file and save it.

Please Login or Register  to view this content.