Results 1 to 2 of 2

Thread: Name Conflict during Save 2007

  1. #1

    Thread Starter
    Hyperactive Member pgag45's Avatar
    Join Date
    Mar 2007
    Location
    Colorado
    Posts
    262

    Name Conflict during Save 2007

    While I update a well working project from Excel 2003 to 2007, one piece of code that is really troubling is me, is a save method.

    vb Code:
    1. Application.DisplayAlerts = False
    2. Workbooks(splicedName).Save
    3. Workbooks(splicedName).Close (False)
    4. Application.DisplayAlerts = True

    In 2003, this work fine, but in 2007, I get two name conflicts "wc13" and "wc15" that the user must click OK on to rename them. Can anyone explain these errors, or how to just get a default OK (though displayalerts worked, but guess not).

    Thanks, and sorry if this has been asked before.

  2. #2

    Thread Starter
    Hyperactive Member pgag45's Avatar
    Join Date
    Mar 2007
    Location
    Colorado
    Posts
    262

    Re: Name Conflict during Save 2007

    Actually, think I may have fixed this error.. Before I was using a .xls (2003 style), which I assume was running as a conversion for 2007. Saved it as an .xlsm and all seems to be working well.

    Still wondering why this error appears?

Posting Permissions

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



Click Here to Expand Forum to Full Width