Dear All,
I have a folder containing more than 250 files. Each file is identified by the name of a country. I would like to save in a macro the list of those files, since I want to loop over them later.
I tried:
But the result is not as expected (below is just an example)
I would like to get only the names (not the extension of the files) correctly spaced. Do you have any hint?
Thanks in advance
Dario
I have a folder containing more than 250 files. Each file is identified by the name of a country. I would like to save in a macro the list of those files, since I want to loop over them later.
I tried:
Code:
local f_names: dir "C:\Users\dario\Downloads\wetransfer_bilateral_2023-11-23_1545\bilateral" files "*"
Code:
display `f_names' afghanistan.xlsxalbania.xlsxalgeria.xlsxamerican samoa.xlsxandorra.xlsxangola.xlsxanguilla.xlsxantigua and barbuda.xlsxargentina.xlsxarmenia.xlsxaruba.xlsxaustralia.xlsxaustria.xlsxazerbaijan.xlsxbahamas.xlsxbahrain.xlsxbangladesh.xlsxbarbados.xlsxbelarus.xlsxbelgium.xlsxbelize.xlsxbenin.xlsxbermuda.xlsxbhutan.xlsxbolivia, plurinational state of.xlsxbonaire, saint eustatius and saba.xlsxbosnia and herzegovina.xlsxbotswana.xlsxbouvet island.xlsxbrazil.xlsxbritish indian ocean territory.xlsxbritish virgin islands.xlsxbrunei darussalam.xlsxbulgaria.xlsxburkina faso.xlsxburundi.xlsxcabo verde.xlsxcambodia.xlsxcameroon.xlsxcanada.xlsxcanary islands.xlsxcaroline islands.xlsxcayman islands.xlsx
Thanks in advance
Dario
Comment