#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default hyperlinks

Hi!

How can i go 1 step back from a hyperlink object even if it is to another
workbook?
I create hyperlinks with code, and then i want to follow it. Thats not a
problem. Then i want a new macro to get back from that link to the previuos
even if it is another workbook.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default hyperlinks

You mean that workbookA opens workbookB with a hyperlink and you want
WorkbookB to know where the link came from ?
If so, no possible AFAIK, as the destination has no knowledge of where the
link came; it is told open by windows, so it does.

NickHK

"Mogge" ...
Hi!

How can i go 1 step back from a hyperlink object even if it is to another
workbook?
I create hyperlinks with code, and then i want to follow it. Thats not a
problem. Then i want a new macro to get back from that link to the
previuos
even if it is another workbook.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default hyperlinks

Hello NickHK!
But way thas it work when push web link back.


"NickHK" wrote:

You mean that workbookA opens workbookB with a hyperlink and you want
WorkbookB to know where the link came from ?
If so, no possible AFAIK, as the destination has no knowledge of where the
link came; it is told open by windows, so it does.

NickHK

"Mogge" ...
Hi!

How can i go 1 step back from a hyperlink object even if it is to another
workbook?
I create hyperlinks with code, and then i want to follow it. Thats not a
problem. Then i want a new macro to get back from that link to the
previuos
even if it is another workbook.




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default hyperlinks

Yes beacuse the application (Excel or your web browser) is keeping a list of
the places you visit.
But each file does not know where it is in that list. It is just "open" or
"not open".

What are you trying to achieve ?

NickHK

"Mogge" ...
Hello NickHK!
But way thas it work when push web link back.


"NickHK" wrote:

You mean that workbookA opens workbookB with a hyperlink and you want
WorkbookB to know where the link came from ?
If so, no possible AFAIK, as the destination has no knowledge of where
the
link came; it is told open by windows, so it does.

NickHK

"Mogge" ...

Hi!

How can i go 1 step back from a hyperlink object even if it is to
another
workbook?
I create hyperlinks with code, and then i want to follow it. Thats not
a
problem. Then i want a new macro to get back from that link to the
previuos
even if it is another workbook.






  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default hyperlinks

OK.
I have one workbook, that containes hyperlinks to a sheet in that workbook
or another workbook. I want to get back one step in the hyperlinks.

"NickHK" wrote:

Yes beacuse the application (Excel or your web browser) is keeping a list of
the places you visit.
But each file does not know where it is in that list. It is just "open" or
"not open".

What are you trying to achieve ?

NickHK

"Mogge" ...
Hello NickHK!
But way thas it work when push web link back.


"NickHK" wrote:

You mean that workbookA opens workbookB with a hyperlink and you want
WorkbookB to know where the link came from ?
If so, no possible AFAIK, as the destination has no knowledge of where
the
link came; it is told open by windows, so it does.

NickHK

"Mogge" ...

Hi!

How can i go 1 step back from a hyperlink object even if it is to
another
workbook?
I create hyperlinks with code, and then i want to follow it. Thats not
a
problem. Then i want a new macro to get back from that link to the
previuos
even if it is another workbook.








  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default hyperlinks

Hello!
When i push the link web link arrow back it always return both to right
workbook and sheets.

"NickHK" wrote:

You mean that workbookA opens workbookB with a hyperlink and you want
WorkbookB to know where the link came from ?
If so, no possible AFAIK, as the destination has no knowledge of where the
link came; it is told open by windows, so it does.

NickHK

"Mogge" ...
Hi!

How can i go 1 step back from a hyperlink object even if it is to another
workbook?
I create hyperlinks with code, and then i want to follow it. Thats not a
problem. Then i want a new macro to get back from that link to the
previuos
even if it is another workbook.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks: Hyperlinks change on copy/paste? Rick S. Excel Worksheet Functions 0 November 13th 07 08:19 PM
Update 2000 Excel hyperlinks to 2003 hyperlinks lonv155 Excel Worksheet Functions 4 October 25th 07 05:51 AM
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! jacob735 Excel Discussion (Misc queries) 1 June 22nd 07 12:57 AM
Excel Hyperlinks- cell content v. hyperlinks herpetafauna Excel Discussion (Misc queries) 2 May 23rd 06 04:39 AM
Hyperlinks to =Hyperlinks formula - Challenging Electro911 Excel Programming 7 March 2nd 06 02:00 AM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"