Changing Directory

[lynxbci]

Hi,
I am using a simple sub to change the default directory,

ChDrive "c:\ks projects"
ChDir "c:\ks projects"

This effects the file open perfectly.
However when using Insert Hyperlink, and it shows the current directory not the new default one.
Is there a way in VBA (excel 2010) to change the default/current directory that is displayed when i insert hyperlinks?

Thanks in advance

 

[Richard Schollar]

How are you inserting a hyperlink? I take it you are doing this manually rather than inserting one via VBA?

 

[lynxbci]

yes manually clicking, but user has to insert several, and it just defaults tot he current directory every time. It's a nice to have rathe than an essential

thank

 

[Richard Schollar]

I don't know of a way to change the default directory I'm afraid - even if using the hyperlinks dialog (from VBA) I can't see a way of passing in arguments...

 

[lynxbci]

Well if the MVP's can't find a way then that's good enough reason for me to give up.

thanks for checking

 

[Joneye]

Have a look at the below, may or may not assist.

http://office.microsoft.com/en-us/excel-help/hyperlink-function-HP010062412.aspx