Mischief63
New Member
- Joined
- Apr 15, 2017
- Messages
- 21
Just was learning to use the new Get "from folder" method with the Sample Query, Custom Function, etc.
If you use a custom column and =Excel.Workbook[Content] and then moved the source folder to a new location fixing the query was no big deal (i.e., you just clicked on source and pointed at the new folder location.)
I just tried to move a folder to a new location and the query apparently needs changing in several places.
Am I missing something here? What's the advantage of using the new method if it's such a PITA to get the query to run when you move the source folder to a new location?
If you use a custom column and =Excel.Workbook[Content] and then moved the source folder to a new location fixing the query was no big deal (i.e., you just clicked on source and pointed at the new folder location.)
I just tried to move a folder to a new location and the query apparently needs changing in several places.
Am I missing something here? What's the advantage of using the new method if it's such a PITA to get the query to run when you move the source folder to a new location?
Last edited: