Load files from multiple folders within a directory

[#1]

Good day

I'm trying to import Excel files from a number of folders within a directory structure. Each folder only contains one file per customer.

Within Family Packs I have a folder per customer which contains my Excel file that I need to load.

Exmaple Folder structure is as follows:

Parent Folder   :  D:\QlikView\QVDocuments\Stonehage\FamilyPacks

Client Folder 1 : D:\QlikView\QVDocuments\Stonehage\FamilyPacks\Kirsh

Client File       :  Kirsh.xlsm

Client Folder 2  : D:\QlikView\QVDocuments\Stonehage\FamilyPacks\Douglas

Client File       :  Douglas.xlsm

I'm not to sure where I'm going wrong, I have tried to view other forum posts but have not come right yet.

I have tried a number of options but have left the last two attemps in the document attached with the error I'm getting.

Any help will be greatly appreciated.

[Gysbert_Wassenaar · Accepted solution]

Looks like your file names contain special characters like brackets and/or paretheses. Make sure the file name is enclosed in square brackets in the load statement. See here for example

[#3]

Thanks for the help worked perfectly.