How to rename a xls file

  • Thread starter Thread starter Mei Qin
  • Start date Start date
M

Mei Qin

Hello,

I use the command DoCmd.TransferSpreadsheeta to create a
xls file in the code. I need to rename it, because I need
to add the timestamp at the end of the process. I tried
the command Docmd.Rename. But since xls file is not in the
list of its objecttype, I got the error. What is the
right way to rename a xls file.

Thanks for any help!

Mei
 
Back
Top