Addins store data

  • Thread starter Thread starter gabch
  • Start date Start date
G

gabch

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?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macros in my custom xla Addin - how to make visible in Macro menu? 2
Handling a worksheet calculate event in XLA code 4
xla security warning 1
Relocating my AddIn 3
Calling a procedure from another workbook 4
COM addin won't connect when workbook opened via another workbookfrom another instance 3
UDF shows #NAME? when moved from XLA to XLL 2
excel 2003 Reading workbook properties / details from an XLA how do you do it? 1

Back
Top