Hello I am extracting data from files that change names every day. I was hoping to find some kind of macro code that could extract, rather, a file that contained a general name in the string that is in a specific folder/path. For example
S:\Projects\STV_Plus\2.2.2.6 KPI\CC CINCO KPI YYmmdd
here we have a file that changes dates every so often (not at a consistent level that is) I want to be able to say
path = S:\Projects\STV_Plus\2.2.2.6 KPI\
find and open the file that contains the words "CC CINCO KPI" within the string
I was also hoping to find out how to activate the window when needed
for example:
Windows(Filename). Activate
where Filename =
path = S:\Projects\STV_Plus\2.2.2.6 KPI\
find and open the file that contains the words "CC CINCO KPI" within the string
S:\Projects\STV_Plus\2.2.2.6 KPI\CC CINCO KPI YYmmdd
here we have a file that changes dates every so often (not at a consistent level that is) I want to be able to say
path = S:\Projects\STV_Plus\2.2.2.6 KPI\
find and open the file that contains the words "CC CINCO KPI" within the string
I was also hoping to find out how to activate the window when needed
for example:
Windows(Filename). Activate
where Filename =
path = S:\Projects\STV_Plus\2.2.2.6 KPI\
find and open the file that contains the words "CC CINCO KPI" within the string