>Can anyone provide some sample code that shows how to open an existing excel sheet, then add info to the header and footer, put gridlines around the data and then save and close the file? I am tired of doing all the formatting for my reports in excel after I make an Excel sheet out of them when I know I should be able to do it in Fox. Thanks for any help you can give
There's a book 'Microsoft Office Automation with Visual FoxPro' at
http://www.hentzenwerke.com/catalogavailability/autofox.htm
--sb--