Thread: Importing spreadsheet to Sharepoint 2010

Having trouble importing a spreadsheet to Sharepoint 2010. First was getting the error "method 'Post' of object 'IOWSPostData' Failed ". I followed other instructions and solved that by going into EXPOOTWS.xla file and changing the following section of the file

from

Sub Initialize(List, Title, URL, QuickLaunch)
    strQuickLaunch = QuickLaunch
    aTarget(iPublishURL) = URL
    aTarget(iPublishListName) = List
    aTarget(iPublishListDesc) = Title
    lVer = -1 ' can't tell STS server version
    If Val(Application.Version) >= 12 Then
    lVer = Application.SharePointVersion(URL)
    End If
End Sub

to

Sub Initialize(List, Title, URL, QuickLaunch)
    strQuickLaunch = QuickLaunch
    aTarget(iPublishURL) = URL
    aTarget(iPublishListName) = List
    aTarget(iPublishListDesc) = Title
    lVer = -1 ' can't tell STS server version
    If Val(Application.Version) >= 12 Then
   '    lVer = Application.SharePointVersion(URL)
    lVer = 3
    End If
End Sub

(edited sections are Bolded/Underlined)

That allowed most other people to import. But when I now try to import I get the error "Object variable or with block variable not set sharepoint import" in the Excel program itself.

I'd appreciate any ideas that anyone has. Thank you