Save sheet bitmap to desktop?
[snip]
1) *It saves a GIF of the range B1:B4, yes, but drags the chart
background with it. *Can the range itself be the only thing *exported,
by any chance? *Would the parameters in oRange.CopyPicture xlScreen,
xlPicture be the culprits (xlScreen???).
2) *Error capture re path possible? *If desktop is not P:\0DESKTOP\,
as when I do this at work where desktop at different location, any way
to prompt user to change path?
Hi, everyone. I have tried to fix this myself but I have had no
luck. On the code above, is there _any_ way to JUST get the range
exported? The export includes what must be a temporary chart
background.
Secondly, any error correction possible on the path?
Thank you!
:oD
|