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

Martin Reid mwp.reid at qub.ac.uk
Wed Nov 16 15:31:35 CST 2011


Would a print screen do if you could send the key strokes

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



More information about the AccessD mailing list