I am trying to use VBA to fill a PDF Form with Excel data. I have tried watching videos on YouTube and I am struggling with getting the syntax correct. This is the Sub that I cant get to work right now.
Sub CreatePDForms()
Dim PDFTemplateFile, NewPDFName, SavePDFFolder, LastName As String
Dim API As String
Dim APIRow, LastRow As Long
With Sheet1
LastRow = .Range("A9999").End(xlUp).Row 'Last Row
PDFTemplateFile = .Range("C3").Value 'Template File Name
SavePDFFolder = .Range("G20").Value 'Save PDF Folder
OPENURL "" & PDFTemplateFile & "", Show_Maximized
Application.Wait Now + 0.00006
can you tell me where I am going wrong?
Sub CreatePDForms()
Dim PDFTemplateFile, NewPDFName, SavePDFFolder, LastName As String
Dim API As String
Dim APIRow, LastRow As Long
With Sheet1
LastRow = .Range("A9999").End(xlUp).Row 'Last Row
PDFTemplateFile = .Range("C3").Value 'Template File Name
SavePDFFolder = .Range("G20").Value 'Save PDF Folder
OPENURL "" & PDFTemplateFile & "", Show_Maximized
Application.Wait Now + 0.00006
can you tell me where I am going wrong?
