A little complicated

[Rebecca Kowalski]

Hi all,

Well my macro is working fantastically thanks to every ones help here. Just need a little more assistance.

I need to add a finishing touch to my Marco, I need to add code that will once the macro is run convert it to a PDF Document, Save it in the name of two cells within the tab, and obviously save in a particular place.

Is this over complicating it? Would just make my life so much easier if I can get this to work.

 

[James006]

Hi,

You can use in your macro: .ExportAsFixedFormat Type:=xlTypePDF ...

Hope you can insert it correctly in your macro ...

HTH

 

[Rebecca Kowalski]

Hi,
Thanks for this but I need to be able to select the cells in the form to use as the File Name and also for it to save in a specific location.

Please can you be more specific on the above as that doesn't seem to do anything I need.

 

[James006]

Hi again,

Why don't you post your macro ...

It will make it much easier to suggest the exact code ... :wink: