+ Reply to Thread
Results 1 to 9 of 9

SaveAS Error

  1. #1
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    SaveAS Error

    I have tried to get the below code working but I have obviously done something wrong as although I get no error messages I am not getting the second part to trigger

    The first part does what it should do bit the second part doesn't trigger the msgboxes

    Any ideas what I am doing wrong??

    Please Login or Register  to view this content.
    Last edited by tigerdel; 09-26-2012 at 11:05 AM. Reason: Corrected Code Tags

  2. #2
    Forum Contributor
    Join Date
    03-15-2007
    Location
    AL, USA
    MS-Off Ver
    2007
    Posts
    174

    Re: SaveAS Error

    You just needed to end your if statements propperly
    Please Login or Register  to view this content.
    Last edited by mshale; 09-25-2012 at 05:45 PM.

  3. #3
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    Re: SaveAS Error

    Clinic TNA WIP.xlsbThanks for the speedy response but this still doesn't work

    As there is no real sensitive data in this file, I have uploaded it

    If you click start at the home page and then click the finish button, you will now see it does nothing but select cell BB1

    Any help here great appreciated

  4. #4
    Forum Contributor
    Join Date
    03-15-2007
    Location
    AL, USA
    MS-Off Ver
    2007
    Posts
    174

    Re: SaveAS Error

    I'm not sure why, It works just fine stepping through it with a test sheet. I'm leaning more toward the possibility of another snipet of code that is causing an error.

    Opening your sheet you just uploaded is a nightmare. It opens the document twice and tells me that the sheet is locked for editing and a few other wierd things.

    I also had to change "TRUE" to "True" in your original code to get it to work at all for me. I have changed it back to caps so you might want to try the above again.

  5. #5
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    Re: SaveAS Error

    I noted the change of case for True and False and changed them back to TRUE and FALSE

    Now id it says TRUE the script works perfectly but not if it says FALSE

    Strange or what??

  6. #6
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    Re: SaveAS Error

    I sussed it

    Thanks this now works perfectly

    Problem solved

  7. #7
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    Re: SaveAS Error

    mshale you truly are a star

  8. #8
    Registered User
    Join Date
    08-19-2012
    Location
    London, England
    MS-Off Ver
    Excel 2016 in Win 10
    Posts
    97

    Re: SaveAS Error

    OK so how do I mark as solved??

  9. #9
    Forum Contributor
    Join Date
    03-15-2007
    Location
    AL, USA
    MS-Off Ver
    2007
    Posts
    174

    Re: SaveAS Error

    What did you find wrong with it?

    To mark as "Solved", all you need to do is click "edit post" on your first post. to the immediate left of where your thread title is, you should see a prefix selection. Just select solved, and then save near the bottom of the post.

+ 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