Re: I have a list of URLs, I need to print the pages

Subject: Re: I have a list of URLs, I need to print the pages
From: Lauren <lauren -at- writeco -dot- net>
To: techwr-l -at- lists -dot- techwr-l -dot- com
Date: Wed, 21 Sep 2011 14:30:45 -0700

On 9/21/2011 1:56 PM, John Posada wrote:

Hi, guys...I have a list, currently in Excel, of about 230 URLS. I need to
print the web pages and going one by one is a drag. Anyone have any ideas?

I got ideas, but you were probably hoping for something useful. ;-)

Didn't you go through this before?

How about a Foreach Loop? Nothing I can see looks pretty, as far coding goes, for Excel, so I would ask a programmer to help with a script to pipe each URL to a browser print command of some sort. If you cannot find a programmer to help with your script, then look online for "Foreach Loop."

You will likely need to have a single text column for your URLs that is set off for whatever scripting language you wind up using.

Here is one link to a sample batch file that will probably work for you, but you will need to find the syntax for your print command.

Once you write your script and save it as a batch file, you can repeat this process in a matter of seconds, once you have a text file of your URLs.

BTW, do remember to test your batch file with only a few URLs, first. Just in case it gets broken, y'know.

Here is a VBScript option that is less ugly than what I saw for an Excel macro, but your best option is a batch file.



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:

I have a list of URLs, I need to print the pages: From: John Posada

Previous by Author: Re: verb forms related to Twitter ?
Next by Author: Re: second acts for technical writers?
Previous by Thread: RE: I have a list of URLs, I need to print the pages
Next by Thread: Re: I have a list of URLs, I need to print the pages

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

Sponsored Ads