I have the following code which should have deleted
And today when I opened the file it came up with a runtime error 1004 ChangeFileAccess Denied. (not great as I sent this to loads of people hoping it would delete today! lol) Does this formula need the read only line in it and is this the simplest code to just make the file delete itself if todays date is beyond the one stated?
Please Login or Register to view this content.
Anyway, your help would be much appreciated.
Thanks in Advance,
Alex
If I remember correctly you can't use Kill on an open file
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If the file is opened read-only then the code will raise an error. So,
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
BTW, if the file itself is read-only (as opposed to being opened read-only), you need to change that attribute before the Kill statement.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks