Open And Print Excel Chart From Access

[EllieFant]

I want to create a command button that would open an excel worksheet and print a chart within that spreadsheet. The chart is on a sheet of it's own. (Worksheet name is PRP Status, Sheet name is PRP Status Chart).

I need it to open first because the worksheet is linked to queries within access and needs to get the updated information.

Is this possible? Or should I say, it is fairly easy to do.

Thanks in advance for your help.

Ellie
**Using Access 97 at work**
**Using Access 2000 at home**

lena.wood@starband.net

 

[Dreamboat]

Funny..I kinda had this question earlier tonight.

We've got someone who needs to do a mail merge type thing with an Access database. However, instead of inserting fields into a document, we're inserting them into an Excel worksheet.

So...I said to my coder, "Can we run this from a button in the database?" and he said "No, you can't print from an Excel file via Access."

Who knew? Not me! I'm still confused as to whether this is just a BAD setup, or it might not be good for the volume of printing we might have been doing, or if it's just entirely an impossible setup--which I find hard to believe. But there it is. Anne Troy

http://www.TheOfficeExperts.com

Word and Excel Macros
Coming soon: wX