I have created an Excel file that allows a user to use it to enter and capture data. When the user has completed entries, the VBA code then sends the PDF image of the worksheet to a SharePoint library (no problem here, it works great!). It also posts the data entries from the Excel sheet into a SharePoint list (using 'INSERT INTO' no problem here either, it works great!). Finally, the VBA is supposed to update the SharePoint library item (just posted) with relevant/desired entries. The run-time error '-2147217900 (80040e14)': code is 'Syntax error in UPDATE statement'. Here (below) is the relevant code (redacted). What am I missing?


Please Login or Register  to view this content.