• 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.

I have a sheet with hyperlinks to pdf's, I need to print the pdf's

The Planner

New Member
I need a loop routine to run down column B and print the pdf's hyperlinked there.
I have looked every where and have found many suggestions how to print DOCs, XLS


The sheet is formatted like this

Latest Rev. Location State AREA - SITE Document Number Revision
YES file:\\Production Documents\100J7450-01DEMO_01.pdf 162 100J7450-01DEMO 01
YES file:\\Production Documents\100J7433-01DEMO_01.pdf 162 100J7433-01DEMO 01
YES file:\\Production Documents\100J7314-02DEMO_00.pdf 162 100J7314-02DEMO 00
YES file:\\Production Documents\100J7310-02DEMO_00.pdf 162 100J7310-02DEMO 00
YES file:\\Production Documents\100J7308-02DEMO_00.pdf 162 100J7308-02DEMO 00
YES file:\\Production Documents\100J7303-02DEMO_00.pdf 162 100J7303-02DEMO 00
YES file:\\Production Documents\100J7300-02DEMO_00.pdf 162 100J7300-02DEMO 00
YES file:\\ Documents\100J7276-02DEMO_00.pdf 162 100J7276-02DEMO 00
YES file:\\Production Documents\100J7263-C1DEMO_00.pdf 162 100J7263-C1DEMO 00
YES file:\\ Documents\100J7262-C1DEMO_00.pdf 162 100J7262-C1DEMO 00
YES file:\\Production Documents\100J7261-01DEMO_00.pdf 162 100J7261-01DEMO 00
YES file:\\Production Documents\100J7254-C1DEMO_00.pdf 162 100J7254-C1DEMO 00
YES file:\\Production Documents\100J7253-01DEMO_00.pdf 162 100J7253-01DEMO 00
 
SirJB7, Thanks for the link. I looked at that code and it will loop through a directory and print those files. I was really looking for a routine that will loop through and excel list of hyperlinks that has been sorted or filteered from a larger list bassed on multiple criteria.
The database has over 64000 lines and can be extracted via the filters to an xls sheet, it is from there that I would love to batch print to default printer and be able to set the pagesetup parameters , ie. 11x17, landscape, one sided. etc.
Excel just doesn't handle the pdf function very well.
 
Hi, The Planner!
Excel is for .xls* files and Reader/Acrobat for .pdf files. Anything else is likely to be either hard or annoying. Tomorrow I'll give a look again at this and will post here.
Regards!
 
Hi, The Planner!
My schedule got a bit changed last week(-end) so... is this still pending or yet solved?
Regards!
 
Back
Top