I am new to macros and programming in general.
I have a question/problem which i believe should be easy to fix, here it goes.
I have a macro written to find an .xls file in a certain directory.
the .xls file has a numerical value at the end which will change.
I am looking for a simple way to be able to get this file just by searching the content before the numerical value.
Ex:
ThePath = "C:\Temp\test\original_001.xls"
I want to be able to search "C:\Temp\test\orignal" and leave out the 001 part. (it will always be an .xls file)
Can this be done. I've tried looking up wildcards * but i dont think they exist in VB.
can someone help me.
I have a question/problem which i believe should be easy to fix, here it goes.
I have a macro written to find an .xls file in a certain directory.
the .xls file has a numerical value at the end which will change.
I am looking for a simple way to be able to get this file just by searching the content before the numerical value.
Ex:
ThePath = "C:\Temp\test\original_001.xls"
I want to be able to search "C:\Temp\test\orignal" and leave out the 001 part. (it will always be an .xls file)
Can this be done. I've tried looking up wildcards * but i dont think they exist in VB.
can someone help me.