Creating connections in Smartview

All,

I have an excel worbook with 3 spreadsheet. Each spreadsheet must connect to a different essbase application (within the same EPM installation). Like many other I have to make sure the connection exists and if not create it. It is when creating that I have my question. I am wondering if you create variables for each create connect statement or use the same variable

X=HypCreateConnection (...App1.. )

X=HypCreateConnection (...App2...)

or

X =HypCreateConnection (...App1.. )

Y= HypCreateConnection (...App1.. )

My gut tells me to use individual variables so as to be able to troubleshoot if a createconnect fails,

appreciate any input.