ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ThisWorkbook.PublishObjects.Add runtime error 1004 (https://www.excelbanter.com/excel-programming/343861-thisworkbook-publishobjects-add-runtime-error-1004-a.html)

itarnak[_12_]

ThisWorkbook.PublishObjects.Add runtime error 1004
 

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



All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com