Macro Button in Header to export to excel (1 Viewer)

[byujakedmb]

Hey y'all I need help creating a macro button to put in the header of my form. I need the button to export the form to excel. Can anyone help me do this?

 

[byujakedmb]

anyone know what to do?

 

[SoxPats83]

are you running access 2007?

 

[byujakedmb]

are you running access 2007?

yeah and I am fairly new to it

 

[DCrake]

When you say "Export to Excel" what do you actually want to see in Excel?

 

[byujakedmb]

When you say "Export to Excel" what do you actually want to see in Excel?

just the information in the columns the way it is organized in the form. I dont need the format or borders or anything like that. Just the column headings and data

 

[DCrake]

Why do you need it in Excel?

You need to be looking at the transferspreadsheet command.

Does it need to go into a new or existing workbook?

 

[byujakedmb]

Why do you need it in Excel?

You need to be looking at the transferspreadsheet command.

Does it need to go into a new or existing workbook?

I dont necessarily need it in excel, but I need to send just the report in an email. So I figured the easiest way would be to export it so it becomes its own file and then I could send it. Is there another way that would make more sense?

 

[DCrake]

Depends on the version of Access you are using and whether the receipent has access or not. If 2007 you could output to PDF and send them the pdf as an attachment.

 

[byujakedmb]

Can someone help me create a macro to put on a report that runs a saved export? (2007)