visual basic error 1004

[gas55au]

Hi, I run 2 excel spreadsheets which both load fine from a server and then run a macro but I get an Visual Basic error 1004. "G:<file name.xls> could not be found. Check the spelling of the file name and verify that the file location is correct. " This is strange because that is the file name of the second file which I have just opened so the networking is seeing the file okay. The problem seemed to occurr after my C drive was unshared. The same problem now also occurrs on another pc which also had its C drive unshared. Any suggestions?????

[AltatemTC]

Is G: mapped to the same place since the "unsharing"? If so, use UNC to specify the file location. (e.g. \\servername\sharename\foldername\spreadsheet.xls)