VBA code opens my pdf file and code loops through the pdf fields but fails to write any data from the excel database worksheet.

J15491

New Member
Joined
Jan 10, 2020
Messages
34
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I have workbook with two worksheets. One is the Launch page which allows the user to select the pdf to use for the excel cell values to be enter in using a browser button and another browser button to select the save pdf folder. Another button launches the Userform for the data to be entered in and then that data is entered in the database worksheet. Row A1:A21 consist of the column names and row 2 is the first row of data to be entered. my code loops through the pdf form with no problem, but fails to enter the data from the database worksheet. I need some help with this and how to set my code to enter the last row of data to the pdf file, print 2 copies of the pdf form and the store it by name and date submitted. Any help would be appreciated.

Below is a link to the folder containing the workbook and pdf files

 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Forum statistics

Threads
1,147,475
Messages
5,741,344
Members
423,656
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top