Runtime error "Remote Call Procedure Failed"

[pushpi004]

Hi everyone



I have been getting a a lot of help on this forum for my ongoing small project. Specifically, Paul aka macropad has helped me a lot. This issue actually has come pertaining to one of his code.

I have been dealing with an issue lately. I have written a macro in MS word and exported it with relevant referenced Excel files to another system with different configuration.The details are as follows:-

Current system: Windows 10 OS, MS Office 365

New system: Windows 7 OS, MS Office 2007

Upon running the code on the new system after importing it, the runtime error "remote procedure call failed "comes on the line

Set xlWkBk = xlApp.Workbooks.Open(FileName:=StrWkBkNm, ReadOnly:=True, AddToMru:=False)


I have already defined xlApp, xlwkBk as object and StrWkBkNm as location for Excel file. xlApp has also been set with Excel application object.

The code runs perfectly on my current system.
I have tried all sorts of variables for open method but it doesn't work. On giving the direct path of the database, it gives error sometimes as
"Runtime error object required" or sometimes it gives error "open method of workbooks failed" .

I have even changed the database file compatible to MS Excel 2007. But that doesn't work either.

I am struggling with this since couple of days. Can't get through. Please help if you can..
Regards