Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
question about office web components in excel,
Dear all,
When designing the userform in VBA of Excel, I found tools/additional controls allow to add more controls in my userform. Then I tried to intert a Pivot table and a Chartspace into this userform. They look nice. But my question is, 1. how to link this pivot table with data in excel sheet, I tried to follow the help file, but can't find how to link Excel sheet with this pivot table, almost all the buttons are not available in inserted pivot table, except 'refresh' and 'property' 2.how to link chart with this pivot table, I choosed '3-chDataSourceTypePivotlist' in 'DataSourceType' in its property, is this enough? I want to 3. I follow the help of Excel, but in pivot table, when I click 'property toolbox' , I can't open it. only a message of error'A runtime error has occurred. Line9 error:object expected', if I choose to debug, windows opens 'microsoft script editor'. I'm really confused. Thanks. JIANG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem exporting data from Office PivotTable Components to Excel | Excel Discussion (Misc queries) | |||
installing web components into office 12 ( excel) | Excel Discussion (Misc queries) | |||
office web components | Excel Worksheet Functions | |||
Office XP Web Components supported by Office 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 not compatible with Office 2k Web Components -- HELP! | Excel Programming |