Hi
I have a workbook with 10+ connections.
Some connections are not being used.
These connections are used to produced an OLAP-type PVT.
Each connection having their own connection name.
Naming convention can be random.
I'm looking for a vba code to loop through all connections in the workbook
and
rename them to Connection 1, Connection 2, Connection 3, etc...
Many Thanks in advance for your assistance.
Regards,
arv
I have a workbook with 10+ connections.
Some connections are not being used.
These connections are used to produced an OLAP-type PVT.
Each connection having their own connection name.
Naming convention can be random.
I'm looking for a vba code to loop through all connections in the workbook
and
rename them to Connection 1, Connection 2, Connection 3, etc...
Many Thanks in advance for your assistance.
Regards,
arv