LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default Programatically Export Excel Chart to Graphic in SharePoint

I have been using the following VBA command to export Excel charts to
graphics. This works perfectly for local or network storage.

Worksheets(1).ChartObjects(1).Chart.Export
Filename:="Filepath\Filename.gif", filtername:="GIF"

When I modify to save to SharePoint site as follows it returns Error
-2146697210 (800c0006).

Worksheets(1).ChartObjects(1).Chart.Export
Filename:="http://ms-proto/TeamFolder/Shared%20Documents/Filename.gif",
filtername:="GIF"

I have tried the application.workbooks.saveas command to save the workbook,
and that does work to save into sharepoint. Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export Error, Excel to SharePoint DOUG Excel Discussion (Misc queries) 0 May 5th 09 09:08 PM
Is it possible to export an Excel 2007 chart as a vector graphic? ebfish Excel Discussion (Misc queries) 0 September 10th 08 07:44 PM
Export list from Sharepoint to Excel and it is locked NancyB Excel Discussion (Misc queries) 0 September 8th 08 07:16 AM
How can I Export a SharePoint list to a spreadsheet in Excel 2002 Christos Excel Discussion (Misc queries) 1 March 1st 07 10:20 AM
export in graphic format - experts, can vba do it? Mark Excel Programming 5 January 6th 05 11:01 AM


All times are GMT +1. The time now is 01:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"