Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Nov 2010
    Location
    Western Australia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi
    I have copied part of a macro from another document that I use and I have pasted it into the attached document - I keep getting a Run-time error 1004 (Application - defined or object -defined error)
    I have gone over it so many times and cannot find the problem.
    Your help would be greatly appreciated as I am not very conversant with macros.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    What do you do to trigger the error?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Nov 2010
    Location
    Western Australia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello

    when I open the document I select enable macros but when I close it nothing happens, it does not ask me if I want to send update.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    It's not set up to do anything when you close it. You have to run the macro to send the email.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Nov 2010
    Location
    Western Australia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi Rory

    Will you show me how to set my macro up so that it will ask me if I want to send update each time it is opened and saved?
    The whole thing is doing my head in! I am solly deveoping a fobia for macros lol

  6. #6
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Celene View Post
    Hi Rory

    Will you show me how to set my macro up so that it will ask me if I want to send update each time it is opened and saved?
    The whole thing is doing my head in! I am solly deveoping a fobia for macros lol
    Rory seems to be off line just now. Perhaps the attached will help. I have modified and moved the code into the Workbook module.
    Attached Files Attached Files
    Regards
    Don

  7. #7
    New Lounger
    Join Date
    Nov 2010
    Location
    Western Australia
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Many thanks for your help all is working well thank you so much :-)

Posting Permissions

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