66 votes9 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Anonymous supported this idea ·
57 votes11 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Thank you for taking your time to suggest and vote for this idea. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.
An error occurred while saving the commentAnonymous commented
Hi All, These are all very interesting comments. My problem is that I have a set directory folder in which I drop a new file on a regular basis. This directory only ever contains the latest file. My issue is the file is always named differently. Does anyone know a way of setting the PQ Source to equal a fixed location e.g. C:\Temp\My Folder and "=Excel.CurrentWorkbook()" or "*.xls" I don't want to have to join the file as a new table each time nor do I want to rename the file. Any help much appreciated.