-
Recent Posts
- Install .apk on phone with mac
- InMemory shapefile or featureclass creation
- IConversionOp RasterDataToLineFeatureData Example
- Reclass by Remap
- IDensityOp PointDensity Example
- Excel: Finding closest value
- NSLog boolean
- Excel Functions
- zAware, add point to polyline, extend line, query filter, query nearest point
- Output text files in Excel VBA
- PCL Zip temp files location
- Automate Excel faster
- (no title)
- HTML limit access to mp3/swf
- display chinese stored in mysql
- Event Handler
- modProgBar
- Check if folder exists
- Editing the source files in Eclipse PDT
- iOS materials
- augmented reality api
- Good tutorial of using Flot
- Wiring events in arcGIS VB.NET 10 and VBA
- Include PDF file in vbproj
- How to start developing Mixare iOS
- Excel Number Formats
- PhoneGap
- Understanding VB .NET Code Part 2
- Open Excel with ArcGIS VBA
- Understanding VB.NET Code
-
Categories
- .NET (5)
- Arcgis 10 (1)
- ArcGIS 10 Add-ins (3)
- ArcGIS VB .NET (10)
- ArcGIS VBA (9)
- eclipse PDT (1)
- Excel (2)
- Excel VBA (2)
- Flex (1)
- iOS (1)
- mixare (1)
- PHP (3)
- Uncategorized (15)
- Wordpress (1)
- Xcode (3)
-
Tags:
.NET 3d add add-in add point to polyline arcgis Attribute axis bundle Chart Clean collection COM config Dim eclipse PDT Event Excel extend line feature field flex Flot format garbage Handlers Hello world horizontal ifeature IGeoFeatureLayer import Interop intersect intersection iOS IPad Iphone Ipointcollection ITopographicOperator jQuery language Listeners manual calculation Marker mixare MUI number Object pdf query QueryFilter Release Renderer resources reverse select selectfeatures Sheet sound startup Store Symbology Tin tutorial txt update user Value VBA vertical Visible WithEvents Xapp xml zaware -
Top Posts:
- Install .apk on phone with mac
- InMemory shapefile or featureclass creation
- IConversionOp RasterDataToLineFeatureData Example
- Reclass by Remap
- IDensityOp PointDensity Example
- Excel: Finding closest value
- NSLog boolean
- Excel Functions
- zAware, add point to polyline, extend line, query filter, query nearest point
- Output text files in Excel VBA
-
Monthly Archives:
-
Blog Stats
- 9,834 hits
Tag Archives: Chart
The much hated Excel Chart Object
For more details, visit here:
http://msdn.microsoft.com/en-us/library/aa213725(v=office.11).aspx
When you find that the Xapp.SHEET call in VB.NET hangs, this might be the problem:
What you are trying to call is a CHART OBJECT, not a SHEET, although it looks like one!
Chart objects only have a tab at the bottom of Excel, but they do not contain cells.
To activate a sheet, make this call:
XApp.Charts(Sheetnumber).Activate()
I hope this helps some people out there!
rikstechblog 