Stuart McLachlan
stuart at lexacorp.com.pg
Wed Nov 16 15:13:56 CST 2011
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 >