creating a query using MSQuery

[matpj]

Hi all,

I usually create a query by creating an appropriate DSN in my contro
panel, then choosing that MSN from MSQuery when it fires up in Excel.

The data is then returned to the sheets etc etc.

This means that each user that wants to run the spreadsheet and refres
data needs to have the correct DSN set up (same name)
Is there an alternative to this, so that end users do not need the DS
created? They can just open the spreadsheet and refresh..


Thanks in advance,
Mat