Thursday, October 4, 2007

Import of Excel 2007 sheet into Sharepoint 3 : Method 'Post' of object 'IOWSPostData' failed

  1. Open C:\Program Files\Microsoft Office\Office12\1033\EXPTOOWS.XLA in Excel.
  2. ALT-F11 to open Visual Basic for Applications.
  3. Right-click publishForm and "View Code".
  4. Find the method Sub Initialize(List, Title, URL, QuickLaunch)
  5. Change lVer = Application.SharePointVersion(URL) to lVer = 2 . For some reason, Sharepoint appears to return "0".
  6. Save. This step is important...
  7. Try again. Equally important...
Jeffrey Ting Jeffrey Ting on Facebook Jeffrey Ting on Spock Jeffrey Ting on Plaxo Jeffrey Ting on Spoke Jeffrey Ting on LinkedIn