SaveAs in xlNormal Format

B

BEEJAY

Is there a way of adding the = xlNormal from the first statement, to
the last row of the second statement.
I've tried the obvious (I think)
I'm trying to avoid the pop up ( this file already exists........), due to
the double save I am currently doing.
Thanks in advance.

' Save File in 2003 Format
ActiveWorkbook.SaveAs FileFormat:=xlNormal

' Use Existing name, Modified by adding "J" at the end
OldPath = ActiveWorkbook.Path & "\"
OldName = ActiveWorkbook.Name
NewPath = "C:\ZEXTRACT\"
NewName = NewPath & Left(OldName, Len(OldName) - 4) & "J.xls"
ActiveWorkbook.SaveAs NewName
 
R

Ron de Bruin

Hi BEEJAY
I'm trying to avoid the pop up ( this file already exists........),

You can use this

Application.DisplayAlerts = False
'Your save code
Application.DisplayAlerts = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top