[AccessD] Importing from Excel

Gustav Brock Gustav at cactus.dk
Fri Jul 27 06:12:35 CDT 2007


Hi Thomas

You can open Excel from Access and run a series of Excel "macros" (VBA functions in Excel).
Look up an intro here:

  http://databaseadvisors.com/mailman/htdig/accessd/2003-March/002956.html 

/gustav

>>> ewaldt at gdls.com 26-07-2007 22:58 >>>
Thanks, Mark (and others). That's close. What I want to know is how to 
apply Excel-oriented code to Excel from within Access. Is that what your 
code does? It looks like it does, since it references Excel objects like 
workbooks, cells, etc. I'll try putting my code into your context. 

Thanks, again.

Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems






More information about the AccessD mailing list