Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Location
    USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Save As Program Error (97 SR2)

    Hello! Can anyone help me with a save as problem in Excel? I have three files one with old data, one with a new format and one with a macro to move everything from the old to the new. Everything works great until I go to save the file with the new format. If I save it as it's existing name it will save but if I try to save as it gives me a program error and boots me out of excel. HELP!

    Thanks - Marie

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Save As Program Error (97 SR2)

    Marie

    Sounds really bad. But I have to ask you some questions first.

    1) When you say <<< program error and boots me out of excel. >>> Can you tell us exactly what the error is?
    2) Excel crashes when you do a AaveAs, are you simply changing the name or the location as well? If the location is being change, do you have the rights to save the workbook in that location?
    3) Can you add the code that does the SaveAs, maybe we can spot something for you.

    OK lets see

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    New Lounger
    Join Date
    Sep 2001
    Location
    USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save As Program Error (97 SR2)

    Ok..ummm...
    1. The error - excel.exe has generated errors and will be closed by Windows. You need to restart.....ok
    2. Changing the name same location.
    3. Sure if you can tell me how to add it. I am a beginner at VBA.
    I should also note that it only happens with the new file. I don't have this problem with other files and it is only after the conversion macro is completed.

    Thank you - Marie

  4. #4
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Save As Program Error (97 SR2)

    Marie

    1) This is a memory issue that may never be solved. Maybe you should try and reboot your PC and start fresh and see what goes on.
    2) So you have the needed rights to write (save) a file to that location.
    3) Copy the code, where the SaveAs is and paste it into the reply message. Copy a couple of lines above and below the line not just that line.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  5. #5
    New Lounger
    Join Date
    Sep 2001
    Location
    USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save As Program Error (97 SR2)

    Wassim

    Tried to reboot and not successfull. I started playing with it again after my last post. I moved the "save as" up and then did a save at the end and it appears to be working.

    Thank you!

Posting Permissions

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