|
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
> Do I have to select the whole worksheet
No
> does UsedRange know what is used?
Yes
> .movefile does not seem to work
Works:
Option Explicit
Sub Macro1()
Dim fso As New FileSystemObject
If fso.FileExists("c:junk.doc") Then
fso.MoveFile "c:junk.doc", "c:junk"
Else
MsgBox "No junk"
End If
End Sub
Don’t forget to use Tools | References to add MS Scripting Runtime. Have a great day! –Sam
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
