View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default macro save as delete original file

Why not use Name

http://www.rondebruin.nl/folder.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pam M" wrote in message ...
I would like to write a macro to save a file to a different folder location,
same filename, and then delete the file from the original location. I tried
record macro and went to file-open to do the delete file part (right click on
file and delete), but the file didn't delete. In visual basic, the command
recorded was ChDir and the filename. Any help would be appreciated. Pam