I write custom reports for my company using excel to pull data out o
access databases. Anyway, the issue I am having is at one of ou
customers it will no longer run the report. After some debugging I hav
found the following error..

Automation Error Remote Procedure Call Failed: #-2147023170

Anyway, it crashes when opening a new session of excel through th
macro
Here is the portion of the code that pertains to the crashing...

Sub OpenTemplate(File_Path as string)
Dim xlApp as excel.application
Dim xlDoc as workbook

set xlApp = CreateObjecT("Excel.Application")
*set xlDoc = xlApp.Workbooks.Add(File_Path)*
This is where it is error out. It runs just fine on my machine and al
of our other customers machines....

They are running Excel 2002; and Microsoft Windows XP.

Does anyone have a clue about why this would fail? The File_Path is th
correct file and I can open it manually. I even did an immediates windo
with just

*Workbooks.Add("c:\backoff\doc1.xls")*

That crashed Excel completely..

--
kralj
-----------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...nfo&userid=995
View this thread: http://www.excelforum.com/showthread.php?threadid=40094