+ Reply to Thread
Results 1 to 9 of 9

Error when exporting chart to sharepoint

  1. #1
    Registered User
    Join Date
    08-19-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Error when exporting chart to sharepoint

    Hi
    I have a macro that does an export of a chart to a Sharepoint image library. This is the code I am using to do the export:
    Please Login or Register  to view this content.
    The code works fine on one computer but returns an error on another. The error I recieve is:
    Run-time error '-2147286987 (80030035)':
    Method 'Export' of object '_Chart' failed
    Also it will not work on that same computer for a different user.
    The code works anywhere if I change the address to an actual folder location like C:\Images.
    I realise this might be more of a problem with sharepoint than excel but it doesn't hurt to try.
    Last edited by teylyn; 08-20-2010 at 03:38 AM. Reason: added code tags

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Error when exporting chart to sharepoint

    Sferix, welcome to the forum.
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

    I've added the code tags for you this time only. Please remember to use them from now on.

    On the computers throwing the error, can you access the SharePoint library by entering the path \\SharePointAddress\NCC\publishingImages\ in Windows Explorer? Do these users have write access to the SP Library?

  3. #3
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Error when exporting chart to sharepoint

    Sounds like a file permissions issue to me.
    Remember what the dormouse said
    Feed your head

  4. #4
    Registered User
    Join Date
    08-19-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Error when exporting chart to sharepoint

    My apologies for not using the code tag.

    I can access the sharepoint library by entering the path in windows explorer and I have full access to the library.

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Error when exporting chart to sharepoint

    And does it fail for you on that problem computer?

  6. #6
    Registered User
    Join Date
    08-19-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Error when exporting chart to sharepoint

    It works on one PC for one user. It will not work for me on that same PC. It will not work for that same user on a different PC.

    Additional:
    I can use a DOS copy command to copy an image to this sharepoint library and it works fine.

  7. #7
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Error when exporting chart to sharepoint

    Have you tried re-registering the OWSSUPP.dll file on the second machine?
    regsvr32 "C:\Program Files\Microsoft Office\Office12\OWSSUPP.DLL"

  8. #8
    Registered User
    Join Date
    08-19-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Error when exporting chart to sharepoint

    I have tried this but the file fails to register.

  9. #9
    Registered User
    Join Date
    08-19-2010
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Error when exporting chart to sharepoint

    Haven't been able to figure this problem out but through my searching for an answer I found that I can save a sheet as a webpage directly to a Sharepoint library and it will republish every time it is saved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1