ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving a file within a macro (https://www.excelbanter.com/excel-programming/384195-moving-file-within-macro.html)

OlieH

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


Ron de Bruin

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.



All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com