Import Excel Worksheet from Collab Site as Private Table Not Working
I'm importing an excel worksheet from a Teams/Sharepoint/Collab site and the "Private" setting doesn't work. dt = Open ("https://collab.company.com/:x:/r/sites/Folder/Shared%20Documents/General/Title%of%Excel.xlsm?download=1",
Worksheets( "Sheet1" ),
Use for all sheets( 1 ),
Concatenate Worksheets( 0 ),
Create Concatenation Column( 0 ),
Worksheet Settings(
1,
Has Column Headers(
...