odc

  1. E

    Rename and Save ODC files using VBA

    Greetings, all. First timer. I'm running models in Excel for MS365 which use from 5 to 15 Power Query queries from both external sources and from in-worksheet tables. Due to the nature of the data sources, each month I have to do fine-tuning of the queries, so a query named [proKPI_Owners]...
  2. J

    Excel VBA to change ODC Connection Files

    I've looked for three days and tried several solutions that were close but I'm still at zero progress. REQUEST: I exported the ODC Connection Files that point to my Dev and Prod SharePoint sites and uploaded the files to a SupportFiles Document Library the Workbook has access to. Right now, I...
  3. S

    how to import data using .odc file in Excel 2013 VBA

    I am trying to write some VBA that will import some data into a query table using a .odc file that is stored in a sharepoint data connection library. I used the macro recorder to record the process where I add the connection, then go to the existing connections and import the data into a table...

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