Hi,

When using ThisWorkbook.PublishObjects.Add (SourceType:=xlSourceSheet,
Filename:=sFileName, Sheet:=publicationSheetName,
HtmlType:=xlHtmlStatic).


i have a runtime error 1004. The err.Number contains value "91".

This method was working fine yesterday i don't know why it does not
work any more....


An idea?

Regards,
iTarnak


--
itarnak
------------------------------------------------------------------------
itarnak's Profile: http://www.excelforum.com/member.php...o&userid=27865
View this thread: http://www.excelforum.com/showthread...hreadid=479390