workbookconnection

  1. F

    Use cell value as Workbook Connection value

    Hi I'm looking to pass a value from a cell into a VBA query but unsure of the format. See below code as an example, in the working version of this code, the 3rd line has a specific value for the name of the WorkbookConnection, eg; With ActiveWorkbook.Connections("MyDataConnection") What I'm...
  2. J

    Excel VBA -- Run-time error '-2147417848 (80010108)': Method 'Refresh' of object 'WorkbookConnection' failed

    I am getting this error on a workbook connections refresh that is done in VBA. I am using Excel Professional Plus 2010 and Windows 7. The code is part of a complex workbook that has 20 sheets, 330 procedures and 8,326 lines of code. The module with the error modifies a connection to an Access...
    • jpmccreary
    • Thread
    • connections refresh connection run-time error workbookconnection
    • Replies: 3
    • Forum: Excel Questions
  3. T

    Anyone know a "Super DoEvents" or a way to force OLEDBConnection to update its refreshing property?

    Hi All, I've discovered recently that DoEvents doesn't yield to all events - for instance, OLEDBConnection objects do not update whilst VBA code is running when their state has been changed during a .Calculate call made from VBA, even if followed by a DoEvents loop. Aside from using scheduled...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top