Hi,
I am trying to modify a macro that will loop round looking for worksheets that begin with 'mrp_', there can be any number with names like mrp_3553.csv,mrp_148.csv etc..
When I find one I need to open it then end the loop when I have read all the csv files that match. Is there a 'LIKE' find in VB.
Appreciate any help.
Do you mean worksheets?
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
This how you can use dir to loop through the files in a directory:
Please Login or Register to view this content.
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks