Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 11th, 2009, 06:48 PM
Authorized User
 
Join Date: Jun 2003
Posts: 54
Thanks: 1
Thanked 0 Times in 0 Posts
Default How do I save clipboard as a picture

I want to save screenshots of each worksheet as a bmp or gif file, In Excel 2007, Home>Paste>As Picture I can select Copy As BitMap. This gets an image of the
Worksheet onto the clipboard. How can I then save the clipboard as a .gif file? TIA.- Steve
 
Old May 11th, 2009, 07:03 AM
Authorized User
 
Join Date: Jun 2004
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would suggest saving the files as .bmp and then using a third party software such as imageconverter to convert the files
http://www.imageconverterplus.com/
__________________
Ed.
Ne auderis delere orbem rigidum meum!
 
Old May 11th, 2009, 10:28 AM
Authorized User
 
Join Date: Jun 2003
Posts: 54
Thanks: 1
Thanked 0 Times in 0 Posts
Default

The question is how do I save the clipboard as a bmp,- not what do do with it after I saved it.





Similar Threads
Thread Thread Starter Forum Replies Last Post
how to save picture in oracle using Blob pandeyvic Oracle 1 December 2nd, 2006 03:51 AM
Picture box container controls save to image mujeeb General .NET 0 May 20th, 2006 03:46 AM
How to save a picture in Microsoft Access Database Edward King Java Databases 0 January 4th, 2006 01:27 AM
How to disable Right-click to Save Picture As.... bekim HTML Code Clinic 11 January 9th, 2005 02:09 AM
OLE picture - accessing the picture property bdcrisp Excel VBA 0 December 7th, 2003 09:35 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.