[AccessD] Access - Excel "Automation" Exporting a Spreadsheetto a JPG File

Brad Marks BradM at blackforestltd.com
Thu Nov 17 15:12:08 CST 2011


All,

Thanks for the assistance, I appreciate it.

Brad



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart
McLachlan
Sent: Wednesday, November 16, 2011 4:15 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access - Excel "Automation" Exporting a
Spreadsheetto a JPG File

Well blow me down, who'd a thunk it?

Worksheets("Sheet1").Range("A1:D4").CopyPicture xlScreen, xlBitmap 
Once you have the image on the clipboard, you can use the example 
OleCreatePictureIndirect()  code directly in Access to do it. 

-- 
Stuart

On 16 Nov 2011 at 21:33, Martin Reid wrote:

> Or
> 
> See this thread
> 
> http://www.mrexcel.com/forum/showthread.php?t=233108
> 
> Martin
> 
> Sent from my Windows Phone
> ________________________________
> From: Stuart McLachlan
> Sent: 16/11/2011 21:15
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Access - Excel "Automation" Exporting a
Spreadsheet to a JPG File
> 
> I sincerely doubt it is possible within the Excel object model.  A
chart is essential a  Windows
> Graphic control (a bitmap), exporting that as a graphic is trivial.
An Excel spreadsheet is
> essentially a Listview control, that's a whole different kettle of
fish.
> 
> --
> Stuart
> 
> On 16 Nov 2011 at 13:40, Brad Marks wrote:
> 
> > Folks,
> >
> > I have recently been experimenting with "Windows Automation" to
control Excel from Access.
> >
> > I have had quite a bit of success and fun with this realm with
several key questions being answered here on AccessD.
> >
> > In one of my tests, I am exporting an Excel chart to a jpg file.
This works nicely using this command.
> >
> > XLChart.Export FileName:=StrPath, Filtername:="JPG"
> >
> >
> >
> > I now would like to find out if it is possible to export a small
Excel spreadsheet itself to a JPG file.  (5 columns, 2 rows).
> >
> > I have not been able to find a way to do this.
> >
> > Thanks for your help and advice.
> >
> > Sincerely,
> > Brad
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> 
> 
> 
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 



-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.





More information about the AccessD mailing list