Exporting Access to Excel

M

Micah Chaney

Hello -- I'm using Access 2003 and Office 2003, Windows XP. I'm unable to
output to Excel. I don't know why, it just doesn't do it. There's no
error...it just doesn't do it. I'm trying to export a Report...could there
be some setting in my report that is preventing output to Excel?

What I'm trying to do, is utilize a Macro, to "SendObject" to a mail
recipient, in Excel 97-2003 format. However, I get an action failed error,
on the "SendObject" action. When I open the report, (looks great), and just
choose Export to Excel, everything goes through, but there's no output file.
Please help. Thanks.
 
A

adsl

Micah Chaney said:
Hello -- I'm using Access 2003 and Office 2003, Windows XP. I'm unable to
output to Excel. I don't know why, it just doesn't do it. There's no
error...it just doesn't do it. I'm trying to export a Report...could there
be some setting in my report that is preventing output to Excel?

What I'm trying to do, is utilize a Macro, to "SendObject" to a mail
recipient, in Excel 97-2003 format. However, I get an action failed error,
on the "SendObject" action. When I open the report, (looks great), and
just choose Export to Excel, everything goes through, but there's no
output file. Please help. Thanks.
Click to expand...
 
A

adsl

Micah Chaney said:
Hello -- I'm using Access 2003 and Office 2003, Windows XP. I'm unable to
output to Excel. I don't know why, it just doesn't do it. There's no
error...it just doesn't do it. I'm trying to export a Report...could there
be some setting in my report that is preventing output to Excel?

What I'm trying to do, is utilize a Macro, to "SendObject" to a mail
recipient, in Excel 97-2003 format. However, I get an action failed error,
on the "SendObject" action. When I open the report, (looks great), and
just choose Export to Excel, everything goes through, but there's no
output file. Please help. Thanks.
Click to expand...
 
A

adsl

Micah Chaney said:
Hello -- I'm using Access 2003 and Office 2003, Windows XP. I'm unable to
output to Excel. I don't know why, it just doesn't do it. There's no
error...it just doesn't do it. I'm trying to export a Report...could there
be some setting in my report that is preventing output to Excel?

What I'm trying to do, is utilize a Macro, to "SendObject" to a mail
recipient, in Excel 97-2003 format. However, I get an action failed error,
on the "SendObject" action. When I open the report, (looks great), and
just choose Export to Excel, everything goes through, but there's no
output file. Please help. Thanks.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003 db's & problems exporting query to Excel 1
Trouble exporting Report to Excel 1
Problem Exporting Images Over 5 MB to PDF 2
Outputting to File (excel) 2
Access Runtime 2003 Export to Excel Toolbar gone - replacement options? 1
Access export to Excel stops at about 45,000 not 65,000 XL limit 11
Exporting from Access to Excel 4
Exporting to excel 6

Top