ThisWorkbook.PublishObjects.Add runtime error 1004

I

itarnak

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Publishing a Range 1
How do I publish a Excel chart using vba macro? 1
Runtime error 1004 when trying to insert formula in cells 11
PublishObject.Publish Error 1
Runtime error 1004 3
runtime error 1004 1
Runtime error 1004 write data to a cell 9
GoalSeek 1004 Error 5

Top