Brott
Board Regular
- Joined
- Dec 12, 2002
- Messages
- 110
Ok power users.
I have a form with a button. This button is set up as a Macro. This Macro is set to Analyze/Export one table in Excel then close.
No big deal right, right.
Now I would like to have all my reports do the same thing. Right now I go in and open the reports individually then analyze/export it into Excel. The file name will always remain the same name so it can keep writing over the old one.
If it has to be done via vba can someone help with that?
Access file name is ABC
Table name is XYZ
Report Name is 123
Excel file name DEF
Thanks for any assistance.
I have a form with a button. This button is set up as a Macro. This Macro is set to Analyze/Export one table in Excel then close.
No big deal right, right.
Now I would like to have all my reports do the same thing. Right now I go in and open the reports individually then analyze/export it into Excel. The file name will always remain the same name so it can keep writing over the old one.
If it has to be done via vba can someone help with that?
Access file name is ABC
Table name is XYZ
Report Name is 123
Excel file name DEF
Thanks for any assistance.