claire rand
03-29-2005, 09:07 AM
Quick question, hopefully with a quickish answer..
Having run out of space in Excel I'm now using the pivot charts feature in Access (after getting it to work). Question is...
How can I copy a version of the file to the clipboard to include in another report (in word). I know i can do a print screen, but I'm hoping there is a way of getting an metafile out of it.
The normal copy & paste methods don't work since I can't get the chart onto the clipboiard in the first place.
I'm sort of hoping there is a way of doing this via VBA.
While a metafile would be the most use a decent resolution bitmap would be fine also (I can't install a printer driver so 'printing' to the file is out unfortunatly).
I can print the charts, from Access, and view them.. but they appear to be sod all use for anything else sicne I can't get them *out* of access..
ARGH...
Having run out of space in Excel I'm now using the pivot charts feature in Access (after getting it to work). Question is...
How can I copy a version of the file to the clipboard to include in another report (in word). I know i can do a print screen, but I'm hoping there is a way of getting an metafile out of it.
The normal copy & paste methods don't work since I can't get the chart onto the clipboiard in the first place.
I'm sort of hoping there is a way of doing this via VBA.
While a metafile would be the most use a decent resolution bitmap would be fine also (I can't install a printer driver so 'printing' to the file is out unfortunatly).
I can print the charts, from Access, and view them.. but they appear to be sod all use for anything else sicne I can't get them *out* of access..
ARGH...