I’m trying to use

I’d like to set up some VBA so that users are prompted to select 2 different filepaths, and those files are then set as the source in two different powerquery tables. I’d like to just set it so the powerquery code can refer to a variant defined by the VBA instead of referring to the named cell in the excel sheet. Any solutions?

Closed 6 hours ago.

Closed 24 mins ago.

This sub is a Excel 2019 Power Query that imports a user selected delimited text file and then extracts the required data.

I have a shared Excel file with a Power Query that extracts data from an external local file. However, several users work with the shared file and they need the Power Query to access the local file from their PC’s local directory.

My company is shipping some parts to external paintshops. There is a number of paintshops and many part numbers.
I have a list with history of every move (shipped and returned).
My goal is to process the list so only those recently sent goods are on the list.
To explain it better, please see the example:

I have a table there rows represent time period. Columns represent different locations “kiosks”.
And values represent sales in each kiosk on different times.

I am trying to create exact copy of excel sheet in another file. I have tried using the following three methods

I’m trying to find an exact timestamp for a query to find exactly when a datapoint was updated in my database yesterday (No way to retrieve this otherwise).