Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Macro and Sharepoint (2002/2003/2007)

    We have a Chain of Custody (COC) that we created as an Excel template. There is a macro, thanks to the loungers, that refers to a counter file to update the COC number each time a person uses the template to create a new COC. This has been working fine. The problem has come up because the form was moved to Sharepoint.

    The form's macro is still looking to the network for the counter file with the last number. If the file is used to create a new COC the cell where the number is to be displayed, just keeps increasing like the macro is in a loop.

    I've tried copying the counter file to Sharepoint and changing the macro to find the counter file on Sharepoint, but the loop continues.

    Any ideas?

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts

    Re: Macro and Sharepoint (2002/2003/2007)

    As a test, you could try to put an Excel Workbook out on Sharpoint with some type of sample data. Then write a small VBA procedure in a open workbook. The VBA should Open the Sharepoint Workbook, transfers some data to the open workbook and then close the Sharepoint workbook. If the test works make sure the Old VBA has the exact same file path information as the test and that the VBA has the exact name of the Counter file.

    Regards,

    Tom Duthie

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Macro and Sharepoint (2002/2003/2007)

    Just a thought....is the file being opened in Sharepoint a Read-only which is the default?
    Jerry

  4. #4
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: Macro and Sharepoint (2002/2003/2007)

    The Sharepoint site is read only for most people, so you are right. We figured out that we cannot put the counter text file on Sharepoint. We found a place on the network which can be edited by all. Sharepoint will let the macro update the counter even with the spreadsheet read only. We had people test the spreadsheet and the counter from several places across the country. This seems to work.

    Thanks to all for your thoughts.

Posting Permissions

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