Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search filename containing words
Sam,
Take a look at the Dir method in VBA help. It allows selecting partial names. Although how you will manage if there are two, I do not know. -- HTH RP (remove nothere from the email address if mailing direct) "Sam" wrote in message ... Here is the thing. I have file that has to be formatted. The file is updated occasionally because its companys pricelist. So, the name of the file will change. The fact is that the words "Price list" is always in the name. I want to make a search that finds the file and changes the name only to be a "pricelist". What is the code for this? -- -Sam |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search of words | Excel Discussion (Misc queries) | |||
filename search and extract into a cell | Excel Discussion (Misc queries) | |||
Search for specific words | Excel Worksheet Functions | |||
Search for multiple words | Excel Discussion (Misc queries) | |||
Filename search using Office 97 with Windows 2000 | Excel Programming |