Recent content by 10Miler

I figured it out! There is a setting in Excel to disable add-ins. You have to add the Developer tab to the ribbon in MS Excel 2007. Then you go to Excel Options, then Add-ins. Check the box to disable add-ins. WOOHOO!

I removed all references to Excel, and it doesn't work. I am using late binding, but this is in my existing project. I guess I will need to make up a dummy project.

Well, I put the ExcelApp.Visible before the Workbooks.Add code and it opens Excel, then throws the error on the Add line. The workbook sheet does open though.

Ok, I got 2007 installed on my dev machine. Made sure the reference was pointing to MS Excel 12 Object Library. Recompiled and it still bombs! AHHH!!!

FYI, the code bombs at this line: Set WorkBook = ExcelApp.Workbooks.Add(xlWBATWorksheet) That is consistent with my original code. It bombs at the Workbook.Add part. I will look at the GetObject and CreateObject link. Thanks!

dilettante, A guy I work (with Excel 2007) with gets the same error when trying to run the .exe. But there is another person that has 2007 and doesn't have a problem. strongm, Are you compiling and running on the same machine? I am compiling on a machine with Excel 2003, and running on a...

dilettante, I just copied that code into my app and it produces the same error. What now?

dilettante, Yes it fails with Excel 2007. I will try that code in my app.

Roy, I don't think any of those things are causing the problem. This app has worked well for years. Then I get Office 2007 on my computer and I get this error. It would seem to be a version dependency issue, but I'm not sure.

Ok, here you go. Private Sub ThisReportInExcel 10 On Error GoTo ThisReportInExcel_Error ' Declare our Excel objects. Dim MyCMD As New ADODB.Command Dim param As ADODB.Parameter Dim Myrs As ADODB.Recordset Dim MyExcel As Object Dim MyWorkbook...

Still not working.

Ok, I am changing ActiveSheet to Sheets(1).

Ok, I have declared all of the objects as Object and dropped the reference to the Excel Object Library. I still get the same error. Do I need to set the objects with CreateObject? I am only using CreateObject with the MyExcel object.

After searching I found out that I should change this line Set MyExcel = New Excel.Application to this Set MyExcel = CreateObject("Excel.Application") Is that all I need to do?

Ok, with my example how would I use late binding?