Is there any way to save a zoho sheet as PDF in Workdrive using VBA?
Dear All,
I am trying in a zoho sheet to create a button and with VBA to save this zoho sheet as PDF in a specific Workdrive folder.
I have found some examples like the below but first of all the 'ExportAsFixedFormat' returns me unknown function and of course I do not know in the saveLocation what Workdrive Path to add and how to define this path.
Sub SaveActiveSheetsAsPDF()
'Create and assign variables
Dim saveLocation As String
saveLocation = "C:\Users\marks\OneDrive\Documents\myPDFFile.pdf"
'Save Active Sheet(s) as PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=saveLocation
End Sub