PDA

View Full Version : How to open workbook in another computer



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

ioncila
05-04-2010, 09:29 AM
Hi I have tried the code below, without any success:

Sub LinkBook1()
ThisWorkbook.FollowHyperlink Address:= "\\10.0.0.10\D:\PrincipalFiles\Book1.xls"
End Sub

Error msg is "Can't open specific file" (my translation)

Is there another way to make it work?

Thanks

mdmackillop
05-04-2010, 09:36 AM
Have you tried mapping a Drive Letter to that shared disk?

ioncila
05-04-2010, 09:42 AM
Have you tried mapping a Drive Letter to that shared disk?

Thanks for response

Would you be more specific, please?

mdmackillop
05-04-2010, 10:00 AM
In My Computer/Tools/Map network drive, you should get this form. You can then use the W: drive or whatever, to link to the file location.

lynnnow
05-04-2010, 10:00 AM
Go to Windows Explorer, Tool, Map Network Drive and set your network folder to a drive letter, for example Y: or Z:

Then change your code to:

Z:\PrincipalFiles\Book1.xls


It should work.


HTH


Lincoln