can't open excel from network drive using asp
-
Hi guys! I'm having a problem with opening an Excel spreadsheet located on a network drive using the old ASP (not ASP.NET). I tried opening the same file from my local test server and the code works perfectly. But when I try to open the file from a network path it gives the following error:- Error Type: Microsoft Excel (0x800A03EC) '\\server\exceltest.xls' could not be found. Check the spelling of the file name, and verify that the file location is correct. If you are trying to open the file from your list of most recently used files on the File menu, make sure that the file has not been renamed, moved, or deleted. I've also tried using a mapped path, ie. "G:\exceltest.xls" but still doesn't work. I've looked everywhere on MSDN for info on access rights but can't find any on this subject. Does anyone know if opening an Excel file from a network drive is possible? Thanks for your help. Much appreciated.