Hi Jussi,
There is some code here that will work. http://groups.google.com/groups?hl=e...TNGP09.phx.gbl


--

John

johnf202 at hotmail dot com


"Jussi M" wrote in message ...
Hello!

How can I change current default folder to another, when that other folder
isn't mapped and is like \\something\intosomething.
I have a file in network folder which contains macros and it needs to work
with several different users and computers( some of computers that folder
isn't automatically mapped ).
Macro opens a file from the same folder, read data from it and closes the
file.
curdir, activeworkbook.path and activeworkbook.fullname wont work with
network addresses.
So little help with this would be nice, thanks.

JM

Thanks!

JM
"jaf" wrote in message ...
Hi Jussi,
There is some code here that will work. http://groups.google.com/groups?hl=e...TNGP09.phx.gbl


--

John

johnf202 at hotmail dot com


"Jussi M" wrote in message ...
Hello!

How can I change current default folder to another, when that other folder
isn't mapped and is like \\something\intosomething.
I have a file in network folder which contains macros and it needs to work
with several different users and computers( some of computers that folder
isn't automatically mapped ).
Macro opens a file from the same folder, read data from it and closes the
file.
curdir, activeworkbook.path and activeworkbook.fullname wont work with
network addresses.
So little help with this would be nice, thanks.

JM