Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving Worksheets From One File to Another dcapps Excel Discussion (Misc queries) 1 August 4th 09 05:33 PM
Moving file locations Derek Links and Linking in Excel 1 August 9th 06 12:45 AM
moving a file to another folder Chris Excel Programming 3 June 26th 06 01:57 PM
Moving a file using excel vba Greg[_20_] Excel Programming 6 April 13th 06 06:29 PM
Moving a file Todd Huttenstine[_2_] Excel Programming 6 December 23rd 03 05:23 PM


All times are GMT +1. The time now is 04:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"