Results 1 to 2 of 2

Thread: Parameter for Data Source when Data Source is a Folder

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Neophyte Caleb_RB's Avatar
    Join Date
    May 2018
    Posts
    1
    Articles
    0
    Excel Version
    Excel 2016 Office 365

    Parameter for Data Source when Data Source is a Folder

    Hello,

    I am trying to get a query that references a folder to change the file path with a parameter. I am wanting to do this so that it can be shared with several people and they can simple change the name in a cell and it will change the file path to their computer. However when I attempt to replace the file path with the parameter I get an error (attached below).

    When doing this with anything other than a folder I can go to the source step and use the advanced option to add a parameter to the source, but I have not found the equivalent solution to this.

    Any help with this would be greatly appreciated.

    Caleb
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Error.PNG 
Views:	10 
Size:	5.4 KB 
ID:	7943   Click image for larger version. 

Name:	PQ Issue.PNG 
Views:	13 
Size:	52.3 KB 
ID:	7944   Click image for larger version. 

Name:	AE for Query.PNG 
Views:	13 
Size:	55.0 KB 
ID:	7945   Click image for larger version. 

Name:	AE with Error.PNG 
Views:	12 
Size:	55.0 KB 
ID:	7946  

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •