publish one (and only one) html file?

[Mark]

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)

 

[Dave]

no. html files can not contain graphics since they are basically plain
text, so by publishing a chart it has to create a gif for the graphic and
call it from the html. you might be able to tell it to put them both in the
same folder, but there will always be two files. now maybe you don't need
the html and just want to upload the gif file, i have done that when i
needed to use the graphics in a report but didn't care about the html
wrapper.

 

[Mark]

Followup then: does anyone have an example of how to properly use the
DefaultWebOptions.OrganizeInFolder = False property? I may be able to do
what I need if I can get it to work, but so far I haven't.

Neither the simple "Application.DefaultWebOptions.OrganizeInFolder = False"
or

Set objExcel = CreateObject("Excel.Application")

objExcel.DefaultWebOptions.OrganizeInFolder = False

objExcel.quit

has any impact, am still getting the subfolder created....

 

[Mark]

'ActiveWorkbook.WebOptions.OrganizeInFolder = False' worked, but didn't solve
my need.

I can't beleive there's not a way to produce ONE output file, with the image
embedded.

 

[Dave]

not as html, by definition. try saving it as a word doc, rtf, or pdf, those
can contain embedded images.

 

[Mark]

Any example, for the .rtf ? What objects, methods, etc?