Hi all,

I'm trying to create an excel object and do whatever I want with it. Just like how I would in Visual Foxpro 6 and Visual Basic 6. I add a reference to the Excel 9.0 Object Library via the COM tab.

It seems I can't access certain properties, objects, and collections. For instance if I do:


            Excel.Application objExcel = new Excel.Application();
            Excel.Workbook objBook = new Excel.Workbook();
            objBook = objExcel.Workbooks.Add();


I get an error saying there is no definition for Workbooks contained in Excel.Application.


But if I double click on the Reference, it opens Interop.Excel9.dll and I can find a "Workbooks" Collection in the Treeview with all the methods and properties.


Can someone help sort this out for me? What hoops of fire do I have to jump through to do some Excel automation?



Thanks

Well I solved my problem, although I'm not sure how or why. I deleted VBIDE.dll, Office.dll, and Interop.Excel9.dll from my bin\debug folder. I then readded the reference to Excel 9.0 Object library through the COM tab, and now all the methods and properties are there.

The Interop.Excel9.dll file it copied to my bin\debug folder is larger (by 200k) than the one I deleted. I'm not sure why the file is larger all the sudden, but it is.

I'm using Windows 2000 with Office 2000.

Thanks