Hi,
    I have created an excel object variable(objExcel) using CreateObject("Excel.Application"). I tried to published an excel file using this object which is having a pivot table, to a .htm file. When I am trying to execute the statment
objExcel.Application.ActiveWorkbook.PublishObjects .Add(xlSourcePivotTable, htmFile, "CI", "CI", xlHtmlList).Publish , it throws an error

Run-time error '1004':
Application-defined or object-defined error.

However, when I gave excel object reference and declared the object variable then it worked fine.

Can anybody provide solution for this problem.

Thanks & Regards,
Gogoi

Gogoi,

It sounds like you came up with the solution. Has anyone else experienced this? If so, please post any resolutions you have come across.

XUMUSKIEFAN
Wrox Moderator

I have the same problem, but I didn't follow what the solution is.
What do you mean "gave excel obect reference and declared the object variable"?
Do you mean you declared an object for the workbook, or the publishobject?