Hi Patric,
Glad Cetin and I could help. If you are doing a lot of Office automation, you might want to consider the Office 2000 VBA Language Reference from Microsoft Press. Doesn't give you all the answers but at least tells you where to start looking.
>>
>>Try this:
>>
>>objBook.SaveAs(blahblahblah,6)
>>
>>The second parm is FileFormat. There are a gazillion file formats; 6 is equal to the Excel constant xlCSV.
>>
>>
>
>Thanks, John. I finally found my notes, which apparently I am more dependent on that I realized! (Your assistance definitely bailed me out of trap!)
>
>Thanks again,
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05