Brad Marks
bradm at blackforestltd.com
Tue Feb 3 16:43:31 CST 2015
Bill, Thanks for the tip. I checked for this and did not find it. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Benson Sent: Tuesday, February 03, 2015 4:02 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access Controlling Excel Via Windows Automation Did you (1) use late binding but nonetheless (2) left a reference to Excel? That would do it if the Excel you are using is not in the same location as the next user's. And it has happened to me. On Tue, Feb 3, 2015 at 4:14 PM, Brad Marks <bradm at blackforestltd.com> wrote: > All, > > I don't have a lot of experience with this realm but I have had some > success using Access VBA to control Excel via Automation. > > I have one Access 2007 application that creates a number of reports. > Recently I have added new VBA code to also create an Excel file. This > works nicely on my development PC that has Access 2007 and Excel 2007. > > However, I have run into some problems when trying to deploy this > application on a machine that has Access 2010 Runtime and Excel 2013. > > All of the reports work properly via Access 2010 Runtime. > > However, when I try to run the VBA code that generates the Excel file, > the application hangs up. There are no error messages. > > I am using "Late Binding". > > I am not sure where to start looking. > > Should Access 2010 Runtime work properly in conjunction with Excel 2013? > (both are 32 bit) > > Is anyone else using this combination? > > I have thought about upgrading Access Runtime from 2010 to 2013, but I > would prefer to not do this if I can resolve the current problems. > > Thanks, > 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