VBA: Excel 2010 problems with PublishObjects RRS feed

  • Frage

  • Hello,

    I have a strange problem with PublishObjects. The code is in vba, like this:

            With ActiveWorkbook.PublishObjects.Add(xlSourceSheet, _
                "https://intranet........../Test001.htm", "Testfall", xlHtmlStatic)
                If Not ExpError_Teamroom Then .Title = testname
                If Not ExpError_Teamroom Then .Publish (True)
                End If
            End With

    I used the same code in excel 2003 and 2007, and there it is working all the time. In excel 2010 it is working only, when I set a breakpoint into the code,

    so every dataset I push the F8 to continue. Without this breakpoint it starts the logon-dialog (web-server), but after 3 sets it stops, this mean

    the sandglass is waiting for a long time, until I cancel with the task-manager.

    Does anybody have an idea?



    Montag, 4. Februar 2013 09:49