2147417851 ошибка на сервере

Standard Error -2147417851
The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))

Standard Error
Number: -2147467261
Source: interop.Excel
Description: Attempted to read or write protected memory. This
is often an indication that other memory is corrupt.
at Excel._Worksheet.set_EnableCalculation(Boolean RHS)
at Cognos.Controller.Reports.XlLinkLayout.RecalcXL(Int32 lVersion,
Boolean bActiveSheetOnly)

Answers

• I have now fixed the issue whereby I couldn’t logon on to SharedServices1 Admin (http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/37045920-2bd3-4804-b71f-a55d3d36b97f ).

  This pull method is still giving me an issue.  To recap:

     1. I click on «Site Actions» and select «Create»
     2. Under «Custom Lists», I select «Import Spreadsheet» (.xlsx
     3. I type the Name, Description and Select a MS Excel 2007 spreadsheet (
     4. As soon as I click «Import», I receive an error: «An unexpected error has occurred. (-2147417851)»

  The import site has been added as a trusted site in IE8 and  lVer =2  in the Sub Initialize(List, Title, URL, QuickLaunch) in EXPTOOWS.XLA So other than trying to attach a debugger to the EXPTOOWS.XLA I am at a bit of a loss as how this issue can be solved The Push method when publishing to the main site (server:port) did work.  However you can’t dynamically select a range of rows during the import so this is not really my preferred option.

  • Edited by

    Tuesday, July 21, 2009 8:18 AM

  • Marked as answer by
    Xue-Mei Chang-MSFTModerator
    Friday, July 24, 2009 6:46 AM

Answers

• I have now fixed the issue whereby I couldn’t logon on to SharedServices1 Admin (http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/37045920-2bd3-4804-b71f-a55d3d36b97f ).

  This pull method is still giving me an issue.  To recap:

     1. I click on «Site Actions» and select «Create»
     2. Under «Custom Lists», I select «Import Spreadsheet» (.xlsx
     3. I type the Name, Description and Select a MS Excel 2007 spreadsheet (
     4. As soon as I click «Import», I receive an error: «An unexpected error has occurred. (-2147417851)»

  The import site has been added as a trusted site in IE8 and  lVer =2  in the Sub Initialize(List, Title, URL, QuickLaunch) in EXPTOOWS.XLA So other than trying to attach a debugger to the EXPTOOWS.XLA I am at a bit of a loss as how this issue can be solved The Push method when publishing to the main site (server:port) did work.  However you can’t dynamically select a range of rows during the import so this is not really my preferred option.

  • Edited by

    Tuesday, July 21, 2009 8:18 AM

  • Marked as answer by
    Xue-Mei Chang-MSFTModerator
    Friday, July 24, 2009 6:46 AM

Answers

• What version of office do you have installed on your PC?

  You can specify the version of excel you are creating the object.

  From :

  Set WordObj = CreateObject(«Word.Application»)

  to :

  Set WordObj = CreateObject(«Word.Application.12»)

  You also may want to try using the following

  WordObj.ActiveDocument.SaveAs FileName:=FullDocName, FileFormat:=acFileFormatAccess2007

  Check the menu in access vba Tools — References Microsoft Word XX.X object Library.  You may have to browse for a newer version of the object library.  what sometimes hapPens if the macro was developed on a PC with 2003 the reference may be
  pointing to the object library 11.0 while you need 12.0.

  Make sure the version  of the object library is compatible with Word 2007.  Version 12 is office 2007.  The create object will automatically use the defualt version of office that is installed on your PC.  If you have  office 2010
  installed you may need to specify a differnt version.

  Errors like -2147417851 (80010105) are usually caused by not having the priveledge to open the file.  Make sure you can open the file by double clicking on the file and opening.  I would aslo suspect you would get the error if your configuration
  (like the reference) doesn’t support office 2007.

  ---

  jdweng

  • Marked as answer by

    Friday, February 25, 2011 9:50 AM

• Wrong approach. You mix the application object with document object. Try this:

    Dim appWord As New Word.Application
    Dim objWord As Word.Document

    Set objWord = appWord.Documents.Add(GetTemplatePath(strDocPath))

    appWord.visible = True
    appWord.Activate
    appWord.ShowMe
    appWord.WindowState = wdWindowStateMaximize

    appWord.ActiveDocument.SaveAs FileName:=FullDocName, FileFormat:=12

  Greg

  • Marked as answer by
    Bruce Song
    Friday, February 25, 2011 9:50 AM

• Hi Richard,

  it’s interesting because this cide works fine for me with Office 2007:

   Set wordobj = CreateObject("Word.Application")
   wordobj.Visible = True
   wordobj.Activate
   wordobj.ShowMe
   wordobj.WindowState = wdWindowStateMaximize
   wordobj.Documents.Add "********Desktoptest.docx"
   wordobj.ActiveDocument.SaveAs FileName:="********Desktoptest1", FileFormat:=12
   wordobj.Quit
   Set wordobj = Nothing
  

  But I’ve been facinf the situation when Excel automation hadn’t worked until setting the whole object «stairway».

  Suggestions:

  — Are you sure that exactly the last line causes an error?

  — Does FullDocName have an extension part?

  — Do you have more than one version of Office installed on this workstation?

  ---

  Andrey V Artemyev | Saint-Petersburg, Russia

  • Marked as answer by
    Bruce Song
    Friday, February 25, 2011 9:50 AM

Ответы

• I have now fixed the issue whereby I couldn’t logon on to SharedServices1 Admin (http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/37045920-2bd3-4804-b71f-a55d3d36b97f ).

  This pull method is still giving me an issue.  To recap:

     1. I click on «Site Actions» and select «Create»
     2. Under «Custom Lists», I select «Import Spreadsheet» (.xlsx
     3. I type the Name, Description and Select a MS Excel 2007 spreadsheet (
     4. As soon as I click «Import», I receive an error: «An unexpected error has occurred. (-2147417851)»

  The import site has been added as a trusted site in IE8 and  lVer =2  in the Sub Initialize(List, Title, URL, QuickLaunch) in EXPTOOWS.XLA So other than trying to attach a debugger to the EXPTOOWS.XLA I am at a bit of a loss as how this issue can be solved The Push method when publishing to the main site (server:port) did work.  However you can’t dynamically select a range of rows during the import so this is not really my preferred option.

  • Изменено

    21 июля 2009 г. 8:18

  • Помечено в качестве ответа
    Xue-Mei Chang-MSFTModerator
    24 июля 2009 г. 6:46