[AccessD] Access Controlling Excel Via Windows Automation

Brad Marks bradm at blackforestltd.com
Wed Feb 4 09:14:06 CST 2015


All,

I just ran a test of the Access application that creates an Excel file on a PC that has Access 2013 and Excel 2013.  It worked perfectly.

However, when I run the same application on the machine that has Access 2010 Runtime and Excel 2013, the application gets hung up.  There is no error message.

I have rebooted this machine and this did not make any difference.

I thought that Access 2010 Runtime would play nicely with Excel 2013, but for some reason this appears to not be the case.

I am open to any ideas.

Thanks,
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



More information about the AccessD mailing list