LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 735
Default Kill Delayed?

In my application, by design I move files from one folder to another.

I open the file, makes some changes to cells and save the file to another
folder, finally use Kill to remove it from the source folder. The new file
is then closed.

Most of the time this works, on the corporate network I occasionally get a
failure, where the new file is created but the old file is not killed.
Users have the right access rights to the server.

Q1. Why might this happen?
Q2. Can I apply a delay or some other action to prevent, warn or otherwise
fix this.

Sample of the code sequence in VBA code - as follows

' store old file name
sOldFile = ThisWorkbook.FullName

' file saved in different place and name
Application.DisplayAlerts = False
ThisWorkbook.SaveAs sPath & sFile
Application.DisplayAlerts=True

' remove old file
Kill sOldFile

' close the new file
ThisWorkbook.Close savechanges:=False

--

Regards,
Nigel




 
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
How many delayed per week Kriss Excel Discussion (Misc queries) 4 November 18th 08 02:49 PM
Delayed Update? Ray Charts and Charting in Excel 1 September 26th 06 05:57 PM
Delayed reactions Not too genius! Excel Discussion (Misc queries) 1 September 13th 06 05:36 AM
Delayed reactions Not too genius! Excel Discussion (Misc queries) 1 September 12th 06 10:39 PM
Msgbox delayed using AFTERUPDATE No spam please Excel Programming 0 February 11th 05 10:52 PM


All times are GMT +1. The time now is 01:01 AM.

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"