Rename a .dat file

[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

 

[Ken Snell \(MVP\)]

It's much simpler:

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