mIRC Home    About    Download    Register    News    Help

Print Thread
#5753 10/01/03 12:48 AM
Joined: Jan 2003
Posts: 9
C
crashy Offline OP
Nutrimatic drinks dispenser
OP Offline
Nutrimatic drinks dispenser
C
Joined: Jan 2003
Posts: 9
im trying to read data from an excel sheet online.

the link is:

www.asx.com.au/programs/Vols&Divs.xls

and I am using:

//echo $dde(excel,www.asx.com.au/programs/Vols&Divs.xls,d7)

D7 is the cell I wish to read.

What am I doing wrong? Yes the sheet is open.

Thanks in advance

#5754 10/01/03 08:28 AM
Joined: Dec 2002
Posts: 1,922
O
Hoopy frood
Offline
Hoopy frood
O
Joined: Dec 2002
Posts: 1,922
Syntax: $dde(excel,[filename.xls]SheetName,RrowCcolumn)

(filename is meant to be without path)

Try: $dde(excel,[Vols&Divs.xls]Sheet1,R7C4)

Reference #1 Reference #2 (Don't worry if you don't understand those texts, it also took me hours to figure it smile)

#5755 10/01/03 01:48 PM
Joined: Jan 2003
Posts: 9
C
crashy Offline OP
Nutrimatic drinks dispenser
OP Offline
Nutrimatic drinks dispenser
C
Joined: Jan 2003
Posts: 9
thanks

just one problem.......

what are these excel control codes and how do i get rid of them? ive tried $strip(text,burcmo)


Link Copied to Clipboard