Modifying Worksheet From AddIn

[jo15765]

I have a Excel Add-In that is a .xlam and has a module in it. I am needing to add to that module and manipulate a worksheet. If I test my syntax in a standard workbook standard module it works as expected, but the second it is added into the add-in syntax it stops behaving the way that it should.

Issues with synatx:
1) Pop-up asking where Sheet named Helper is (it is a sheet in the open workbook, verified name was exactly right, no whitespace)
2) Unable to write to sheet that is saved in add-in (again verified name is exactly right, no spaces or whitespace etc)

Syntax - to access the worksheet that is in the add-in I use this

Please Login or Register  to view this content.

No error is thrown there, but the second I try to write to it like this, nothing is ever written to the sheet.

Please Login or Register  to view this content.

Display of issue with accessing data on active worksheet the sheet that is visible in the workbook, if I try to use a quick count to get the last row an error is thrown that says application defined or object defined error.

Please Login or Register  to view this content.

How can I use a macro from an addin to access & modify sheets in the workbook/add-in?

[Zer0Cool]

Curious why it needs to be an addin?

Have you tried unhiding the sheets prior to working with them?

Also have you tried changing from "thisworkbook" to a more explicit reference to the addin/workbook?

You could also toggle the .IsAddin property of the xlam workbook to false before writing to it and true when you are done. Im leaning towards this being the answer

[jo15765]

It is an addin due to that being the current process and I am just trying to add to it for additional manipulation.

How would I change from "thisworkbook" to a more explicit reference?

I will look for syntax on changing the .IsAddin property of the xlam to false so I can "see" the sheets and write to them/modify them.

[xlnitwit]

Hi

Why are you trying to write to a sheet in the add-in and how are you verifying that it doesn't work, given that you can't see the worksheet in question?