open and print file .pdf

[johnson1421]

Hi

I am new to excel and I am trying to create a macro that will open a hyperlink to a pdf file and print it. The hyperlink is manually added by the user to column D

I have the below that opens the files in column d but I can not get it to print. Any advice will be much appreciated

Please Login or Register  to view this content.

[Nu2Java]

Hi, try this in a module. It will open and print a pdf. Change the paths as needed and/or create a variable for the file name.

Please Login or Register  to view this content.

[Nu2Java]

If that does not work for you, have a look here in this older post:

http://www.excelforum.com/excel-gene...-of-links.html

[johnson1421]

Hi

I have added the below code. This opens my pdf reader when ran however it is not selecting the files or printing them. I am unfamiliar with how to make a variable for the file name. My file names / hyper links are in column D in the format C:\Users\Mags\Desktop\back.pdf

Please Login or Register  to view this content.

Moderator's Note: Welcome to the forum, don't forget to put code tags on codes, Select the code then Hit the "#" sign. Thank you.

[Nu2Java]

You might try to attach a sample workbook so people can see what you need to do. I see you posted the same question twice so you will need to remove that post or it will be deleted by a forum Admin.