hello,

I have code, which export charts as gif:

Worksheets("Graphs").ChartObjects(1) _
..Chart.Export _
Filename:="Total_GRPs.gif", FilterName:="GIF"

is there way how to specify the path for export?

I want to export it in same location, where my xls file is saved, but
in new folder "charts"....can I create a new folder with macro from
excel?

thanx

tommy


--
tommy_gtr
------------------------------------------------------------------------
tommy_gtr's Profile: http://www.excelforum.com/member.php...o&userid=26089
View this thread: http://www.excelforum.com/showthread...hreadid=493301