i'm exporting a chart into jpg with the following code...

oExcel.ActiveChart.Export FileName:=App.Path & "\chart.gif", FilterName:="GIF"

In XP it works fine...

But in Vista, it gives the error

ERR 70 - Permission denied"

please advice on this...

Thanks in advance


I think you will find it is caused by Vista security features. To stop message
go to Control Panel, user accounts.
For the account you are using turn UAC (User Access Control) off.

Then your program should run.

You are welcome - thanks for letting us know it works.