MicrosoftHi @Guy Hunkin,
I use a PC and have written a workbook using Power Query to share with colleagues, some of whom use Macs with Office 365. I want to share a Dropbox data file with them using their local syncronised folder as the source. I've written VBA to create and place the required path into a table and I use that as a parameter for the query to use as its source. This works fine with the PC but hits a firewall error on the Mac. If I hard code the path into the query then the Mac users can use Data / Connection / Change path to set it up for their system. However, I want the same workbook to be available to a number of users, each of whom has their own file path, hence the use of the parameter. I've tried using a staging query to decouple the workbook from the "external" data source but simply using the parameter seems to throw up the error, so I'm stuck.
Bottom line: Is it possible to use a parameter to set up a user's file path for a PQ in Excel for Mac 365, please?
Many thanks,
Pieter
