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!
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!