Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
RPC server is unavailable from Excel 2003
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
RPC server is unavailable from Excel 2003
Miscellaneous
Thread ID:
00886834
Message ID:
00886834
Views:
154
I have an application that I wrote about five years ago that creates Excel spreadsheets based on an Excel template and data from VFP. This application was written with VFP6. I have had no problem with it until some of the users upgraded to Office 2003 on XP machines. Now they occasionally get the error "OLE error code 0x800706ba: The RPC server is unavailable."

The code is:
PUBLIC goExcel
goExcel = CREATEOBJECT("Excel.Application")
WITH goExcel
.Workbooks.OPEN("TEMPLATE.XLS"))
.Workbooks(1).ACTIVATE()
.VISIBLE = .T.
.DisplayFullScreen = .T.
ENDWITH

IF TYPE("goExcel") = "O" AND !ISNULL(goExcel)
oWS = goExcel.Sheets(1) && This is the line where the OLE error occurs
oWS.Cells(5,1).VALUE = "Company Name"
oWS.Cells(6,1).VALUE = "Company Address"
...

Does anyone know what causes this OLE error? Note: I have not had the error when the user is running Office 2000.

Thanks,
Pauline
Reply
Map
View

Click here to load this message in the networking platform