Expert PDF Help

[Spacey88]

Hey Everyone

I'm very new to VBA used excel a fair bit and can record Marcos ect... the easy stuff but I need to create a button the selects a range and then exports it to a PDF. Obviously you can do this just recording a macro but every time I do this it exports the range to a particular path and filename.... What I want the user to be able to do is select there own path and filename essentially so it stays at the export save screen. I've tried so many ways and just get errors don't really know what I'm doing lol. Even asked ChatGTP! I've seen alot of videos using the SaveAs Function that can even be customised, this would be great but as far as i can tell this doesn't work for what I am looking for! any help would be great.

TIA

 

[Marc L]

Hello, see in VBA help the Application.GetSaveAsFilename & Range.ExportAsFixedFormat methods.​

A thread sample :​

PDF EDIT

Hi All, Greetings ! I'm a learner in VBA coding. please help me in the below requirement. > We will save many PDF files in a specific folder. > PDF may have many pages. Example : In PDF, We have many pages and all the pages have a similar heading as " Invoice copy", We no need the word "copy"...

chandoo.org

 

[Spacey88]

I don't think this is the same problem as me I don't want it to save to a particular location.

thanks for your reply though

 

[Marc L]

As my post #2 answers to your initial post, you did not ever read the VBA help !​

Anyway, you can start activating the Macro Recorder and operating manually …​

​

 

[Logit]

Sub SaveSelectionAsPDF()

Dim saveLocation As String
saveLocation = "C:\Users\logit\OneDrive\Desktop\myPDFFile.pdf"

'Save selection as PDF
Selection.ExportAsFixedFormat Type:=xlTypePDF, _
    Filename:=saveLocation

End Sub