Excel 2003 help!! - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 08-15-2006, 01:47 PM   #1 (permalink)
True Techie
 
Join Date: Jul 2006
Posts: 146
Default Excel 2003 help!!

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!
__________________

moisiss is offline  
Old 08-15-2006, 02:27 PM   #2 (permalink)
Ultra Techie
 
King X13's Avatar
 
Join Date: Jun 2006
Posts: 987
Send a message via AIM to King X13
Default

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:




[img]filename.gif[/img]
</p>

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

__________________
[SIGPIC][/SIGPIC]
King X13 is offline  
Old 08-15-2006, 04:39 PM   #3 (permalink)
True Techie
 
Join Date: Jul 2006
Posts: 146
Default

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.
moisiss is offline  
Old 08-15-2006, 04:51 PM   #4 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

you would need to write some excel vba

Quote:
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
office politics is offline  
Old 08-16-2006, 12:12 PM   #5 (permalink)
True Techie
 
Join Date: Jul 2006
Posts: 146
Default

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.
moisiss is offline  
Old 08-16-2006, 02:57 PM   #6 (permalink)
Monster Techie
 
MrCoffee's Avatar
 
Join Date: Feb 2006
Location: UK
Posts: 1,858
Default

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.
Attached Files
File Type: zip book1.zip (2.7 KB, 3 views)
__________________
Intel core I7 920
GA-EX58-UD3R
6GB OCZ platinum 1600
XFX HD4890
Noctua nh-u12p
Corsair HX520
Antec 300
Samsung 1TB F1 Spinpoint
Samsung SM2443BW 24"
MrCoffee is offline  
Old 08-16-2006, 04:22 PM   #7 (permalink)
True Techie
 
Join Date: Jul 2006
Posts: 146
Default

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



[img]myURL[/img]

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?
moisiss is offline  
Old 08-17-2006, 07:50 AM   #8 (permalink)
Monster Techie
 
MrCoffee's Avatar
 
Join Date: Feb 2006
Location: UK
Posts: 1,858
Default

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.
__________________
Intel core I7 920
GA-EX58-UD3R
6GB OCZ platinum 1600
XFX HD4890
Noctua nh-u12p
Corsair HX520
Antec 300
Samsung 1TB F1 Spinpoint
Samsung SM2443BW 24"
MrCoffee is offline  
Old 08-17-2006, 09:00 AM   #9 (permalink)
Ultra Techie
 
King X13's Avatar
 
Join Date: Jun 2006
Posts: 987
Send a message via AIM to King X13
Default

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.
__________________
[SIGPIC][/SIGPIC]
King X13 is offline  
Old 08-18-2006, 01:27 PM   #10 (permalink)
True Techie
 
Join Date: Jul 2006
Posts: 146
Default

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!!
__________________

moisiss is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 01:56 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.