ioncila
05-03-2010, 02:32 PM
Hi
I have this small network with 5 computers. It's an computer to computer network with no server. One of the machines stores all files that all users work on.
The store machine has 2 disks (C: and D:). D: is the shared disk where shared files are stored.
To prevent some anarchy in accessing files, I've created a workbook named "index" in D: where all shared file names are listed as links, so all users may access through respective path. Something like:
\\10.0.0.10\Principal\PrincipalFiles\Book1.xls
Where IP is the stored machine, Principal is the D: partition, PrincipalFiles is the folder where shared files are.
Somehow, this is not working (msg " Can't find specific file...")
What is wrong with links? Is VBA a better solution?
Thanks
I have this small network with 5 computers. It's an computer to computer network with no server. One of the machines stores all files that all users work on.
The store machine has 2 disks (C: and D:). D: is the shared disk where shared files are stored.
To prevent some anarchy in accessing files, I've created a workbook named "index" in D: where all shared file names are listed as links, so all users may access through respective path. Something like:
\\10.0.0.10\Principal\PrincipalFiles\Book1.xls
Where IP is the stored machine, Principal is the D: partition, PrincipalFiles is the folder where shared files are.
Somehow, this is not working (msg " Can't find specific file...")
What is wrong with links? Is VBA a better solution?
Thanks