EXCEL Web query with password protected data

[rvBasic]

Webqueries with the QueryTable.Refresh method generally works fine with VBA. However recently I stumbled accross a problem: How to perform a WebQuery where you have to Login and provide a password to get acces to the data. I can't find a property nor a method to supply that information.

_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[Loomah]

Hi
Not 100% sure about this due to limited experience but you could have a look at the SavePassword property of the quey table.

This is copied directly from the help file

"True if password information in an ODBC connection string is saved with the specified query. False if the password is removed. Read/write Boolean.

Remarks

This property affects only ODBC queries."

Happy Friday
;-)

If a man says something and there are no women there to hear him, is he still wrong?

 

[rvBasic]

As you observed, the SavePassword property is only valid for an ODBC connection, not for a Web query.

I probably will have to turn to a basic FTP program to achieve the desired result, but then a great deal (all of it?) of the QueryTable facility is lost in this particular (but not uncommon) case.

_________________________________
In theory, there is no difference between theory and practice. In practice, there is. [attributed to Yogi Berra]

 

[griet]

Hello,

I have the same problem, how did you solve it in the end ? can you help me ?