Re: Print a list of URLs in an Excel

Subject: Re: Print a list of URLs in an Excel
From: "John J. McDermott, CPLP" <jjm -at- jkintl -dot- com>
To: techwr-l -at- lists -dot- techwr-l -dot- com
Date: Wed, 29 Dec 2010 10:15:52 -0700

You can add an extension to firefox to allow printing from the command line. See http://www.abeel.be/content/command-line-printing-firefox
This allows, e.g.,
firefox -print "http://mypage.com";

You can run a DOS command from Excel with the VB Shell():
Shell "firefox -print " + FileName

So you can put the Shell command in a macro and run it for each cell with a URL.

--john


John Posada asked:

> Hi, guys...

> I have an Excel of about 200 lines where the first column contains web
> page URLs.

> I want to print each of the pages. Right now, I click on the URL,
> display the page, print it, shut it down, go to the next one.

> Anyone have an idea how I can print all the pages of the listed URLs in a batch?


--
John J. McDermott, CPLP
Learning and Performance Consultant
jjm at jkintl.com
Add an A for the Arts To STEM and get STEAM and a strong engine to move forward.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Create and publish documentation through multiple channels with Doc-To-Help.
Choose your authoring formats and get any output you may need. Try
Doc-To-Help, now with MS SharePoint integration, free for 30-days.
http://www.doctohelp.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

Please move off-topic discussions to the Chat list, at:
http://lists.techwr-l.com/mailman/listinfo/techwr-l-chat


Previous by Author: Re: PowerPoint (2007) - using slide numbers in hyperlinks?
Next by Author: Need help from an Excel guru
Previous by Thread: Print a list of URLs in an Excel
Next by Thread: For the Typography Fans


What this post helpful? Share it with friends and colleagues:

Sponsored Ads


Sponsored Ads