File Search Using Wildcard and User Input

**CJPHX** · 05-19-2010, 04:34 PM

Good Afternoon all,
I am attmepting to search for a file based on user input and wildcards. The file I am looking for is saved every 30 minutes with its name based on date and time.

Example: DateTimecampdata.csv

The last part of the file name campdata.csv is always the same. I want the file that is run at the end of the day, after 22:00. It is always ran within the same 15 minute window. So the file name will always be Date then whatever time it ran, then campdata.csv. I would like to be able to have the user search by whatever Date they need. I would like an Application.InputBox to pop asking them to enter the date then it would search the directory for that day's EoD file. I tried this code and it would not return any results:

Please Login or Register  to view this content.

Any help would be greatly appreciated.

**snb** · 05-19-2010, 05:08 PM

Please Login or Register  to view this content.

change the red formatrule to what has been used in the filenames.

**shg** · 05-19-2010, 05:17 PM

Welome to the forum, CJPHX.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

**CJPHX** · 05-19-2010, 05:18 PM

Sorry, but I don't understand what you mean by change the red formatrule. The file name right now is saved as "20100518 2233 campdata.csv" with the spaces in the file name.

Sorry about that SHG.

**Domski** · 05-19-2010, 05:22 PM

You might want to look at avoiding filesearch as it was dropped in 2007.

There a couple of workarounds mentioned here: http://www.mrexcel.com/forum/showthread.php?t=268046

Dom

**CJPHX** · 05-19-2010, 05:26 PM

Originally Posted by Domski

You might want to look at avoiding filesearch as it was dropped in 2007.
Dom

I did look into this Dom, however my company still uses 2003 and from what I was told has no plans of upgrading in the near future. Thank you for the suggestion.

**snb** · 05-19-2010, 06:08 PM

colors can't be used between code-tags on this forum.
Neverthesless.
My earlier code must do the trick, based on the latest information you gave.

Please Login or Register  to view this content.

**CJPHX** · 05-19-2010, 08:38 PM

First SNB, I want to say thank you for trying to help me with this. Second, I am new to VBA as I jsut started coding in excel this last week. I have left work for the day so I am unsure of the excat error, but I still get a line error and when I debug it, it goes to the .FileName line.

Please Login or Register  to view this content.

The only difference in my code is the actual .LookIn line contains the full file directory.

**Domski** · 05-20-2010, 04:52 AM

This works for me:

Please Login or Register  to view this content.

Dom

**snb** · 05-20-2010, 05:24 AM

Take care there is a space between ) en &.

**CJPHX** · 05-20-2010, 09:09 AM

Thanks for the help, however I am getting a Runtime '6' Overflow error on the ".FileName" line.

This is the exact copy of the code as I have it now in the macro. There are hundreds of files in this directory and there will be approximately 20-30 where the file name starts with YYYYMMDD for each day the only changing variable is the time. It almost seems like is returnign too many options which shouldnt be the case as there would be only one file with the date and time stamp.

Please Login or Register  to view this content.

**Domski** · 05-20-2010, 09:58 AM

How are you entering the date?

You're using Format to convert a date to the text format yyyymmdd so it must be entered as a real date in the first place like 05/18/2010. If you just want to enter the value as 20100518 then you can just use:

Please Login or Register  to view this content.

Dom

**CJPHX** · 05-20-2010, 10:05 AM

THANK YOU. Dom as I said I am new to VBA and I didn't even realize that the Format option changed the date to text. I had been entering it as 20100518. However, now that I switched it to the date it
works perfectly. I can not thank you enough.

File Search Using Wildcard and User Input

LinkBack

Thread Tools

Rate This Thread

Display

File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Re: File Search Using Wildcard and User Input

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions