Working with Excel Active X Spreadsheet



I have added Microsoft Office Spreadsheet 11.0 to my COM Components and then
added a Microsoft Office Spreadsheet 11.0 'item' to a dialog. Now how do I
access the Spreadsheet through my program? I have a VBA example that does
what I want to do. In VBA they use commands like:



TempURL = "c:\Gen X Recipes\" & ComboBox1.Text

Spreadsheet1.HTMLURL = TempURL



UserForm1.Spreadsheet1.Height = 462

UserForm1.Spreadsheet1.Width = 588



Spreadsheet1 comes up as undefined and obviously I don't have a UserForm1 in
a MFC program?



More generally where can I find documentation for using Microsoft Office
Spreadsheet 11.0 component?



Thanks In Advance



P.S. I am just moving from Visual Studio 6.0 to 2008 so I am having fun
finding things


.



Relevant Pages

  • Reading data from an existing Excel file
    ... Visual Studio 2008 MFC program and then added a Microsoft Office Spreadsheet ... In the VBA example they use commands like: ...
    (microsoft.public.office.developer.automation)
  • Re: OWC Spreadsheet - Format cells design time?
    ... [Shameless Author Plug] ... The Microsoft Office Web Components Black Book with .NET ... >I am running Windows Server 2003, IIS 6.0, Microsoft Office XP full ... > I can now drag Microsoft Office Spreadsheet on my new WebForm. ...
    (microsoft.public.office.developer.web.components)
  • Spreadsheet object
    ... I´ve done some VBA Excel code and som VBA Forms. ... control and ticking "Microsoft Office Spreadsheet 9.0"). ...
    (microsoft.public.excel.programming)