Cannot view, page & zoom PDF on User Form

[Colin Smit]

Hi There

I have a problem with opening a specific PDF on a User Form. The PDF name/number must be selected in a textbox on the user form. The PDF must then display on the actual user form.

The problems I have to overcome is:
1. Cannot get the specific PDF (chosen in the text box on user form) to show.
2. Do not know how to set the command buttons “Previous Page” & “Next Page” to enable me to page through a multipage PDF.
3. Do not know how to set command for “Zoom In” & Zoom Out” to enable me to look closer on specific detail on a PDF.

I am not even sure if the Paging or Zooming is possible?
1. Does anyone know what am I doing wrong in my code as to why the PDF won’t open on the User Form?
2. Does anyone know how to set the command buttons “Previous Page” & “Next Page”?
3. Does anyone know how to set the command buttons “Zoom In” & Zoom Out”?

Any help will be greatly appreciated. See attached file.

[Kyle123]

Use a webbrowser control, not the acrobat control. This will then init the default plugin for IE so will show all the normal controls without you having to add them manually

[Colin Smit]

Use a webbrowser control, not the acrobat control. This will then init the default plugin for IE so will show all the normal controls without you having to add them manually

I have no idea how the code for the web browser control should look like as I have also never tried it. The unit on which the spreadsheet will be used will have a lock down with no internet access. Will above not be affected by this? If not can you place a sample code of how it should look? Tks

I have managed to get the PDF TO open on the User Form with the code below.

Please Login or Register  to view this content.

However how can I get the code above to look at a specific entry as the above number "50081" will change with every new entry. I have tried to change it to look at a specific text box entry but could not get it to work. Any idea?

[Kyle123]

No, it doesn't need internet access. It would look like this:

Please Login or Register  to view this content.

[Colin Smit]

No, it doesn't need internet access. It would look like this:

Please Login or Register  to view this content.

How do I have the part of the code referring to the PDF number (In above sample it is 50081) refer to a textbox value that was input in a User Form? In other words if I type in a different item number I will get the specific PDF related to that item.

[Kyle123]

THe same way I showed you in your other thread

[Colin Smit]

Will look at it. Tks

[Colin Smit]

THe same way I showed you in your other thread

I have tried below with no success.

Please Login or Register  to view this content.

I also tried below code with no success.

Please Login or Register  to view this content.

Not sure how to correct it as I am not that knowledgeable in VBA and still learning my way around it.

[Kyle123]

Neither of those are the code I gave you in the other thread. Read it carefully

[Colin Smit]

Are you referring to below code?

Please Login or Register  to view this content.

[Colin Smit]

Thank you for the help. I managed to get the PDF selected and opened. See code below.
What must I add in below code to show error if the item number selected has no PDF present? Currently if I select a number for which I know a PDF does not exist, then it throws me back to the VBA Code. With a unit set up on lock-down I want to try and prevent this. Rather the User Form show a N/A in the PDF Block if possible?

Please Login or Register  to view this content.

Another reason why I decided to use the PDF plug-in is because the unit will be on lock-down software with only a Numb-Keypad connected to the unit. (No Mouse or Keyboard will be connected) With the Tab Button on the Numb-Keypad it is easy to move from one button to another button on the User Form hence the reason for wanting to use the "Previous Page", "Next Page", "Zoom In" & "Zoom Out" buttons on the User Form. Do you know how to set the command for these buttons?

With your previous mentioning of using the Web Browser Control...Will these functions also be available in such a manner?

[Kyle123]

Why not try it and find out? I suspect the experience will vary depending on the pdf reader installed.

You can use the dir function to check whether a file exists

[Colin Smit]

Why not try it and find out? I suspect the experience will vary depending on the pdf reader installed.

You can use the dir function to check whether a file exists

Your suspicion is correct! I have tested it yesterday on a sample machine and found out that the PDF reader installed had to be updated. Although it is not a big issue as we have a very good network infrastructure through which these type of problems can easily be corrected remotely, your idea on using a Web Browser might be the better option. I will experiment with the Web Browser later today and give feedback.

Thank you for your advice and feedback thus far.