Hai,
I have 2 question.
1) Any possible that I can change the source file by selecting the cell contain the file name without editing the query editor. Example , if I want to change the file name to 04 to 05, just type at any cell in excel and the query will change
2) I have few file to merge and append, how I can change the source file at 1 time for all the file. Example, I want to recon for month of Apr 2016, so the source file should change the file only for april 2016.
Thank you
I have 2 question.
1) Any possible that I can change the source file by selecting the cell contain the file name without editing the query editor. Example , if I want to change the file name to 04 to 05, just type at any cell in excel and the query will change
2) I have few file to merge and append, how I can change the source file at 1 time for all the file. Example, I want to recon for month of Apr 2016, so the source file should change the file only for april 2016.
Thank you