Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
date: Mon, 12 Jun 2006 10:42:27 +0200,    group: microsoft.public.excel.interopoledde        back       


xlErr* in VB.NET   
Hi,

I'm using VB.NET to access Excel and I'm wondering how to get information 
about cell errors within a range object's Value property. The following 
simple code gives the current selection's value in rng, but I don't get 
information about e.g. xlErrNum, xlErrDiv0, xlErr* as I got in VB6 (or in 
VBA).

Is there any possibility to get the "raw" VARIANT values instead of the 
(from my point of view) crippled object values to also find out about 
VT_ERROR values?

Thomas

Public Class Form1

Private xl As New Excel.Application

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As 
System.EventArgs) Handles Button1.Click

Dim rng As Excel.Range

Dim res

rng = xl.ActiveWindow.Selection

res = rng.Value

End Sub

End Class
date: Mon, 12 Jun 2006 10:42:27 +0200   author:   Thomas Baier

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us