When were Querytables added to excel?

[MoshiM]

I'm currently generating Querytables via vba since Windows Queries don't carry over to MAC . Is it possible to use this method for older versions of Excel that don't have Power Query /Get and Transform?

Additionally how can I access QueryTable Events { QueryTable object (Excel) } ? I don't see an option for them within the Worksheet Module {Using Excel 2016 Windows}.

 

[MoshiM]

Disregard the 2nd question. I'll open a different thread for that.

 

[MoshiM]

Posted here as well.

Do Excel versions without Power Query / Get and Transform have access to the QueryTable Object Model?

I'd like to know if a user can use a QueryTable created via VBA to retrieve data if their version of Excel doesn't have access to Power Query / Get and Transform if on Windows or Mac.

stackoverflow.com

 

[Fazza]

Query tables have been around since Excel 5, I think. ~1995. (No idea about MAC though.)

Have a look at

Accessing Data From Excel 97 and 2000