right now my company is saving our daily reports in a folder and it's updated daily with new reports added in as new files.
so if i am trying to grab every files in this folder automatically,how do i do it?
Your files must have the same structure, in this case you can use a loop:
path = '..\..\MyDir\*.*';for Each File in FileList (path)margin_tmp:LOAD
....FROM$(File) (ooxml, embedded labels, table is [MySheet]);NEXT
sweet!!!! THANK YOU SO MUCH Alexandros!!!
Retrieving data ...