Excel 2003 help!!

[moisiss]

Hey all,

Quick question...
I've been doing some work in Excel for the past week and want to speed up my productivity. Specifically, I have been printing out a list of pictures. Each picture is on it's own web page in the companies database and the URL adresses are listed in the Excel document. Thus far I have had to copy each address from Excel, paste the address into explorer, and then print out each page. There are over 8,000 total images/pages to print out... so doing it this way is taking FOREVER!! Does anyone know a relatively easy way to "automate" all of this? If I could find a way to get all of this stuff to print automatically it would be wonderfull!

Any help would appreciated!

 

[King X13]

one idea i could think of is, change the execl doc to a txt doc so you just have a list of links, past the links into an html page with the tags:

</p>

and then you will have a page of pics and just hit print, i think that should work, just an idea tho.

 

[moisiss]

That seems like it might take longer than just cutting and pasting from excel to explorer. I mean, I would have to put the URL into the html code for every page right? If so, that seems like it would take more work....

mabye I just don't really understand what you are telling me to do.

 

[office politics]

you would need to write some excel vba

Using the Hyperlink Object
Use the Hyperlink property to return the hyperlink for a shape (a shape can have only one hyperlink). The following example activates the hyperlink for shape one.

Worksheets(1).Shapes(1).Hyperlink.Follow NewWindow:=True

A range or worksheet can have more than one hyperlink. Use Hyperlinks(index), where index is the hyperlink number, to return a single Hyperlink object. The folllowing example activates hyperlink two in the range A1:B2.

Worksheets(1).Range("A1:B2").Hyperlinks(2).Follow

 

[moisiss]

So does that mean I have to have 8,000 unique "shapes" to create hyperlinks to all 8,000 unique URLs? How would you print the target html page (without manually hitting the print button every time)? I'm just learning about macros in excel... so the more detailed the explation the better.

 

[MrCoffee]

i don't really understand what youre trying to do but this could get the tags on:

just create a column where each cell contains:



<img src="

another column with your image names and another column with:

"> </p>

then create a 4th column with a concatenate formula, select the column, copy, then paste special with the values switch into a 5th column, then delete columns 1-4.

 

[moisiss]

OK...
I did that and hit print and it just prints out the

text.... not the html page that the URL links to.

I'm familiar with using this type of HTML code to insert pictures into myspace and it works fine... it doesn't seem to work the same way in excel though.

What am I missing?

 

[MrCoffee]

I was running with King X13's idea of pasting the whole lot into a html page, is that possible?

I'm pretty sure HTML does not work in excel, infact i'd forget having the images in excel if thats what you're trying to do.

 

[King X13]

yeah i dont think you can have the images show up in exel, youd have to create and html page so all the pics would show up. and then just hit print. thats the best way i can think of.

 

[moisiss]

Thanks you guys/(and or gals)!!

I got the html stuff to work... I had to use an <a hfref=""> tag instead of the

<img src=> tag, but I got it working and it has increased my productivity by about 6x!!!

Thanks for the great ideas!!