strconnection

  1. M

    Import to excel from accdb access table held in Sharepoint

    Hi all, I have an access table that I query through excel. I know have to move the access table to our office 365 sharepoint It was held on a shared drive which I queried like below Sub TestImport() Dim cn As Object Dim rs As Object Dim strSQL As String Dim strConnection As String...
  2. welshgasman

    Why cannot Excel find the url?

    Hi all, I have an Excel sheet that used to download a few stock quotes. Yahoo have now stopped access. So I am tring another method, this time using Google finance. From a few YouTube videos I have pieced together the code below. If I take the connection string and paste manually (which is how...

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