subject: renaming a file w/ wildcards in name

dgr7 · January 25th, 2007, 12:36 PM

hello,
I have this code that I'm trying to use but is not working, so I'm posting on here to see if someone can help me with how to fix the error. What the code is trying to do is to look in the subdirectory
D:\B D client data\H T\NewBusinessfor a file that will have (a string of numbers) + (.txt) as it's file name and rename that file to HT012507.txt.
There is another file in the same directory named HT.txt that needs to be left alone and not renamed. These are the only two .txt files in the subdirectory.

Visual Basic is giving me the
Run-time error '52':
Bad file name or number
when I try to run the code, and stops on the Name line, so I'm assuming the SourceFile line is the problem.

Can anyone help me with what the syntax of the below code so it will work properly?

thanks in advance,
david

Code:

Dim SourceFile, DestinationFile As String

 SourceFile = "D:\B D client data\H T\NewBusiness\[1-9]*.txt"
 DestinationFile = "D:\B D client data\H T\NewBusiness\HT" & Format(Date, "mmddyy") & ".txt"
    Name SourceFile As DestinationFile

marcostraf · January 25th, 2007, 01:09 PM

you cannot use wildchar in the Name statement.
did you try using Shell?

Shell "cmd /c rename " & srcFile & " " & dstFile, vbHide

Marco

"There are two ways to write error-free programs. Only the third one works."
Unknown

BbCasey · February 2nd, 2007, 03:21 PM

David, Marco is right: you can't do it that way. You can probably do this with Regular Expressions and either an array or a FileListBox. I haven't done much with regular expressions but there are some good tutorials out there that should get you started. Unfortunately it's not really a topic that can be adequately covered in a forum reply.

Always take into account what nobody would ever in a million years do, because someone will.