Saving an open PDF as something from Excel with VBA

[jacksongf]

I'm creating a report where I open a handful of spreadsheets containing data, and then run the macro from the "master sheet", which then pulls data from these sheets and pastes it in. This is fine, it works and there's no problems. BUT, one of the files is a PDF and the only thing I need to do with it is to save as a certain name, we'll call it "PDF 1", and also save it to a specific location. (The location is sharepoint, and I have the address for it, so that shouldn't be an issue).

Any code to refer to an open PDF file and then save as something would be very helpful, I can't find anything anywhere online about this!

Thanks,
Jackson

 

[Drrellik]

I don't know a lot about VBA but this is my attempt to save an open file to a PDF

you would have to add this to your current VBA and create a button.

Not sure this is what you are looking for because this is for the open excel file and not a PDF file.

Sub PDFMacro1()
'
' save open file as a PDF
'
    ChDir "C:\Users\Desktop"  ' your path
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\Desktop\newname.pdf", Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
        True
End Sub

 

[DushiPunda]

I don't know a lot about VBA but this is my attempt to save an open file to a PDF

you would have to add this to your current VBA and create a button.

Not sure this is what you are looking for because this is for the open excel file and not a PDF file.

Sub PDFMacro1()
'
' save open file as a PDF
'
    ChDir "C:\Users\Desktop"  ' your path
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\Desktop\newname.pdf", Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
        True
End Sub

Yes, it looks like he's trying to save an already-open PDF instead of trying to save a worksheet as PDF. I really don't think (though, I also don't know) this is even possible.

 

[Drrellik]

https://www.mrexcel.com/forum/excel...d-ie-page-thru-visual-basic-applications.html

look at this thread and see if it helps.

~DR

 

[jacksongf]

Yes, I'm not completely sure if it's possible either. I'll keep trying. Thanks for the help!

If anyone does does know how to do this and stumbles across this thread, please share your ways!

Thanks,
Jackson