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!

Advertisements
Post a comment or leave a trackback: Trackback URL.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: