View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default publish one (and only one) html file?

I have a problem. When using the publish method to produce output, as below,
the resulting file references a subfolder with the image itself. While this
is elegant and all, I unfortunately need my user to, after this creation,
upload ONE file into a collaboration app.

So the question is, can there not be a way to produce one (and only one)
html file?

ActiveWorkbook.PublishObjects.Add(xlSourceChart, strFilename, "Chart1",
"", _
xlHtmlStatic, "", strTitle).Publish (True)