Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing worksheets in xla add-in file
I have some sheets in my add-in file. how can I acces them manually. That
is, you cannot see them when using the file as an Add-in. Secondly, if I wanted to access data in these sheets, can I simply use the Thisworkbook Object to do so? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing worksheets in xla add-in file
in the properties of the workbook, change isaddin to false. When done,
change it back. You can reference the addin from the addin using ThisWorkbook. -- Regards, Tom Ogilvy "ExcelMonkey" wrote in message ... I have some sheets in my add-in file. how can I acces them manually. That is, you cannot see them when using the file as an Add-in. Secondly, if I wanted to access data in these sheets, can I simply use the Thisworkbook Object to do so? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Accessing worksheets in xla add-in file
#1. Manually:
hit alt-f11 (to get to the VBE) hit ctrl-r (to see the project explorer) click on your project hit F4 to see its properties change the isAddin to false Back to excel and do what you want. then back to the VBE and change isaddin to true (don't forget to save your changes) #2. If the code is in the addin, you can use ThisWorkbook. activeworkbook.range("a1:a10").value _ = thisworkbook.worksheets("topsecret").range(c1:c10" ).value ExcelMonkey wrote: I have some sheets in my add-in file. how can I acces them manually. That is, you cannot see them when using the file as an Add-in. Secondly, if I wanted to access data in these sheets, can I simply use the Thisworkbook Object to do so? Thanks -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what exactly prevents INDIRECT from accessing closed worksheets? | Excel Worksheet Functions | |||
accessing worksheets | Excel Worksheet Functions | |||
accessing worksheets | Excel Programming | |||
Question about accessing worksheets on an AddIn file | Excel Programming | |||
programatically accessing Macros in worksheets | Excel Programming |