Expresion with MS Excel


Private Function Evaluation (ByVal strExp as string) as Double

Dim oExcel As New Excel.Application

Dim oSheet As Excel.WorkSheet

oExcel.Workbooks.Add

Set oSheet=oSheet.ActiveSheet

oSheet.Cells(1,1)=”=” & strExp

Evaluation=oSheet.Cells(1,1)

oExcel.ActiveWorkbook.Close False

if Not oSheet is nothing Then

set oSheet = Nothing

End if

if not oExcel is nothing Then

oExcel.Quit

End if

oExcel.Quit

End Function

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