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...

No comments:

Jeffrey Ting Jeffrey Ting on Facebook Jeffrey Ting on Spock Jeffrey Ting on Plaxo Jeffrey Ting on Spoke Jeffrey Ting on LinkedIn