Addins store data
 

Hi,


I create a workbook with VBA (test.xls) then save as addin (test.xla).
Some data is stored at xla's worksheets(1) and worksheets(2).

Now I open a new workbook(mybk.xls), how can I access from new
workbook's VBA to xla's worksheets(1)'s cell?


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=540517

Addins store data
 

You shouldn't do it fro the workbook, access it from code within the add-in.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"gabch" wrote in
message ...

Hi,


I create a workbook with VBA (test.xls) then save as addin (test.xla).
Some data is stored at xla's worksheets(1) and worksheets(2).

Now I open a new workbook(mybk.xls), how can I access from new
workbook's VBA to xla's worksheets(1)'s cell?


--
gabch
------------------------------------------------------------------------
gabch's Profile:
http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=540517