J
John
I want to be able to generate Excel spreadsheets, charts, etc., from
Access. Are there good books that explain the Excel objects (from the
standpoint of a VBA program not running in Excel) ? While looking at
Excel macros are useful, it does not always help you to know what object
properties or methods you need to call. For instance, in the book Access
2002 Developer's Handbook, there is a code sample to generate a chart as
shown below:
objResultsSheet.ChartObjects(1).Chart.ChartWizard Source:=objXLApp.Union
(objResultsSheet.Range("B2:C2"), objXLRange)
I would never have found this solution. Unfortunately the Developer's
Handbook does not go in to much detail in to Excel's objects. Most of
the Excel programmng books don't cover controlling Excel from other
applications and on those supporting objects.
John
P.S.
Please respond to the list, not my email address.
Access. Are there good books that explain the Excel objects (from the
standpoint of a VBA program not running in Excel) ? While looking at
Excel macros are useful, it does not always help you to know what object
properties or methods you need to call. For instance, in the book Access
2002 Developer's Handbook, there is a code sample to generate a chart as
shown below:
objResultsSheet.ChartObjects(1).Chart.ChartWizard Source:=objXLApp.Union
(objResultsSheet.Range("B2:C2"), objXLRange)
I would never have found this solution. Unfortunately the Developer's
Handbook does not go in to much detail in to Excel's objects. Most of
the Excel programmng books don't cover controlling Excel from other
applications and on those supporting objects.
John
P.S.
Please respond to the list, not my email address.