davidanaya11579
New Member
- Joined
- Dec 26, 2017
- Messages
- 11
Greetings,
I am attempting to write a macro to save the current sheet (sheet1) as a PDF to a SharePoint site, using the value of C3 as the file name. The below is what I have.
Private Sub CommandButton4_Click()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"http://worknet/sites/clevelandgf/insidesales/Transactional Quotes/Forms/AllItems.aspx" & Range("C3").Value & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
End Sub
It seems to run correctly, I can see the SharePoint site open in the background, and the completed PDF opens, but the file never actually saves to the SP site. Any ideas?
I am attempting to write a macro to save the current sheet (sheet1) as a PDF to a SharePoint site, using the value of C3 as the file name. The below is what I have.
Private Sub CommandButton4_Click()
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"http://worknet/sites/clevelandgf/insidesales/Transactional Quotes/Forms/AllItems.aspx" & Range("C3").Value & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _
True
End Sub
It seems to run correctly, I can see the SharePoint site open in the background, and the completed PDF opens, but the file never actually saves to the SP site. Any ideas?