AddExpression Macro

[#1]

Hi Guys

i want to add the expression using macro but i want to evaluate also

AddExpression"Sum({<Name = {'var.Item(0).Text  '}>}   Data)"

The Problem is it is taking everything as a string which is between "" but i want to evaluate var.Item(0).Text

Please help

[deepakk · Accepted solution]

hi,

Try this code.

Graph.AddExpression "Sum({<Name = {" & var.Item(0).Text  & " }>}   Data)"

Deepak

[#3]

it is giving the error type mismatch

[deepakk]

just try var.text.

Can you attach an application.

Deepak

[#5]

thanks bro its working

[#6]

Can i get the no of rows in a particular table using macro?????????

[deepakk]

try this code

set TableBox = ActiveDocument.GetSheetObject( "CH01")

  v=  TableBox.GetRowCount-1