browse for a file using excel 2003 1

[Mikeb1970]

Hi all,

I'm making an application that has to run on a network drive, which has been assigned the G: drive on my computer, but has other letters assigned to it when accessing it from other computers. What i would like to make is some sort of wizard where i can browse for the file , like in windows programms and then save that info into a file (like a cookie) on the C: drive where it can be found the next time i run the programm, thus making it faster to run. This is just the first part of the problem since i use the englisch version of excel 2003 and the other users use the dutch version , therefore i really need a way to determine on their computers where the needed files are.

Any thoughts are very helpfull

Thnx and with regards

Mike

 

[SkipVought]

Hi,

Use the SERVER path, rather than a DRIVE, like...

sConnect = "\\dfwsrv222\public\" & sFileName

Skip,
[sub]
[red][/red]
[/sub]

 

[Mikeb1970]

Looked for sconnect in the vba help files, but no results

also searching the internet did not provide any results

With regards

Mike

 

[SkipVought]

sConnect is a VARIABLE that I used as an example.

For instance...

workbooks.open sconnect

Skip,
[sub]
[red][/red]
[/sub]

 

[Mikeb1970]

Lol,stupid me

I understand what you mean now, very usefull tip
thank allot, should solve my problem.

Mike