Issues with Conn.Open in Excel 2016

[HansPA]

Hi.

Anybody who has experience any problem with Conn.Open command in Excel 2016?

I have a sheet that works perfectly in Excel 2013 but does not work in 2016. I have isolated the problem to be in the Conn.Open command.

TechNet says that some versions of Excel 2016 has problems with connecting to external data, but hasn't come up with any solution yet.

Anyone in here who has a solution?

Regards Hans

 

[Norie]

Hans

What are you trying to connect to?

 

[HansPA]

I'm connecting to my SQL-database server. The VBA function looks like this:
Function VismaReal(FirmaDSN, Aar, PeriodeFra, PeriodeTil, Konto, Afd, Tusinde)
Set Conn = CreateObject("ADODB.Connection")
Conn.Open ("DSN=" & FirmaDSN & ";Trusted_Connection=Yes")

xxxxxxx

Conn.Close
End Function

The VBA function terminates at the conn.open command.

Regards Hans