Print excel in access
- Thread starter Rudeman76
- Start date
- Local time
- Today, 06:50
- Joined
- Feb 28, 2001
- Messages
- 30,133
If you open the Excel document as an Application Object, you "expose" various methods associated with that application - including print.
Read up on Application Objects in Access's VBA Help facility.
Then read up on VBA under Excel's Help facility to find out how to open and print a specific document with a specific cell range, layout, etc.
The Help Files have examples for both of these topics. You sould look into those files. The hardest part is the "Everything I Needed to Know I Learned in Kindergarten" rule: If you open it, close it. If you take it out, put it away. If you expose something, cover it up before you leave. I.e. leave everything as you found it. The penalty for failing to do this is continued problems with something called a "memory leak." It would manifest itself as errors: Out of Virtual Memory or Out of Resources or Out of File Handles - or something like that.
Read up on Application Objects in Access's VBA Help facility.
Then read up on VBA under Excel's Help facility to find out how to open and print a specific document with a specific cell range, layout, etc.
The Help Files have examples for both of these topics. You sould look into those files. The hardest part is the "Everything I Needed to Know I Learned in Kindergarten" rule: If you open it, close it. If you take it out, put it away. If you expose something, cover it up before you leave. I.e. leave everything as you found it. The penalty for failing to do this is continued problems with something called a "memory leak." It would manifest itself as errors: Out of Virtual Memory or Out of Resources or Out of File Handles - or something like that.
