Looks like you may use a template when creating Excel files. Template shold have all formatting, headers, etc.. as needed.
_VFP.datatoclip will help to insert data from VFP table into open excel document.


>Hi All ,
>
>I need some help from all Gurus out there to figure out how to do this.
>
>Our company does contract manufacturing and I’m writing a routing to create quotes for various parts. This is what I’m trying to achieve..
>
>1. CreateQuote.Prg creates an excel sheet for each quote (part) and store in a specific folder on network.
>2. EditQuote.scx Pick List will display all available quotes (excel sheets) for user to edit
>
>Up to this point everything works fine. Now comes the fun part. I would like to do the following.
>
>3. When user selects excel sheet(quote) via my pick list to edit , I would like that quote excel sheet to be formatted (Column headings, With, Font, Summing some columns etc )
>
>4. When user done editing, focus comes back to the pick list. ( This works OK)
>
>Questions
>
>Each excel sheet (Quote) has a different file name .
>
>* When I write macro how do I figure out the file name. ?
>* Can I pass the file name from my form to selected excel sheet?
>* What is the best place to store the macro/VBA codes ??
>* Even if I do the macro, how do I call it to run on selected , unformatted excel sheet ?
>
>Please Help.
>
>- Jeana -