Refreshing multiple OLEDBConnections in Excel Worksheet

  • Hi All,

    I have several OLEDB connections in my worksheet which I'm trying to refresh via VBA.

    My code is as abovefor one table. The problem is I get an error that says something along the lines of "Unexpected Error", "Exception from HResult: 0x800A03EC"

    I'm not sure what this means.

    I then get an option to send a "Frown"

    Is there something I'm missing in my code above?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!