change excel file name from access

  • Thread starter Thread starter Daniel M
  • Start date Start date
D

Daniel M

I want to open an excel file with access, run a macro on it, import it in,
and then go back and rename the file. ie: open "to import.xls", process it
and import it and rename the file as "imported.xls" I do not want to keep the
original file! just the new renamed file. how can i do this?

also if i decide i want to change the directory for the renamed file, what
would be changed? Thanks.
 
Alex, sorry i wasnt clear. i was asking about the renaming of a file but
after your first response i checked the help for the name property and found
what i needed. So you did get me to the right answer. Thanks!
 
Back
Top