Re: [MSAccessProfessionals] VBA code to open a excel file with power query etl and 'refresh it all'

Hi anzus101,

I'm not sure why you need to refresh. I just 

-created a link to an Excel file

-opened the Excel file

-added a new column

-closed the Excel file

-opened the linked Excel table

-the new column was visible with no extra effort

Duane

---

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> on behalf of anzus101 <anzus101@gmail.com>
Sent: Thursday, September 29, 2022 6:30 AM
To: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io>
Subject: Re: [MSAccessProfessionals] VBA code to open a excel file with power query etl and 'refresh it all'

 

Adding more detail;

I have the excel files as linked tables, so I need a macro that can 'refresh all' the excel file, which includes the underlying power query. I want to add a button in a form.

On Thursday, September 29, 2022, anzus101 via groups.io <anzus101=gmail.com@groups.io> wrote:

Guys, 

I am using Power query to do a lot of ETL to then import into a db. I would like to have a macro that automates this task. Could you please share any code you may have for this regard? Thank you so much in advance.