How to open a .xlam

gailb
3StarLounger
Posts: 254
Joined: 09 May 2020, 14:00

How to open a .xlam

Post by gailb »

I've been using the Eileens Random Data Generator 4 which works great, but curios, the code points to a source sheet. ThisWorkbook.Worksheets("scrOrdList")

How can you actually see this sheet?

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to open a .xlam

Post by HansV »

Assuming that the add-in is loaded:
Activate the Visual Basic Editor (Alt+F11).
In the Project Explorer on the left, expand the add-in and Microsoft Excel Objects under it, if necessary.
Select ThisWorkbook.
In the Properties window (press F4 if you don't see it), change the IsAddin property from True to False.
The add-in will become visible as a workbook.
When you're done, don't forget to change the IsAddin property back to True!
Best wishes,
Hans

gailb
3StarLounger
Posts: 254
Joined: 09 May 2020, 14:00

Re: How to open a .xlam

Post by gailb »

Boy, now wasn't that easy. I searched all of the web for this, but was coming up empty. Thanks Hans.

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to open a .xlam

Post by HansV »

I corrected the last word in my previous reply (from False to True), but you probably suspected that already.
Best wishes,
Hans