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:
Application.DisplayAlerts = False
Workbooks(splicedName).Save
Workbooks(splicedName).Close (False)
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.
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?