Scanning Document as image into Worksheet

liquidmetal24

New Member
Joined
Oct 29, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Good Morning,

I am currently working on a file that automatically generates an inbound receiving report. The file generates a formatted report and saves in as a .pdf file for later accessing or printing. What I currently am having an issue with is, I need to attach the shipping paperwork to this report in the most simple and automated way possible. My thought was that if possible, I would make a button that accesses the scanner and inserts each page as an image in a single (or multiple) worksheet(s) and then create an array with the receiving report and save as one file. I already know how to accomplish the array and save part, but I have no idea where to begin with scanning the document and inserting it. I have googled and searched for any example I could find, but they all seem to be outdated, not applicable, or broken in a way I cannot figure out. Does anyone here have an idea of how to do this? Or could point me in the right direction?

Thanks in advanced for your time.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,215,052
Messages
6,122,878
Members
449,097
Latest member
dbomb1414

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
Back
Top