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?
Regards,
Harald
