Hello,
I used the following code below to open an excel file using a button in a form. I want a similar button to open an exisisitng PDF fillable form. How do I change the CreateObject to Adobe?
I used the following code below to open an excel file using a button in a form. I want a similar button to open an exisisitng PDF fillable form. How do I change the CreateObject to Adobe?
Code:
[/FONT]
[FONT=Calibri]Private Sub PL_Submission_Form_Click()[/FONT]
[FONT=Calibri]Dim xlApp As Object[/FONT]
[FONT=Calibri] [/FONT]
[FONT=Calibri]Set xlApp = CreateObject("Excel.Application")[/FONT]
[FONT=Calibri]xlApp.Visible = True[/FONT]
[FONT=Calibri] [/FONT]
[FONT=Calibri]xlApp.Workbooks.Open "C:\Users\xxxxxx\xxxxx\Worksheet in C Users xxxxxx Desktop Report Reveiw Procedure v02.xls", True, False[/FONT]
[FONT=Calibri] [/FONT]
[FONT=Calibri]End Sub[/FONT]
[FONT=Calibri]