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 Moving a file within a macro

See this page for example code
http://www.rondebruin.nl/folder.htm

--

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


"OlieH" wrote in message ...
After saving a file to a new location, I want to delete the file from the
previous location. Since that file contains the macro that is executing,
permission is denied. Another approach might be to save the file in the
original folder and then move it the proper folder. I am unable to find the
code to do that.

All help is most appreciated.