I'm creating a VBA macro to test if the Query components of Excel are installed. On a machine, I removed then re-installed Excel using Custom Install, and I excluded Query and Add-ins. I then ran a macro to add a new query and to .RefreshAll.
It created the query and refreshed it! Apparently(?) neither the Query components or the ODBC Function add-in have to be installed to do a web query or refresh it using VBA.

As others will use my worksheets, this is an important piece. I would like to know for sure that a user can't choose to not install something that would cause the macro to error.

Any help would be appreciated! Thanks.