How to open via Macro a Daily Automated file with a random number in the name
Posted on 2013-10-16
Hi, I am trying to import into an Excel file on a daily basis a text dump called "Daily OBS REC_YYYYMMDD_(Random Number)" via Macro but it ends with a random number so I have to manually rename the file every day by stripping the name of the random number. Is there a way I can tweak my Macro so I can import the file every day without having manually rename it? Using the Instr function, for example?