Malvern Instruments Zetasizer Series, Basic Reference Manual

Page: 118 / 123

We show such an example below for communication with the spreadsheet program Excel. Valid
items for Excel include strings of the form “R1C1", which addresses row 1 column 1 in a
spreadsheet document. In the example we make use of the Macro language string handling
capability to randomly access the first two columns of the target spreadsheet.
‘ Program to transmit Zeta potential values
‘ and class contents to Excel
‘—————————————————————————————-
‘
‘
‘——————————————————————————————
‘
‘ First connect to the default spreadsheet
‘ sheet1
‘
‘
dde connect 1,"excel","sheet1"
k=0 :’ initialise row counter
for z=0 to -40 step -2: ‘ Range of zeta values
‘
‘ initialise a$ then append zeta spectrum value
‘ to it
‘
a$=""
print a$ using “ ####.#”,zetavalue(z)
k=k+1
b$=""
‘
‘ Clear b$ and append the row and column
‘ string as the ‘item’ for the poke
‘
print b$ using “R#C2",k
‘
‘ clear the special buffer for the poke data
‘ and append the zeta data in a$ to it
‘
delete string
print string a$
dde poke,1,b$
‘
‘ Now do the same in column 1 for the zeta potential
‘ value itself
‘
a$=""
print a$ using “ ####.#”,z
b$=""
print b$ using “R#C1",k
delete string
print string a$
dde poke,1,b$
next
end
MAN0179
Page 5.2 Zetasizer 1000/2000/3000/4000/5000/4700
Artisan Scientific - Quality Instrumentation ... Guaranteed | (888) 88-SOURCE | www.artisan-scientific.com