Hello All,

I am trying programmatically trying to save an excel worksheet to a dbf file. I can open the worksheet get the correct page to display but the save function does not work. I don't get an error but when I go to open the table I get not a table error.

Here is my line of code.

*oWorkBook.SaveAs('upenviro3.dbf')

I can make the worksheet visible and have the user save manually then close out fine but I want it to all happen by magic.


Thanks for the help....