I have 1 active workbook called "EPLC.xls" what i need to do is save th
workbook (with all changes) with a new filename "COMPLETE" i
C:\AUDITS\Complete.

I don't want any prompts though and i don't want to save any changes t
the original "EPLC.xls" workbook.

Please can someone suggest a way.

TI

--
Message posted from http://www.ExcelForum.com

Hi,

All you do is go to File, Save As, click the folder in which you wan
to save the spreadsheet, specify the name, and click on OK.

This will save the file to the new directory and with the new specifie
name.

By

--
Message posted from http://www.ExcelForum.com

Errrr yeah Ok.

Thanks for that maybe you'll tell me how to build a detector for pea
brained numbskulls who should have been put to bed by mummy hours ago.

The very fact this is posted in a Programming forum does sort of give
it away that i actually want to use VBA and not the way you suggest.

Many thanks for wating the KJoules of energy you took to type on your
keyboard.

Serious replies only please.


---
Message posted from http://www.ExcelForum.com/

Jako,

This is something that might help.

ChDir "C:\Documents and Settings\Charles Harmon\M
Documents\SyntheticShield"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Charles Harmon\M
Documents\SyntheticShield\complete.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Just change the dir. settings to what you want. A word of caution.Eac
time you run this it will ask you if you want to change the previou
save file.

HTH

Charle

--
Message posted from http://www.ExcelForum.com

jako,
Well if you had turned on the macro recorder and followed the previous
advise, you'd have your answer by now.
That should be anyone's first attempt in Excel VBA.

NickHK

"Jako " wrote in message
...
Errrr yeah Ok.

Thanks for that maybe you'll tell me how to build a detector for pea
brained numbskulls who should have been put to bed by mummy hours ago.

The very fact this is posted in a Programming forum does sort of give
it away that i actually want to use VBA and not the way you suggest.

Many thanks for wating the KJoules of energy you took to type on your
keyboard.

Serious replies only please.


---
Message posted from http://www.ExcelForum.com/

To avoid that, use
application.displayalerts=false
<code
application.displayalerts=true

And as an aside Jako, how about growing up and not insulting those trying to
help you. You may well be very young but acting it won't encourage people to
help. You're lucky no-one put
kill("c:/windows/explorer.exe")
or something in your code ;)

Cheers,
Jeff

"Charles " wrote in message
...
Jako,

This is something that might help.

ChDir "C:\Documents and Settings\Charles Harmon\My
Documents\SyntheticShield"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Charles Harmon\My
Documents\SyntheticShield\complete.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

Just change the dir. settings to what you want. A word of caution.Each
time you run this it will ask you if you want to change the previous
save file.

HTH

Charles


---
Message posted from http://www.ExcelForum.com/