error excel macro 2002/2003

[max_max]

Hello everyone.
In workbook attached is a macro that works perfectly with Excel 2007, but with Excel 2002/2003 gives error on this point:

Please Login or Register  to view this content.

the error is:

run-time error 1004
saveas method of the worksheet Failed

a help?
Thanks in advance.
max max

[Gatti]

Try FileFormat:=xlExcel8

To get the Excel Version:

Please Login or Register  to view this content.

[max_max]

Ciao,

this
Try FileFormat:=xlExcel8
= xls?

and for xlsx ? (no FileFormat:=51)

Another thing that

FileFormat:=xlExcel8

works on Excel 2003/2002?

thanks Fabio
A greeting.
max_max

[Gatti]

Did it work?

[max_max]

It is here at home with excel 2007

File Format: = xlExcel8

work.
but with excel 2002/2003 work?

[Gatti]

It should do... I don't have installed the V. 2002 or 2003 to try now...
Please, try it and give me a feedback

[max_max]

Thanks fabio.
I am attaching the file if someone online would excel 2002 and felt I would be happy.
max_max

[Gatti]

No problems!

BTW, found the answer in Ron de Bruin's Site:

Please Login or Register  to view this content.

[max_max]

Hello
I tried but it does not work on excel 2002
I think the error is here:

wsDest.SaveAs

not work in excel 2002?

[max_max]

The advise error is

run-time error 1004
saveas method of the workbookFailed

max_max

[max_max]

Someone understands something?
max_max

[max_max]

Hi to all.
With excel 2002:

run-time error 1004
saveas method of the worksheet Failed

'ActiveWorkbook.SaveAs Filename:=sNomeFile, FileFormat:=56 xls
ActiveWorkbook.SaveAs Filename:=sNomeFile, FileFormat:=xlExcel8

-----------------------------------------------------------------------------------------------
no error:

'wsDest.SaveAs Filename:=sNomeFile '<<< questo O.K.
ActiveWorkbook.SaveAs Filename:=sNomeFile '<<< questo O.K.

max_max