write to/read from add-ins

[abartkowski]

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?

 

[Bernie Deitrick]

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

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

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

HTH,
Bernie

 

[Tom Ogilvy]

as long as the xla is loaded:

workbooks("MyXLa.xls").Worksheets("Sheet1").Range("A1").Value = 21

 

[Tom Ogilvy]

for example:

? workbooks("ATPVBAEN.xlA").Sheets(1).Name
REG
?
workbooks("ATPVBAEN.xla").Sheets("Reg").Cells.specialcells(xlConstants).Addr
ess
$B$1:$B$2,$A$25:$B$25,$A$27:$A$33,$A$44,$A$46,$A$50,$A$60,$B$64,$A$65:$A$195
,$A$202
? workbooks("ATPVBAEN.xla").Sheets("Reg").Range("A25").Value
AnalysisPath

as long as the xla is loaded:

workbooks("MyXLa.xls").Worksheets("Sheet1").Range("A1").Value = 21