I'm trying to create a quick script that asks the user for the input file name, then it in the background finds the associated OpenOffice lock file and deletes it.
(example file names involved: .~lock.Cleaning Checklists.xls#
and Cleaning Checklist.xls)
Through my testing of the code and echoing it back to the screen, it seems to work pretty well, except that that it errors out saying it cannot find the file I actually need it to find. I suspect the issue is it can't handle a file beginning with a period.
Any ideas on how to do this?
'This script will ask for a users input, then delete the lock file
Const DeleteReadOnly = True
strFile = InputBox( "Enter the file name that is locked" )
WScript.Echo "You entered: " & strFile
Set joinedFile = CreateObject("Scripting.FileSystemObject")
joinedFile = ".~lock." & strFile & ".xls#"
WScript.Echo joinedFile
Set obj = CreateObject("Scripting.FileSystemObject")
obj.DeleteFile(".~lock." & strFile & ".xls#"), DeleteReadOnly
It also complains about not finding the file if I try to use joinedFile:
obj.DeleteFile("joinedFile")