I am doing a program to generate a report from Access. The data comes from an RS6000 through an Excell worksheet using a Microsoft Query, That I have linked to Access. What I want to do is when the report is run Access to open the Excell sheet (toget the most current data)and I need the Excell sheet to automaticly refresh it’s self. Right now I have to click on refresh data from the menu. How can I have the excell sheet automaticly refresh itself?
Dennis
