[AccessD] UDF in Access called to Excel

Thanks Stuart.  That clears that up. I will tell him to go to Plan B instead.

Cheers
darryl

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Wednesday, 14 December 2011 2:27 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] UDF in Access called to Excel

On 14 Dec 2011 at 2:52, Darryl Collins wrote:

> 
> So, is that correct.  I would have thought the DOA would have only 
> sent the command to open the query and Access would still do all of 
> the processing?
> 

Yes, it is correct.  Access does not do the processing, the DAO/JET engine does it.   
DAO/JET doesn't know anything at all about VBA., let alone what VBA functions happen to be in the same Access container are the table.




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com