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

Stuart McLachlan stuart at lexacorp.com.pg
Wed Nov 16 16:15:12 CST 2011


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
> 






More information about the AccessD mailing list