View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
[email protected] julia.stone@gmail.com is offline
external usenet poster
 
Posts: 18
Default Exporting Chart to GIF File

Thanks to you both. I changed the variable name to chart_index. And
that did not help, but apparently there is an issue with the way I have
defined the location to save the file:

strGifFileName = "C:\My Documents\" & "MyChart" & chart_index & ".gif"

When I changed it to just C:\ it worked. I would prefer My Documents.