Problem exporting graph from excel error 1004

[ziroop]

Hi,

I'm trying to use vba to export a graph as gif.
Use this as example code:
Sub Create_GIF()
Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(1).Chart
mychart.Export FileName:="c:\Mychart.gif", FilterName:="GIF"
End Sub

The path where I want to save to is part of sharepoint.
Path looks like: https://sharepoint.company.com/site/... etc..
The sharepoint site is connected as a network drive in my explorer so I can enter is straight from explorer.

When I try to save to this path I get error 1004 application defined or object defined error. When I save for instance to my C-drive everything works ok.

Any ideas?

Thanks!

 

[ziroop]

Does anyone have an idea?

thanks