liquidmetal24
New Member
- Joined
- Oct 29, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- 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.
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.