Rename a .dat file

D

DavidES

I need to rename a .dat file to a .csv file so I can work with it in Access
2003. The following code does not work... any ideas what I should do?


Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)

Function ChangeFile()
x = Shell("ren C:\myfolder\weborders.dat weborders.csv")
Sleep (8000)

End Function
 
K

Ken Snell \(MVP\)

It's much simpler:

Name "C:\myfolder\weborders.dat" As "C:\myfolder\weborders.csv"
 
Top