create pdf vba

hi gurus,

how can i create a pdf in excel active sheet but don't want automatically saved - i want it open the windows for save as and i chose the destination manually.

please can you help.

thhanks

This should do it...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

thank you judaa but for some reason it's not working. i have created a button and added that but nothing happeing.

please ignore this - all sorted
just wondering how can i ask system to automatically pops up the save as window for my selection ?

Please Login or Register  to view this content.

Originally Posted by jolivanes

Please Login or Register  to view this content.

Thank you
it's only saving with Test.PDF but I want it to save with whats in Cell B3. Is it possible ?

Please don't quote whole posts. Read the Forum Rules again, towards the end, number 2.
Try

Please Login or Register  to view this content.