export single page to pdf

Sub export()
'
' export Macro
'

'
Sheets("Purchase Order Request").Select
Sheets("Purchase Order Request").Copy
ActiveWindow.SmallScroll Down:=9
ActiveWorkbook.SaveAs Filename:= _
"https://75f.sharepoint.com/Support/Shared Documents/Orders_Inventory/Purchase Orders/Book2x2.xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
Windows("Inventory Count.xlsm").Activate
End Sub

the red is where i am having issues. I want to be able to use this macro multiple times so the title of the save as copy needs to be based on what is in f4 of the worksheet. I am not sure how to write that though....

so basically
I am exporting a worksheet to a new excel doc then saving as to a pdf file. the title of the pdf file save as needs to be the same information that is in the f4 cell. is there hope?

Please Login or Register  to view this content.

So i am still learning on macros and tried the code i keep getting run time error 76 the path not found i was trying the http sharepoint path at first then went to try a local path and it still gives the message. I know im doing something silly but Im lost.

You forgot the "\"

Please Login or Register  to view this content.

So i got that figured out but now the code get to the sharepoint file and has the save window open with the correct title. at this point i want it to save by itself and open the new pdf file as well. it is making me manually hit save and then this printer thing pops up?

Capture.PNG

Reset my computer and made a few changes it works for the most part still isnt saving automatically but i can live with that.


Thanks!!!