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.

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116307) | Reply To Group | Reply To Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_