save as xlsm to specific direction

[FvdF]

Halle forum users,

I have a vba code that works for saving as pdf but now I also want to use this code for saving as xlsm.
What do I have to change, I can't do it yet.

Please Login or Register  to view this content.

[Richard Buttrey]

Hi,

Are you wanting to save just the range B1:F53 on the sheet as a new workbook, or do you want to save the whole workbook?

[FvdF]

Hello Richard,

I want to save the whole workbook including the macro's.

Regards.

[Richard Buttrey]

In that case then presumably

Please Login or Register  to view this content.

[FvdF]

It's working now but the filename is not okay. I need the name from cell C13!

[Richard Buttrey]

..in that case for
"MyFilename"

just substitute

Sheet1.Range("C13").Value

obviously change the Sheet1 VBA sheet code name to whichever is the VBA sheet code name of the sheet with the C13 cell in question.
Note, I'm talking about the VBA Sheet CODE name NOT the Excel Sheet TAB name.

[FvdF]

Thanks for your reply.

Grtz.