i have an external excel spreadsheet version 2003, column A contains about 5 rows of numeric values. i need to create a SUM function in vbsedit that totals these rows from column A in excel and passes it as a variable within my vbsedit script. i need step-by-step as I can't find sum function within vbsedit program at all.
my range is Range("A2:A100") and I need to create a vbsedit script and then pass the total into the following function where r is going to be this total from coulmn A.
line="SCH" & sep & r & sep & "EA***169*20(ddate)"