Export to Excel through a machine with 2007 but to export xls fails

[amars]

Hi all,

I have a job which mail's excel files to different peoples. Now I am sending xlsx files from a machine which is having Excel 2007. But from the same machine if I send xls & if some user having Excel 2003 opens it , he see some weird characters. How to export xls from a machine which is having Excel 2007.

I am using

XLDoc.SaveAs

"C:" & strFileName & ".xls"

How to Solve this.

Thanks in advance

Regards ,

Amar

[#2]

Hi

This link might help:
http://social.technet.microsoft.com/Forums/en/ITCG/thread/92102c07-9892-42e4-91c3-7544044d7204

/Fredrik

[amars]

I have tried to Save the Files as .xls but it doesn't solves my purpose. It get's saved with .xls extension but it is an xlsx file & when I mail it to some one it open's up with a single sheet containing some unknown characters.

XLDoc.SaveAs

"C:\" & strFileName & ".xls"

This way I am saving the file as .xls but it is an xlsx file ideally . Is there some way to specify it in a macro or some other way. Please let me know . Thanks in advance & it is urgent as is been pending for so long.

With Regards,

Amar s.

[#4]

Hi amars,

If I was you I would try something like that:

export your file as a csv file

open it with excel and save it as a xls

then get the file and email it to your mailing list

you shoud do it using vbscript

*** If your mailing list is always the same you could possibly send email even directly from excel using a macro ***

Hope this helps...

rb