I’m having major problems deleting files from Sharepoint Library/directories using VBA (in Excel). I’ve tried both (VBA) Kill and fso.deletefile and nothing seems to work. In fact having problems with fso.FileExist and other fso methods (results act like file does not exist). I have no problems writing a file to the Sharepoint libraries or any associated actions using VBA (i.e. Workbooks().SaveAs, etc.)
Is there something else involved like using the Checkin/checkout functionality that I have missed? I tried to do an extensive search on the web for the past several days but am coming up with virtually nothing to cover deleting files.
Does anyone have ANY idea how to properly do this?? I need to use this for a current project and any immediate help or guidance is VERY MUCH APPRECIATED.
Thanks (a Million ahead of time),
Ken