Print out linked .pdf files using VBA

[spasmex97]

hey guys, greetings at first, my question is, i am using a excel sheet as a data source and i group them by names, i use another data source from a directory which gives me the source of .pdf files then i link them by using Vlookup function, but sometimes data corrupts or doing some missclick deletes the function and i always need to check-up, i want to make the same actions by using VBA so no one can interrupt it , and i also want to add print out these linked .pdf files using a commandbutton on the excel sheet, any ideas?

 

[Micron]

I think you need to start by showing where the information is and how it looks in order to figure out what code would be required. I can't picture it based on your post.

 

[spasmex97]

sorry for late reply, was busy with other things

i have a column that shows the url of the document, but my hyperlinks aren't exactly the same name of the .pdf document, i use vlookup(DÜŞEYARA) function to filter through it, and bring the url as hyperlink as the name of the project code, not .pdf document name, so i want to print out the hyperlinked values, range can be various

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Print out all hyperlinked PDF docs

I have an excel workbook which makes, Vlookup and finds the matching "xxxxxx" number with the PDF documents and brings the URL then hyperlinks i with the "xxxxxx", now i want to print them out in just one click, all hyperlinked documents if they exist

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[spasmex97]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Print out all hyperlinked PDF docs

I have an excel workbook which makes, Vlookup and finds the matching "xxxxxx" number with the PDF documents and brings the URL then hyperlinks i with the "xxxxxx", now i want to print them out in just one click, all hyperlinked documents if they exist

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

is turkish forums included too?

 

[RoryA]

All forums are included.