View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
StargateFan[_2_] StargateFan[_2_] is offline
external usenet poster
 
Posts: 12
Default 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