Print out linked .pdf files using VBA

spasmex97

New Member
Joined
Jul 8, 2024
Messages
19
Office Version
  1. 2019
Platform
  1. Windows
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?
 

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.
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.
 
Upvote 0
sorry for late reply, was busy with other things
links.png
vlookup.png
hyperlinks.png

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
 
Upvote 0
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:

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.
 
Upvote 0
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:

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?
 
Upvote 0

Forum statistics

Threads
1,224,595
Messages
6,179,798
Members
452,943
Latest member
Newbie4296

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top