[AccessD] Importing from Excel

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


Message: 17
Date: Thu, 26 Jul 2007 20:18:14 +0000
From: "Mark A Matte" <markamatte at hotmail.com>
Subject: Re: [AccessD] Importing from Excel
To: accessd at databaseadvisors.com
Message-ID: <BAY127-F259E8DF7777806A2818258D2F20 at phx.gbl>
Content-Type: text/plain; format=flowed

I'm not sure exactly what you are asking...but #2 sounds like you want to 
do 
some formatting?  If so...below is some code I use to format a spreadsheet 

(from within Access), that is actually created from an exported Access 
report.  If I missed the point...sorry, let me know and I'll try again.

Good Luck,

Mark A. Matte
P.S...the formatting is based on a recordset within the db.

[Code here]


This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.