How to link to a specific worksheet in a .xls

[OOP]

Hi all,

I am preparing some presentation slides that needs to open a specific worksheet in a workbook via hyperlinking.

The problem is that how can i enter the file name so that it can open the specific worksheet upon clicking on the link? For example, I have a file called test.xls on desktop that contain worksheets namely from 01 to 10. How can I open test.xls with worksheet, 05, displaying?

Any help will be greatly appreciated.
Thanks.

 

[xlbo]

by saving it with worksheet 5 active

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[OOP]

Hi Geoff,

Do you know if can i link it to a specific worksheet without using the 'pre-save' technique?

The reason is that i have a lot of worksheets inside the file and i have more than one link to the worksheets... so using the 'pre-save' cannot work..

 

[xlbo]

without VBA code you cannot do this

If you can write VBA, you can get it to open on any specified worksheet

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question