Register Login
im Axle Specialists
Reply
 
Thread Tools
Old 15-10-2004   #1
BadBoi Bonnet In Da Makin
 
Cinq_Sport_BiG_DaVE's Avatar
Join Date: Jul 2004
Location: Telford
Posts: 466
Thanks: 0
Trader Rating: 0
Cinq_Sport_BiG_DaVE has donated!
EXCEL codes - spaming but neeeeeed to know asap

heres the dilema

do hyperlinks on excel sheets have codes???????

i have done a data base 4 college n 1 need to find codes n formulas

but i have used hyperlinks aswell as macros



soooooo
in visual basic u can see the code for macros

but not for hyperlinks

but a hyperlink must have a code somehere because there must be a code that tells the sheet that if you click this word/icon/picture it needs to go to this page or what ever

there MUST be a code!

but where

what i have done
created a hyperlink to take me from 'sheet1' to 'sheet2'
simple enough but where is the code


i need this for my testing!!!!

ty

somthing for the clever ppl

reply asap
__________________
/\-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-/\
New - Cinq_Sport_BiG_DaVE
Old - BiG_DaVE_Cinq_Sport
Cinq_Sport_BiG_DaVE is offline Reply With Quote Quote 
Old 15-10-2004   #2
Join Date: Sep 2004
Posts: 78
Thanks: 0
Trader Rating: 0
Re: EXCEL codes - spaming but neeeeeed to know asap

I'm no VBA expert, but if you were to display the contents of a cell using VBA surely it would show you the actual contents rather than rendering it as a hyperlink as it does on the sheet.
__________________
[CENTER][IMG]http://www.my-sei.com/images/mysig.jpg[/IMG]
[URL=http://www.my-sei.com]www.My-Sei.com[/URL] [/CENTER]
TBSei is offline Reply With Quote Quote 
Old 18-10-2004   #3
Join Date: Aug 2004
Posts: 21
Thanks: 0
Trader Rating: 0
Re: EXCEL codes - spaming but neeeeeed to know asap

Just use a macro to switch from sheet 1 to sheet 2
Display code in VB script

Use ctrl + `(key) to display formulars in excel.

Hope this helps.
__________________
Cinquecento Sporting Red
Sporting Red is offline Reply With Quote Quote 
Old 18-10-2004   #4
Now hacking in PHP
 
Alex's Avatar
Join Date: Mar 2002
Location: At Home
Posts: 1,497
Thanks: 0
Trader Rating: 0
Alex has donated!
Switzerland 
Re: EXCEL codes - spaming but neeeeeed to know asap

Hyperlinks in word/excel are not part of VBA, they're OLE objects that invoke an action. Inserting a hyperlink is similar to inserting a WAV or AVI file into document. If you want to find out the hyper link url. Try this:

Code:
Range("A1").Hyperlinks.Item(1).Address
that will show the first URL in the cell A1, you can substitute the strings from the range array, and the item array with variables.

Hope this helps
Alex is offline Reply With Quote Quote 
Reply
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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

Forum Jump