Saving Workbook

[Jako]

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

 

[lynnnow]

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

 

[Jako]

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.

 

[Charles]

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

 

[NickHK]

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

 

[Jeff Standen]

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