Hello:
Try recording a macro in Excel. Then look at the code to get an idea on how this can be done using OLE.
HTH,
--Paul
>I've recently created several pages of an excel report using OLE with FoxPro. There are a few more commands that I need syntax for:
>
>1. add the "pages" command, file name, and sheet name to the footer
>
>2. adjust font and size on headers and footers
>
>3. center text between mulitple cells
>
>If anybody can help with these commands I could sure use some help.
>
>Thanks in advance
>
>Jeff Pearce
>
jpearce@semitool.com