Infopath/Excel, HELP NEEDED!!!

[crashoverride]

What is the best way for a form to write/copy data to Excel?

I want a user of my form to be able to export rows of data from a repeating
table in Infopath into a blank Excel spreadsheet upon the click of a button.
Must this be done programmatically, and if so, could someone provide me with
some starter code in vbscript (I dont use JScript or vb.net currently) that
would automate the process of exporting the repeating table rows into the
spreadsheet rows of Excel?

Thanks a million in advance.

 

[crashoverride]

(I do not know if the export to excel menu command would accomplish this task
since it is not available for selection, i.e. its transparent at the moment)

 

[Badajoz95]

Mine is not greyed out and it works OK. I presume you have Excel 2003?

 

[crashoverride]

Yes I have excel 2003 but the option for exporting is not available for
clicking.

 

[Matthew Blain \(Serriform\)]

Are you in Preview mode? When you choose Preview from the designer, certain
'save' and 'export' functions are disabled.

 

[Sofer]

I am also trying to do this but am struggling...........

I have one set of fields at the top of the form (client, area, date, project
etc)

I then have a repeating table with multiple entries for the criteria above
()project, date, etc)

I want the user to be able to export the form headings (project, date, etc)
plus each of the multiple repeating table fields' contents to Excel at the
touch of a button

Any help would be appreciated

Thanks.................Rob

 

[crashoverride]

Thank you, that solved the problem (I was in Preview Mode). However, now I
have a new problem: when I am in the Export to Excel wizard the option "Form
Fields only (no tables or lists) is the only available option yet I need to
export the data from the repeating table. Any suggestions?