Re: Unable to open excel file from Client



For some reason, your process can't see the file maybe. Perhaps it's
a security issue.

I'd put a line of code in before opening the workbook that checks for
FileExists. That would be illuminating. If it says it exists, then
the problem is with Excel. If it says it doesn't exist, then that's
your problem.

Robin S.
---------------------------------
"SK" <SK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:363EE2E0-624E-46F4-91D6-1DE3E1671E4B@xxxxxxxxxxxxxxxx
My Code (vb.net scripting)

objExcel = CreateObject("excel.application")
objBook = objExcel.Workbooks.open([filename])

i have the issues as stated below when the code reaches the
objExcel.Workbooks.open([filename]). The server is running under
Active
Directory too.

Error :
System.Runtime.InteropServices.COMException (0x800A03EC): '
c:\tmp\t21_vc_20061201_M12_ATP.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 been renamed, moved, or
deleted.

I had check the file do existed and i can use windows explorer to
browse the
path and open the file manually ( \\servername\path\filename.xls )


.