Previous Thread

6/15/2006 1:05:02 PM    Excel and Access
Hi Everyone, I'm pretty new to using both XLS and Access, I'm required to do 
 
some reports for work and I've been using both XLS and Acces, is it possible 
 
to do all the functions in XLS in Access? Including custom functions I've 
 
created for XLS? 
 
TIA,



6/15/2006 2:25:43 PM    Re: Excel and Access
On Thu, 15 Jun 2006 13:05:02 -0700, Mike 
 
<Mike@discussions.microsoft.com> wrote: 
 
Yes, with some major caveats. You will need to use Tools... References 
 
in the VBA editor to include the Excel program library in your VBA 
 
references. 
 
Note that Access *is not a spreadsheet program* and many Excel 
 
functions simply aren't applicable. You don't have "rows, columns, and 
 
cells" - you have records, fields, and values. They may look similar 
 
but the structure is quite different! 
 
John W. Vinson[MVP]