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 )


.



Relevant Pages

  • Import Data Menus disabled
    ... reason, excel was opening a new workbook with all three ...
    (microsoft.public.excel.setup)
  • Re: On opening workbook - it kinda half closes :-S
    ... Medium Security, ... workbook issue rather than something with Excel as a whole. ... close excel and try opening excel in safe mode (which ...
    (microsoft.public.excel.misc)
  • Re: On opening workbook - it kinda half closes :-S
    ... Medium Security, ... workbook issue rather than something with Excel as a whole. ... close excel and try opening excel in safe mode (which ...
    (microsoft.public.excel.misc)
  • RE: SQL Slammer doing the rounds again?
    ... "I used to hate writing assignments, ... this - Is there a valid business reason to expose UDP ... > Security Business Unit ... > at the largest, most highly-anticipated industry ...
    (Incidents)
  • RE: protection
    ... the security message appeared. ... something else - such as viewing various sheets. ... in the front of the workbook. ... Private Sub Worksheet_Change ...
    (microsoft.public.excel.misc)