Viewing a PDF File within excel based on a cell value

Hello,

This is my first time posting to the website so I'm sorry if I don't provide enough information. I am working in a manufacturing facility and I am trying to build a file for the floor operators to use. I have a stand alone computer with a barcode scanner attached so each time we change to a new product the barcode is scanned prompting the file to pull up all the information for the new part. Currently I have a code that calls a jpeg file up and shows a work instruction on the screen, updating each time a new barcode is scanned. The code that performs this action is shown below. What I want to do is pull up a pdf file instead. We save all of our files as pdf's and currently I have to convert the pdf to a jpeg and save it in a different file folder to keep file working. I want to make it standard so that the file draws from our controlled folder that is updated everytime we create a new file.

Please Login or Register  to view this content.

I have tried changing this to state "Image1.Picture = LoadPicture(MyDocs & Sheet1.Range("C2") & ".pdf") however the file does not show display, there are no run errors however there is nothing displayed on the screen. Is there any way to do this so I do not have to convert the file to a .jpg file?

Let me restate to see if I understand the requirement. You currently have a folder with pictures in it. When you scan a bar code, the result goes into Cell C2. This information is used to find the associated picture and display it in the worksheet.

Would the following be acceptable? I'm not sure I can display the PDF document as part of the spreadsheet, but I can open and display the document. You will have both the spreadsheet and the PDF file open separately.

Also: learn to use code tags. The mods will get on your case if you don't. It's simple put the word code in square brackets in front of your code and /code in square brackets after the code. Else you will see the following "nastygram:"
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Please attach a sample of your document for more clarity.

Please attach a sample of your document for more clarity and understanding.

This may do what you want to do. Modify the path.

It turns out that this is a lot easier than I thought it would be. There is a line in the code that you need to change to reflect where your PDF files are stored.

I put change event on the Setting MC Work Instructions sheet on Cell C2. When you change the value in this cell, it kicks off the program automatically.

The PDF picture is embedded starting in Cell A6. If you double click it, it launches Adobe Acrobat (or whatever your system PDF view is) as a separate instance and you can view the entire document.

Note: the document image on the screen may go blank while Adobe is open.

I thought it would be nice to show you which line to change in the code.

Please Login or Register  to view this content.