I'd like access to system variables like %userprofile% or %cd% or something like "the current directory that this file resides in" so that you can have XLS file with Power Query that then points to a separate file in the current directory...whether it's on your laptop or on a sharedrive. I have XLS with PowerQuerys that I'd like to share with people who might not have the knowledge to modify the queries.
2 Comments
- Hello, I agree that it is necessary, In VBA use Environ () . As it is called in Power Query? Thank you, Luisg
- Status added:Needs Votes
