Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Running macro after user saves file

  1. #1
    Guest

    Default

    Hello all,

    Hopefully this is a simple question. I need to execute a subroutine AFTER the user saves the file (either save OR save as, doesn't matter which).

    I have come across both the WorkbookBeforeSave application event and Workbook_BeforeSave workbook event, but again, I need this sub run after the save.

    Any thoughts as to how do this?

    My apologies if this an ignorant question.

    Thanks for your time.

    Regards,

    Sean C.

  2. #2
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It's not a stupid question at all. I can't think of anything that will do what you want. Why do you want to run a macro after saving anyway? What does the macro do? There may be another way around this.

    (I bet you say a client or the boss needs it this way.)

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Ireland
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Well I'm no expert, but could you use the Auto_Close macro to do whatever it is you need to do? I don't know if this would work. I guess it depends on what you want the macro to do. If it's going to be making changes to the file, it will have to be saved again. If the macro doesn't save changes for you, the user will be prompted. Would they say yes if they were, or would they say no cause they've already saved???You could also have the Macro save changes, the only problem is if the user doesn't want to save changes, this would cause a problem. I'm sure my explanation is about as clear as mud and maybe it doesn't even help your problem at all, but it's just a suggestion

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Ontario, Canada
    Posts
    337
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-04 18:33, Anonymous wrote:
    Hello all,

    Hopefully this is a simple question. I need to execute a subroutine AFTER the user saves the file (either save OR save as, doesn't matter which).

    I have come across both the WorkbookBeforeSave application event and Workbook_BeforeSave workbook event, but again, I need this sub run after the save.

    Any thoughts as to how do this?

    My apologies if this an ignorant question.

    Thanks for your time.

    Regards,

    Sean C.
    It sounds simple, but those are usually the more complicated solutions. This is what I would do but it requires the user to close with a button instead of the normal way.

    I basically recorded the macro (in Personal.xls)in a file that was already named. clicked save then closed and selected another macro from the list....stop recording. Tie code to button on toolbar.

    It worked but am I missing your point?

    Sub saveclose_runSub()
    '
    ' saveclose_runSub Macro
    ' Macro recorded 3/5/2002 by
    '

    '
    ActiveWorkbook.Save
    ActiveWindow.Close
    Application.Run "PERSONAL.XLS!YourMacro"
    End Sub


    Ziggy

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Ireland
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry, for some reason when I read your post I thought you wanted it to run when you closed the workbook. My post was useless really! Sorry


    On 2002-03-05 02:35, y2k wrote:
    Well I'm no expert, but could you use the Auto_Close macro to do whatever it is you need to do? I don't know if this would work. I guess it depends on what you want the macro to do. If it's going to be making changes to the file, it will have to be saved again. If the macro doesn't save changes for you, the user will be prompted. Would they say yes if they were, or would they say no cause they've already saved???You could also have the Macro save changes, the only problem is if the user doesn't want to save changes, this would cause a problem. I'm sure my explanation is about as clear as mud and maybe it doesn't even help your problem at all, but it's just a suggestion

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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