View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Dennis is offline
external usenet poster
 
Posts: 3
Default Help needed - Strange hyperlink problem

I have a strange issue with creating hyperlinks on desktops but not on
lap tops.

We received some new laptops at work that run on Windows 7 OS and
Microsoft Office 2007. We also had some desktops that were UPGRADED from
Windoxs XP to Windows 7 and Microsoft Office 2007.

The issue is that when I create a hyperlink on the desktop and I use the
browse to drill down to the network folder where the file is kept, it
takes (no jokes) 2 to 3 minutes to open the folder directory. Since the
folder containing the files I need to hyperlink to is a few folders deep
it takes over 10 minutes to create a hyperlink. The problem is with
hyperlinks only. If I browse on File/Open... there is no delay drilling
down to the folder I need to get to.

If I create the hyperlink on the laptop, there is no delay in opening the
folders directories (2 - 3 seconds per folders).

My IT group is working on resolving the issue but in the meantime I am
trying to create a macro that would open the folder where the files are
kept without browsing and be able to select the file I want to link to.

I used the macro recorder to create a hyperlink but I am forced to select
a specific file (macro would always put a hyperlink to the same file), I
can't figure out how to be able to select a different file every time.

I'd appreciate any anyone could give me.

Dennis