|
-
Feb 27th, 2009, 12:59 PM
#1
Thread Starter
Hyperactive Member
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.
-
Feb 27th, 2009, 01:04 PM
#2
Thread Starter
Hyperactive Member
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|