-=> Quoting Christopher Greaves to Thom Kirby <=-
 
 Hello Christopher,
 
 TK>     Where I work I've written a somewhat complex database in Access.  
This
 TK>database was to replace what the people were doing in Excel.  I'm sure 
'm
 TK>going to have a hard time getting everyone where I work to switch to my
       Well it is truly a matter of *design!
 CG> I don't have a solution for the implementation problem you 
 
       There's always a best fit approach but here are some roadside
       pointers.....
       Add or ammend a module in ACCESS v2.0 that will.......
' =Set= 
* Object variable declarations 
       Application 
       Workbook 
       Sheet(s)
' =Specify= 
*Statements and expressions that will operate on the Excel Objects...   
       Set sheet = GetObject("name.xls", "Excel.sheet")
       
* for one Cell of a range
       wksWorksheet.Range(strRangeName).Cells(intRow, intCol)
Wow! 8:00..... Gotta run......
You can get more info. from VBA HELP
Have fun!
_____________
  | [] |] |]
Todd R. Ewell, SysOp
zzzzzzzzzzzzzzzzzzzzzzz
The InterSection BBSys.
209.227.0932 (28.8 V34/Fax)
ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ
> fidonet 1:205/12___________________________From fidonet
> 
>  [Coming Soon]
>
>           http://www.psnw.com/~asv ______ 
>                  Home to 
>     the 
>                TWENTY-QUESTION 
>       WWW Real Property Promotional Solution
>       -> Business * Web/Internet Services
>       -> HyperLinks of all kinds 
>
>               INQUIRIES:
>      Internet: asv@psnw.com
*________________________________________________
  * Registered! The Blue Wave Offline Mail Reader| ... How long will a 
floating point operation float?
___ Blue Wave/QWK v2.20
--- InterEcho 1.18
---------------