Getting OLEexception while trying to run Microsoft Excel with RealBasic

[Adamya]

I have installed RealBasic on the computer of mine as well installed Microsoft Excel. Well I am getting an exception whenever I am trying to run Microsoft Excel from RealBasic. I don’t know why the above mentioned issue is happening into the situation of mine. Let me know if you are having the same problem which I have mentioned over here? I am waiting for the prompt replies of yours. Thanks a lot in advance.

[Steyn]

Well looking at the problem which you have mentioned over here I wanted to know which version of operating system do you have installed on the system? Tell me which version of the RealBasic and Microsoft Excel do you have installed on the computer? you told me that you are getting an error message on the system of yours so post the entire error message so that I can figure out the root cause of the problem.

[Shreevats]

In this particular problem I am suggesting following code which you should run on the computer of yours.

Dim excel As New OLEObject("Excel.Application")
excel.Visible = True
excel.Workbooks.Add

I am hoping that the above mentioned code will help you to fix the matter of yours.

[Villiers]

Let me know whether the previously mentioned code is working for you or not. If there is no change in the situation than you can try to fix the matter by using the following code.

Dim excel As Object
Set excel = CreateObject("Excel.Application")
excel.Visible = True
excel.Workbooks.Add

[Ronchi]

Well I was also having the same problem which you have mentioned over here and I have run the following command and luckily it worked for me and I am not having issue. So you can try the code which I have mentioned over here and I am hoping that it will be useful to you.

dim exlApplication As ExcelApplication
dim wrkTest As ExcelWorkbook
  
exlApplication = new ExcelApplication
exlApplication.Visible = True
  
wrkTest = exlApplication.Workbooks.Add

[Dwarner]

Do you have tried to do VBA automation on the office such as opening the word or excel workbook. If it is not working for you then there should be change into the office automation engine. I am not sure but there could be something wrong with the setup of the software. Hence I recommend that you should reinstall both Excel as well as RealBasic on the computer of yours and see whether you have resolved the matter or not.