Huh, what? OK....explain this whole thing in a bit more detail. I think there is a solution to your problem but the problem is vague :-)
>Looks like it is probably ODBC...then there is a 'DO Excel WITH...' call which is when Excel actually opens.
>
>
>>How are you "saving into Excel"?
>>
>>>I have a FoxPro table that I am saving into Excel. Some numerical fields in FoxPro have to be set as Char to allow the correct amount of decimal points to show. When this data is saved into excel, it does not allow you to format the fields to change them to number so that analysis may be done. The only way to change them is to edit every field. I can't seem to figure out why it won't allow me to change the formatting. Something seems to be holding the char format in Excel.
>>>
>>>Any ideas?
>>>
>>>Thanks!
------------------------------------------------
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