Using the wildcards to delete multiple

[Manan]

Hi ,

I have coded a VBA MAcro where i have writtne like below

 ActiveWorkbook.Connections("getHistoricalData1").Delete
 ActiveWorkbook.Connections("getHistoricalData2").Delete
 ActiveWorkbook.Connections("getHistoricalData3").Delete
 ActiveWorkbook.Connections("getHistoricalData4").Delete
 ActiveWorkbook.Connections("getHistoricalData5").Delete
 ActiveWorkbook.Connections("getHistoricalData6").Delete
 ActiveWorkbook.Connections("getHistoricalData7").Delete

but i have many such connections .Is their any way to have like
ActiveWorkbook.Connections("getHistoricalData****").Delete
i mean it will delete everything that comes after getHistoricalData string.

 

[Deepak]

Loop here!!!..

http://stackoverflow.com/questions/18837971/modify-existing-excel-connection-name-in-vba