The transfer of forms to an excel file

[Hudson40]

Hi

Can anyone tell me if it ispossible to export a form from Access to a file in excel?

 

[ansentry]

You would export the query or table that is the source for the form, not the form.

 

[Moniker]

The form itself (the buttons, textboxes, etc.) cannot be "exported" as it were into Excel. The data can be using the previous suggestion.

 

[Hudson40]

the transfer of graphs to excel

Thanks for your help and will do.

The thing is, its not a standard form I want to transfer. I have created graphs via the chart wizard when creating a new form. I have many graphs that are created via the user inputing various dates and codes. I would like to create a monthly report for my dept and istead of tediously copying and pasting 15 graphs into an excel file I would like to automate this. Is this possible?

Thanks

Andrew