When I create an HTML from my Excel sheet (which contains a chart as well as other text, etc.) using the publishObjects.Add method, it creates the .htm file in the directory I specified, but it puts the chart in a .gif file in a separate sub-directory (called xxxfiles; where xxx is the name of my htm file). The .htm file code points to that sub-directory. I was wondering is there was a way to have the chart file go in the same directory as the .htm file and have the html code point to that directory.
Thanks
Thanks