Good Day

My questions relates to ODBC connections to an SQL Server, We are soon
migrating to a new SQL Server and have serveral files that link to it to
retrieve data for pivot tables, My question is " Is thier a way to code the
connection in VBA rather than going thru the wizard" I hoping I can add this
code to our many files and not have to go thru the wizard to relink, which
may be time consuming, also I was trying to get the code inplemented so we'll
have an head start

Thanks Cip