excel 2007 Save As?

[Mark J]

I have the following code;

Sheets(Array("Moscad", "Opto")).Select

Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False


Sheets(Array("Moscad", "Opto")).Copy
Set NewWb = ActiveWorkbook


WBname = " " & Format(Now() - 1, "ddmmyyyy") & ".xls"
NewWb.SaveAs "C:/" & WBname

it worked in excel 2003, but i have converted up to excel 2007, i am trying
to save a copy of the active workbook as a excel 2003 file. any ideas on how
to adjust the code?

 

[Zack Barresse]

Hi Mark,

Not the best looking code in the world... but have you even tried it in
2007?? I'm failing to see what the problem is. Code from 2003 will almost
predominatly run in 2007 as well.

 

[Ron de Bruin]

Hi Mark

See
http://www.rondebruin.nl/saveas.htm

 

[Mark J]

Thanks Ron, thats the info i needed.

Hi Mark

See
http://www.rondebruin.nl/saveas.htm