jwcolby
jwcolby at colbyconsulting.com
Mon Jun 29 21:49:20 CDT 2009
Automation using Access as the base is cool because you can store code where it best fits. You can place modules into the spreadsheet to do the things like formatting of cells and the like, and call it a template, and you can place the code that does the talking to Excel in Access modules, even out in libraries. John W. Colby www.ColbyConsulting.com Jim Lawrence wrote: > Hi William: > > I have done a lot of graphics through spreadsheets... a number of my users > like excel and like to see a spreadsheet or two in which to play. There is > no harm in that as they are just results. > > A couple of years ago I built a whole dynamic spreadsheet with a number of > forms and recordsets, with ranges instead of tables for a Real-estate > company back East. That was real hard work as apposed to Access as much of > the data had to be validated with each command as users could screw with the > data. As per emails there is some more work coming up...? > > Jim > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Monday, June 29, 2009 1:45 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Converting Customers to VB.Net(was: Pollon Access2 > 007) > > Jim > > ...the only Office automation I was ever guilty of was Word merges and > e-mail which can be done with .net. > > William