compare two worksheet in Excel

[keys56]

How do I compare two cells in two different worksheets in Excel? I would like to compare A1 in worksheet 1 to A1 in in worksheet 2.

 

[knob]

Here is a script that shows how to compare R1C1 in worksheet1 and worksheet2. It requires that Excel and the spreadsheet be launched.

proc main
long LinkVar, SystemVar
string sSheet1, sSheet2

if ddeinit SystemVar "excel" "system"
if ddeinit LinkVar "excel" "sheet1"
dderequest LinkVar "R1C1" sSheet1
usermsg "%s" sSheet1
endif
if ddeinit LinkVar "excel" "sheet2"
dderequest LinkVar "R1C1" sSheet2
usermsg "%s" sSheet2
endif
endif
if stricmp sSheet1 sSheet2
usermsg "Cells are identical"
else
usermsg "Cells are different"
endif
endproc

http://www.aspectscripting.com

 

[keys56]

Thanks

 

[trout00]

How do I see hex value with Procomm DOS?
both on the transmit and receive sides
in Direct connect mode.