VBA to update ThisWorkbook's path and directory #10


closed enhancement
sio submitted on Fri 02 February 2018 # OWNER

Create VBA function (on Workbook_Open) to update the path to the current directory and the current workbook in the custom query.

Idea:

ThisWorkbook = 
[
  folder = "C:/Docs/",
  path = "C:/Docs/Workbook.xlsm",
  filename = "Workbook.xlsm"
]

Inspired by http://excelunplugged.com/2018/01/23/modifying-power-query-m-code-with-vba/

sio labeled enhancement on Fri 02 February 2018
sio commented on Wed 09 May 2018 # OWNER
sio closed this issue on Wed 09 May 2018