Abulean2010
New Member
- Joined
- Nov 28, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
i have this code to open URL file in the desktop
but its not working and give error
Dim PDFTemplateFile, NewPDFName, SavePDFFolder, LastName As String
Dim ApptDate As Date
Dim CustRow, LastRow As Long
With Sheet1
LastRow = .Range("D13").End(xlUp).Row
PDFTemplateFile = .Range("C23").Value
SavePDFFolder = .Range("C26").Value
openURL "" & PDFTemplateFile & "", show_maximized
Application.Wait Now + 0.00006
End With
End Sub
but its not working and give error
Variable not defined
Sub CreatePDFFourms()Dim PDFTemplateFile, NewPDFName, SavePDFFolder, LastName As String
Dim ApptDate As Date
Dim CustRow, LastRow As Long
With Sheet1
LastRow = .Range("D13").End(xlUp).Row
PDFTemplateFile = .Range("C23").Value
SavePDFFolder = .Range("C26").Value
openURL "" & PDFTemplateFile & "", show_maximized
Application.Wait Now + 0.00006
End With
End Sub