Is there a general tutorial on the web for this kind of thing? I couldn't really find much.



All I want to do is "Kill" a specific file on a location in sharepoint, use cmdtransferspreadsheets to post data in a new excelsheet, and then save this file on the same location as the killed file on sharepoint.


I couldn't even get "Kill" to work. The code I use is "Kill 'sharepoint URL/file.xls' "

I also can't export queries to the file in mind, Status report Template.XLS

Code:
DoCmd.TransferSpreadsheet acExport, , "Query", "https://sharepointsite/Status Report Template.xls", False, "TabName"
Thanks