Problem with ActiveWorkbook.PublishObjects.Add - html file being generated without code

Hi,

I have been using this forum for a lot of my issues and the solutions suggested here have almost always solved my problems. But there is this one issue I am facing and can't seem to find the answer here. So here goes:

I am using the following code to covert a variable range to an html.

Please Login or Register  to view this content.

This code works fine and it gives me the right range of values I want. I then figured that I don't have to convert to an html so I deleted this piece of code. Now, the problem I am facing is that even after deleting this piece of code, an html file is being generated at the location above. I don't want the html. I am sure there is a small fix to this somewhere but I am clueless as to why this is happening even after deleting the code.

Any pointers?

I can't see how an HTML file could be generated if you've deleted the code that does that.

Is this all the code?

Have you tried stepping through whatever code you have with F8?

Please check the following page for the solution

http://office.microsoft.com/en-us/ex..._autorepublish

especially the bit about AutoRepublish

The code you ran earlier has just activated the publish feature for the workbook/worksheet and the AutoRepublish will ensure that the html keeps on being published. The code is no longer needed for that. See the link to the web page provided.

You are very welcome!