Results 1 to 4 of 4

Thread: VBA if Save Fails then saveas
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2016
    Posts
    607
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default VBA if Save Fails then saveas

    Hi,
    I have thisworkbook.save in some of my macros though if save fails I would like to saveas in the same folder....

    Same file name but include V2, V3 etc....

    What is the best way to do this?
    Last edited by JumboCactuar; Feb 7th, 2019 at 04:53 AM.

  2. #2
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,922
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: VBA if Save Fails then saveas

    why is the code failing?
    are you getting an error message?

  3. #3
    Board Regular
    Join Date
    Nov 2016
    Posts
    607
    Post Thanks / Like
    Mentioned
    6 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA if Save Fails then saveas

    Just "File not Saved" though it's due to failing to upload to SharePoint. It happens now and again

  4. #4
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,922
    Post Thanks / Like
    Mentioned
    72 Post(s)
    Tagged
    7 Thread(s)

    Default Re: VBA if Save Fails then saveas

    Please post the ONE line of code that currently Saves the workbook (sometimes!!)
    - I need to see how it is constructed to understand how to amend it for you

    thanks
    Last edited by Yongle; Feb 7th, 2019 at 09:52 AM.

Some videos you may like

User Tag List

Tags for this Thread

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
  •