In the XLA, use code like:
Dim myValue As Integer

To read a value:
myValue = ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e

To write a value:
myValue = 3
ThisWorkbook.Worksheets("Sheet1").Range("A1").Valu e = myValue

HTH,
Bernie


"abartkowski" wrote in
message ...
I want to store some data in the XLA sheets and then use it in my
program. Is it possible to write/read the data using VBA? If so,
how?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/