TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
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 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-