Thread: Links and Chdir
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hansol Hansol is offline
external usenet poster
 
Posts: 1
Default Links and Chdir

Hi
I have 2 questions that I hope someone can help me with

1) Is there any way to turn of the update links box that appears in a workbook that references another workbook. I have tried looking at the links box under editlink, but the manual button is greyed out.

2) I have the code

chdir "\\Fs8\ssd-css-fin\eco\eco 2004-2005\eco_0405\SystemFiles\eco\
Application.Dialogs(xlDialogOpen).Sho

The first line is simply a ' virtual ' network set-up on my hard drive to imitate my work set-up. But sometimes the open file dialogue box points to the right path and sometimes it does not. This is true even if I use a simple path such as c:\
Is there a reason why it is so temperamental

All help is greatly appreciated

H.