previous xlsb macro not working in xlsm workbook

[craigexcel]

Using Office 365 in the office.

I have a workbook with 1 sheet for dumping raw data to (Copy / Paste), along with 8 other sheets for operational States' data, for which relevant data is displayed via FILTER function formula.
At each quarter, to save each States' data in its own separate workbook, I was previously running my VBA from my PERSONAL.XLSB.
In the interest of making the (initial) data workbook a standalone workbook, I saved the workbook as .xlsm, and included the code in "This Worksheet".

Now, of course, there seems to be an issue with the following, where I add a new Sheet to the workbook, and then build up 2 Pivot Tables, starting with the one referenced below, which worked fine when run from PERSONAL.XLSB:

        Sheets.Add       'this line executes, but no Sheet is added to the workbook
        ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _             'this line causes "Run-time error '5':  Invalid procedure call or argument"
            "Sheet1!R1C1:R" & iLastRow & "C19", Version:=8).CreatePivotTable TableDestination:= _
            "Sheet2!R3C1", TableName:="pivot_mgr", DefaultVersion:=8

I'd appreciate your insight as to the cause and necessary fix. Thanks.

 

[craigexcel]

I continued tinkering with this problem to see if I could resolve it. I have hit on a solution, though I'm uncertain as to why it worked.
I moved the code from "ThisWorkbook", to "Module1".
Even though I only provided a small part of the code, given this 'solution', if anyone can offer some kind of explanation, I'd still appreciate it.

 

[RoryA]

The ThisWorkbook object has a Sheets property. Since you didn’t specify a workbook when you used Sheets.Add it defaults to ThisWorkbook.Sheets.Add and not ActiveWorkbook.Sheets.Add

 

[craigexcel]

The ThisWorkbook object has a Sheets property. Since you didn’t specify a workbook when you used Sheets.Add it defaults to ThisWorkbook.Sheets.Add and not ActiveWorkbook.Sheets.Add

Thx RoryA. I appreciate you taking the time to share your insight!