Macro to save as PDF

[jono7gold]

Hi,

I am looking for a macro which will save a sheet(named AF) as a PDF. The excel workbook will already be saved in a folder as a specific name(e.g 1554) and I would like this PDF to be saved as that name but with AF added to the end - so for example it will be saved as 1554AF. Its also needs to be saved in the same folder as the excel sheet is saved in.

Thanks in advance.

Jon

[Kandavalli.Kiran]

Hi,

Use this function

Please Login or Register  to view this content.

Thanks!
Kiran

[HaHoBe]

Hi, Kiran,

Use this function

I would call the code a procedure or a macro rather than what I would call a Function (which is supposed to deliver back anything for me). And I guess you would have to work on the filename as it should represent the name of the folder as well as the name of the sheet.

Ciao,
Holger

[Kandavalli.Kiran]

Hi,

Please use this macro.

Please Login or Register  to view this content.

Thanks!
Kiran

[Kandavalli.Kiran]

hahaha, thanks for letting me know

As a habit of programming I was calling as a function instead of macro.

[HaHoBe]

Hi, Kiran,

your second macro still doesn´t do what OP is calling for.

Please Login or Register  to view this content.

As a habit of programming

Maybe change the habit?

Ciao,
Holger

[Kandavalli.Kiran]

Thanks for suggesting me and the way to improve my code