save macro with specific folder and file name and type

[wolfm]

I would like to create a macro that will save my .xltm file as a .xlsm file (forced file type). I would like the file name to be formatted as the word "DECO" followed by a space, followed by a six-digit number which would be pulled from cell "L5" from the active worksheet. For example: DECO 123456.xlsm
I would like the file saved in network folder: "O:\Data\DecoForeman\"
I wish to save the entire workbook. Any help would be appreciated! Thank you!

[HaHoBe]

Hi, wolfm,

this may do it (as long as the folder exists and the user may write to it) whereas the 6-digit number was not specified in the question (is it part of the cell or the whole cell like I assumed):

Please Login or Register  to view this content.

Ciao,
Holger

[wolfm]

Thank you Holger! This works great!