VBA: Export Graph to .GIF - code to then open .GIF

[Dee Cowman]

I've written the code to export an Excel chart to .GIF file. But I
then want that .GIF file to open. What would the code for that be?

Currently I can open my .GIF file with Microsoft Photo Editor. Another
option would be to have the .GIF file automatically be inserted into
PowerPoint - then have the PowerPoint automatically open.

Any ideas on this?

Thank you.

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins &
Software!http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
have a look at the Shell method in the VBA help. Use this to start your
imaging program and use the filename as first parameter (should work
for most applications)

 

[Dee Cowman]

Thank you, Frank -

The file I want to open automatically is located on my C:\ drive.

I've added the following:

Shell("C:\PWAFChart.gif", 1)

however, receive a Syntax error. If you or anyone has any other
thoughts - they are appreciated.

Thank you for your assistance.

Dee



** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins &
Software!http://www.ozgrid.com/Services/excel-software-categories.htm **

 

[Frank Kabel]

Hi
try
dim res
res=Shell("your image program path and location" & " " &
"C:\PWAFChart.gif", 1)

 

[Dee Cowman]

This works! Thank you very much!

Your assistance is greatly appreciated.

Dee

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins &
Software!http://www.ozgrid.com/Services/excel-software-categories.htm **