Run time Error 9 - Specific Code Issue

**dreicer_Jarr** · 03-02-2010, 11:54 AM

The following code works when I have both the "controls 1" and "main file" open on my PC but these are to be shared workbooks on a common network drive. My code errors out when it gets to the second line (Windows("Main File.xls").Activate) because I don't think I am telling it exactly where to look (ie the proper directory).

Would that make sense? How would I tell it what directory to do to? Or, do you think it's something else?

Please Login or Register  to view this content.

**Marcol** · 03-02-2010, 12:05 PM

Try adding the full path name
eg

Please Login or Register  to view this content.

**dreicer_Jarr** · 03-02-2010, 12:17 PM

Thanks a lot, but I still get the same error on the same line. I checked the path name three times. Urgg!!

**Marcol** · 03-02-2010, 12:48 PM

If you want to open the file

Please Login or Register  to view this content.

**dreicer_Jarr** · 03-02-2010, 01:39 PM

The Workbook is open but it's open on another PC. Does that change things?

**Marcol** · 03-02-2010, 02:21 PM

Indeed it does!

I'm not to hot on working over networks but I suspect that that file will be locked by that user. and you will not be able to access it.

There is a way to setup for multiple user access but I don't know how to do it. Sorry.

It is in my limited experience better to have sole access to files that need updating/archiving etc.

Regards
Alistair