ODBC connection excel VBA to Snowflake connection string needed

There is no ADO connection string for Snowflake. You have to access it via ODBC Data Source.

[ODBC]
driver={SnowflakeDSIIDriver}
server=
database=
schema=
warehouse=
role=
Uid=
Pwd=

You will need to go to the following link to install the most recent Snowflake drivers.
https://sfc-repo.snowflakecomputing.com/odbc/index.html