Add ins & data in the add-in workbook

  • Thread starter Thread starter Richard Mogy
  • Start date Start date
R

Richard Mogy

I have created an add-in project. In the workbook associated with the addin
project I have stored some headings that I would like to copy to the
workbook that the user opens. I am missing how this is done and would
appreciate any enlightenment.

Richard Mogy
 
Richard,

I typically reference XLA data in this format

workbooks("XLA.xla").sheets("Sheet_Ref").Range("Range_ref")

Replace all items in quotes with appropriate references

http://HelpExcel.com
 
That solved it -- thank you for your assistance.
galimi said:
Richard,

I typically reference XLA data in this format

workbooks("XLA.xla").sheets("Sheet_Ref").Range("Range_ref")

Replace all items in quotes with appropriate references

http://HelpExcel.com
Click to expand...
 
You must log in or register to reply here.

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

COM addin won't connect when workbook opened via another workbookfrom another instance 3
How do I code VBA to return information from a web site to an excel workbook 4
Problem in adding macro to ribbon through Add-in 7
Add-in WITH worksheets?? 1
Open Referenced Add In Workbook as Read Only 5
Why is Add-In (.xla) Workbook Read Only when I try to save? 1
Unwanted workbooks on startup 2
Setting up Solver reference in a protected VBA project 1

Back
Top