Rename Files

[SDSU_Jim]

I have created a macro that opens a *.TXT file, reformats it and saves a *.CSV file. I need to delete the original *.txt file and rename the *.CSV file to the "TXT name. I can delete the "txt" file with the "Kill" command, because I can use the wildcard "*" in the Kill command. I need to use the wildcard because the names of the file will vary. But I can't use the wildcard in the "Filecopy" command. I was looking to "Kill" the "Txt" file, "filecopy" the "CSV" file to a "txt" file then "kill" the "CSV" file. Since I can't use a wildcard and the name will be unknown until the operation takes place, anyone have any ideas??

THANKS

 

[SDSU_Jim]

OK, I got Internet Explorer to work!! Now if someone knows how to do this...

 

[Joe Was]

Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(C:\myFiles\myOldFile.csv)

f.Name = "yourNewName"

 

[SDSU_Jim]

Set fs = CreateObject("Scripting.FileSystemObject")
Set f = fs.GetFile(C:\myFiles\myOldFile.csv)

f.Name = "yourNewName"

But can you use a wildcard so "Unknown.CSV" gets renamed to "Unknown.TXT"??

The location the files are being uploaded to requires CSV files to have the "TXT" extention. I'm trying to eliminate someone having to do this by hand.

If this can't be done is there a way to save in the CSV format, but force the "TXT" extension??

 

[SDSU_Jim]

I know it's been a while, but I thought I'd follow up. My solution was to create a batch file ".bat" that could use a wild card and "shell" it within my macro. Anyway, thanks to those who took the time to help.[/i]