+ Reply to Thread
Results 1 to 2 of 2

Macro for close of excel file on sharepoint

  1. #1
    Forum Contributor
    Join Date
    09-19-2004
    Posts
    252

    Macro for close of excel file on sharepoint

    I'm writing a macro that runs when the excel file closes. It saves the file as a .prn and then uploads it to the mainframe. My major issue comes in two phases:

    Phase 1:
    I would like the macro to be able to tell if the file that is currently being closed has been checked out or not and run the macro if it has. If it has not then I must be in read-only mode so don't run the macro.

    Phase2:
    It seems that when the macro does run it doesn't check the excel file back in. is there some vba that I can use to check a file in?

  2. #2
    Forum Contributor
    Join Date
    09-19-2004
    Posts
    252

    Re: Macro for close of excel file on sharepoint

    Does anyone know how to do this?

+ 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