VBA problems with excel embedded in IE

[Per Winkvist]

Hello,

I'm having problems with excel when its running within Internet Explorer.
Both these functions fails for me.

Public Sub Test2()
ActiveWorkbook.SaveCopyAs "c:\testwb.xls"
End Sub

=> Run-time error 1004: Method 'SaveCopyAs' of object '_Workbook' failed

Then I tried to use PublishObjects instead but that fails as well:

Public Sub Test1()
Set po = ActiveWorkbook.PublishObjects.Add(xlSourceSheet,
"c:\test.html", ActiveSheet.Name, "", xlHtmlStatic, "", "title")

po.AutoRepublish = False
po.Publish (True)
End Sub

=> Method 'Publish' of object 'PublishObject' failed. The error code is:
1004

Are there limitations on what can called when excel is run inside IE?

Thanks,
Per

 

[dbahooker]

so you click on an XLS url; and it opens the 'xls in ie'

right?

you're not talking about office web components are you??