You may also discover if you are trying to write to a web server directly, that you need to use some form of PATH/GPATH/URL= options:
For example, let's say that your web server is
www.wombat.com and your
reports are stored in the reptdir directory:
www.wombat.com/reptdir/
You may want to make a "mirror" directory structure on your local machine and do this:
[pre]
ods msoffice2k path='c:\reptdir' (url=none)
gpath='c:\reptdir' (url=none)
file="temp.xls";
proc gchart data=sashelp.class;
vbar height;
run;
quit;
ods msoffice2k close;
[/pre]
if you are writing directly to a web server or mapped drive, you may have to play around with the URL= option for the graph and gpath to get the location for the <IMG> tag to be the right web server URL.
for example, you may want something like this for the <IMG> tag:
[pre]
ods msoffice2k path='c:\reptdir' (url=none)
gpath='c:\reptdir' (url="http://www.wombat.com/reptdir/")
file="temp.xls";
[/pre]
In which case, the <IMG> tag would be built with the following SRC=
[pre]
src="http://www.wombat.com/reptdir/gchart.gif"
[/pre]
You can generally tell that you need to use some combo of PATH/GPATH if you see a red 'X' in the browser or in Excel.
cynthia