Calling for a VBA Expert! This code works for CSV....Need same to save to PDF.

[StevenRK72]

Calling for a REAL VBA Expert. The code below works PERFECTLY when saving as a CSV.
*I'm hoping some one can modify this code to remove CSV references and save as a PDF. The file path and naming works.
I am a Nubie, and have tried many hours to modify this code to save as a PDF. There may be other code available, but this one works. HELP! If nothing else...help get me close.

Steve

Please Login or Register  to view this content.

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[StevenRK72]

Greg M - I LOVE your Country!!!! Been to Dublin a couple times. Last time there I was made to dance the Irish Jig at the Jameson Distillery :-( Wasn't Pretty!

You GOT me very close!!!! I need the PDF Output to only include whats in the Print Area. is that possible?

Steve

[StevenRK72]

BTW - I did a little searching...I tried the following...but did not resolve printing to only print area.

Please Login or Register  to view this content.

If I go to tab and try to print it, It does print to Print Area Only. There are cells to right of doc that should not be included in PDF output.

Greg - you got me very close...hope you can figure out the issue for me!

Steve

[Greg M]

Hi again,

Last time there I was made to dance the Irish Jig at the Jameson Distillery :-( Wasn't Pretty!

yes, I think I read about that in the national newspapers!

Your original code used:

Please Login or Register  to view this content.

so thats why I used "With ActiveSheet.UsedRange"

To restrict the PDF output to the PrintArea of the worksheet, just use:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

[StevenRK72]

Greg - Your great!!!!!!! It worked perfectly. I "was" going to close this thread...but was told we also need to be able to save as an xlsx file as well. Can you privide what I should change in above code to save as a xlsx doc (Print Area only)?

Steve