Dim excel as New ExcelApplication crashes on Windows7

pasko · **Joined:** Thu Aug 16, 2007 11:37 am **Posts:** 30

My app that runs just fine on Vista crashes at the statement:

Dim excel as New ExcelApplication

on my new laptop running Windows7

Is there anything specific that I need to have for Windows7?

Thank you
Pasko

timhare · **Posted:** Mon Sep 24, 2012 5:23 pm

Do you have Excel installed?

eugenedakin · **Posted:** Mon Sep 24, 2012 8:54 pm

Hello Pasko,

I tried the following code on my Windows 7, Excel 2010, Real Studio 2012 r1 system, and it worked well.

Dim excel as new ExcelApplication  //create a new object
excel.visible = true   //show the excel application
excel.workbooks.add  //add a workbook to the application

excel.Range("A1").value = "Gallons" //Place text in the cell

excel = Nil  // Set the object to Nil

Exception err as OLEException //Check for Errors
MsgBox str(err)  //Display the Error

Could you give this a try? What versions of Windows, Office, and Real Studio are you running?

Sincerely,

Eugene

pasko · **Joined:** Thu Aug 16, 2007 11:37 am **Posts:** 30

I found out that the VBA was messed up on my machine. Duh! Which brings me to the next thought or question, I should say: will the RB executable run on machines with no Office or VBA? I have no way to test it because I am not allowed to remove Office, as you might have guessed it.
Thank you
Pasko

npalardy · **Posted:** Tue Sep 25, 2012 11:44 am

pasko wrote:

I found out that the VBA was messed up on my machine. Duh! Which brings me to the next thought or question, I should say: will the RB executable run on machines with no Office or VBA? I have no way to test it because I am not allowed to remove Office, as you might have guessed it.
Thank you
Pasko

No
Without Office the required OLE objects & libraries will not be present

pasko · **Joined:** Thu Aug 16, 2007 11:37 am **Posts:** 30

Do you know of a place where these libraries can be downloaded from?

npalardy · **Posted:** Tue Sep 25, 2012 2:32 pm

pasko wrote:

Do you know of a place where these libraries can be downloaded from?

No - they need to be installed & registered properly which is taken care of when Office is installed.

timhare · **Posted:** Tue Sep 25, 2012 3:06 pm

They wouldn't work without Office anyway.

eugenedakin · **Posted:** Tue Sep 25, 2012 8:43 pm

Hello Pasko,

Windows offers a free Excel viewer that can be downloaded here: http://support.microsoft.com/kb/913879. Installing this program should install and register all of the libraries needed for Excel to run on Windows.

The last time that I installed the Windows 7 OS, the code from my book worked with the viewer. The updated version of Excel may have changed but it worked at the time. I have written a book on programming Excel in Windows. You can view the Table of Contents for the Excel book here: http://scispec.ca/Realbasic/Publish/Publish.htm

I hope this helps,

Eugene
I Wish I Knew How To... Program Excel 2010 with REALStudio in Windows
I Wish I Knew How To... Program Access 2010 with REALStudio Desktop Apps in Windows
I Wish I Knew How To... Program Word 2010 with REALStudio in Windows

	Real Software Forums The forum for Real Studio and other Real Software products.
[ REAL Software Website \| Board Index ]

Real Software Forums

Dim excel as New ExcelApplication crashes on Windows7