Excel 2007 migration to SharePoint List
 

All,
I am having a difficult time updating my Sharepoint List from an existing
Excel spreadsheet. I have performed several things that I thought might
help, but I continue to get a run time error.
Things I tried:
1. Download the Add-in for excel that will allow for publishing and syncing
2. Alter a "module" in the VBA script to see the GUID's from the URL and
LIST name of the SharePoint site.

Nothing. Any suggestions?