Hello
Rather than using this code in PQ at the beginning of the each query
How can I store that cell value into PQ and call it from all queries? rather than add it to all queriesPlease Login or Register to view this content.
Hello
Rather than using this code in PQ at the beginning of the each query
How can I store that cell value into PQ and call it from all queries? rather than add it to all queriesPlease Login or Register to view this content.
you can use named range instead of table
this is a very simple example where you can use query Value in every other queries
HTH
You are still using Table in the worksheet and call it in PQ
I want to use the one cell named range "PPath" and save it in PQ
then I will call it from other queries in the source step to put the dynamic path
example
This what I mean, but getting errorPlease Login or Register to view this content.
Expression.Error: We cannot apply field access to the type Text.Please Login or Register to view this content.
Details:
Value=c:
Key=Value
Last edited by Undo; 06-24-2023 at 05:24 AM.
Update:
This will work and I can call "PPath" from all queries to get the dynamic URL
but I have to edit the privacy settings in all PC that will use the file
is that any way to do it better that changing the settings?Please Login or Register to view this content.
as I said you can use named range instead of the table, read posts carefully
you only need to change privacy settings once or ask PQ manufacturers
This VBA in workbook open, will ignore privacy level for all queries and solve the problem
Thanks
Please Login or Register to view this content.
Will it cause problems for me?
I don't know, I just hate VBA, that's all
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks