Rename File in VBA for Excel

[Ekim]

hello,

I have difficulties at renaming a single file in VBA for Excel.
Assuming I want to rename the file "elbi_umsaetze_20031112160130.csv" to
"elbi_umsaetze.csv":

I've just tried this:

Dim fso
Set fso = CreateObject("Scripting.FileSystemObject")

fso.CopyFile "c:\Elba\elbi_umsaetze_*.csv", "c:\Elba\elbi_umsaetze.csv",
True

---------------------------------

The problem about it:

It is not possible to use wildcards as source (here "elbi_umsaetze_*.csv")
and rename it to a single name (here "elbi_umsaetze.csv").
On the one hand it seems logical to me that you cannot rename one or more
files into one single name.
But in this special case there is always only one file in this folder (for
example elbi_umsaetze_20031112160130.csv) to rename. I just don't know it's
exact name (because the end of the name is a combination of date as you may
have recognized), so I have to use the wildcard anyway.
----------------------------------

Can someone offer me a solution therefore?


Thx in advance,

ekim

 

[Chirag]

You can use Dir("c:\Elba\elbi_umsaetze_*.csv") to get the expanded file
name.

- Chirag

Shortcut Manager - Assign keyboard shortcuts to menu items and macros
http://officeone.mvps.org/ppsctmgr/ppsctmgr.html