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
This allows, e.g.,
firefox -print "";

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

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

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 for more resources and info.

Please move off-topic discussions to the Chat list, at:

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