>>>Use Object Browser to pull Excel constants from the type library.
>>
>>I did that already but I don't have a clue as to which code is the regular Excel worksheet.
>
>I did some macro recording in Excel for SaveAs in different formats and found out following:
>
>
For Microsoft Office Excel Workbook (*.xls) FileFormat = xlNormal ( the same as xlWorkbookNormal). It seems that xlWorkbookNormal means the current Excel version file format
I guess I was reading the help file wrong. I thought that this code retains the original format of the currently opened file.
ramil
~~ learning to stand still