How to program Excel named ranges with automation
-
Using Excel Automation in Visual Studio 2010 C++, how do I define a name? As a user of Excel, you can enter a name that then can be used in formulas to refer to a range of cells. The range changes as the user inserts columns or rows. My program has worked with various versions of Excel dating back to the early 2000’s. I have a bunch of classes derived from COleDispatchDriver: CXLApplication, CXLRange, CXLWorkbook, CXLWorkbooks, and CXLWorksheet that have many functions, but I have no documentation (anybody have any clues on where to find documentation?). Anyone know how to define a named range using functions of these classes (probably CXLRange)?
-
Using Excel Automation in Visual Studio 2010 C++, how do I define a name? As a user of Excel, you can enter a name that then can be used in formulas to refer to a range of cells. The range changes as the user inserts columns or rows. My program has worked with various versions of Excel dating back to the early 2000’s. I have a bunch of classes derived from COleDispatchDriver: CXLApplication, CXLRange, CXLWorkbook, CXLWorkbooks, and CXLWorksheet that have many functions, but I have no documentation (anybody have any clues on where to find documentation?). Anyone know how to define a named range using functions of these classes (probably CXLRange)?
-
These classes were generated years ago from the Excel type library using Class Wizard. I note that these classes can be generated using Class Wizard on Visual Studio 2010 as well: MFC Class Wizard->Add Class (arrow)->MFC Class from Typelib...->Add Class from Typelib Wizard->Available Type libraries: Microsoft Excel 15.0 Object Library<1.8>. Then you add the classes, using whatever names you want and the files are automatically generated. However, the classes in my legacy code are a bit different than later versions of Excel. Also if you know where to find documentation for these classes, it would be much appreciated.
-
These classes were generated years ago from the Excel type library using Class Wizard. I note that these classes can be generated using Class Wizard on Visual Studio 2010 as well: MFC Class Wizard->Add Class (arrow)->MFC Class from Typelib...->Add Class from Typelib Wizard->Available Type libraries: Microsoft Excel 15.0 Object Library<1.8>. Then you add the classes, using whatever names you want and the files are automatically generated. However, the classes in my legacy code are a bit different than later versions of Excel. Also if you know where to find documentation for these classes, it would be much appreciated.
-
These classes were generated years ago from the Excel type library using Class Wizard. I note that these classes can be generated using Class Wizard on Visual Studio 2010 as well: MFC Class Wizard->Add Class (arrow)->MFC Class from Typelib...->Add Class from Typelib Wizard->Available Type libraries: Microsoft Excel 15.0 Object Library<1.8>. Then you add the classes, using whatever names you want and the files are automatically generated. However, the classes in my legacy code are a bit different than later versions of Excel. Also if you know where to find documentation for these classes, it would be much appreciated.