• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to print hyperlinked document along with excel sheet

ashish41090

New Member
Hi,
Looking for some help.
I am working on a VBA that will help me to print excel sheet which has some dynamic data in first 10 rows (with V lookup function) and a file which is hyperlinked in a cells {again dynamic with (Hyperlink(Vlookup...)) function}.
I need to print excel sheet (as page-1) & hyperlinked document (as page2) in pdf.
I tried record macros too bust wasn't of any help. Kindly advise.

64233
 
Hi,

I want to print this document. Check the last row for hyperlinked document. All data are dynamic, Based on drop list menu created in Cell "D1.
Though D1 is not set in print area.

64236
 
ashish41090
I wrote: Without a sample Excel-file (which has same elements as You normal file)
A sample file NO need to be SAME file!
You should to CREATE NEW FILE or EDIT those datas.
Without proper Excel file, this could take weeks!
 
ashish41090
I wrote: Without a sample Excel-file (which has same elements as You normal file)
A sample file NO need to be SAME file!
You should to CREATE NEW FILE or EDIT those datas.
Without proper Excel file, this could take weeks!

Hi Sir,

I have attached the subject file.
Refer tab " datasheet " wherein I want a single macros to print the data in the sheet along with hyperlinked document.

Alll columns are linked with " VLOOKUP " including the hypelink tab.

Regards
 

Attachments

  • Equipment.xlsm
    48.3 KB · Views: 3
ashish41090
Now, it looks same as Your original (#1 reply) picture.
I modified 'some' layout settings.
... with ... PDF or something
... should I have any of those?
 

Attachments

  • Equipment.xlsm
    45.8 KB · Views: 7
Sir , automate means - help me with VBA with the macro which creates a pdf of the document. And pdf along with the document in the hyperlink as attachment.
 
ashish41090
From what You need a pdf?
... as attachment something which is not there?
Could You eg create drawing or so - what do You really need?
[/QUOTE
When you open this file and click on the print button(macro on datasheet). It generates a pdf file on your desktop. But The second page of the document has a hyperlink which has some document..every time a new document for each equipment . But what I really need help with this document is ...instead of getting that link in the last row of 2nd page ..it should be the document itlesf. That's how it shd be.
 
ashish41090
... as attachment something which is not there?
as same as
that You're asking to add something which is not there!
Why You do not even try to attach those instead of link?
 
Back
Top