[AccessD] Excel Import

Sorry, I was out for the week. Here is the secret to using dynamic ranges.
HTH
Jim Hale
http://www.ozgrid.com/Excel/DynamicRanges.htm

-----Original Message-----
From: McGillivray, Don [IT] [mailto:Donald.A.McGillivray at sprint.com]
Sent: Monday, November 20, 2006 5:31 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Excel Import


True, but the inserted rows need to be ABOVE the last row in the existing
range in order for this to work, no?  Not such a big deal if you're adding a
row or two, but when adding large blocks of data, it can be a pain to insert
exactly (or slightly more than) the number or rows you want before adding
the data.  You definitely don't want to insert fewer than you will need.

I seem to remember somebody (Gustav?) posting some code a few months back
that managed the dynamic expansion of a named range in Excel.  Don't
remember how it worked, or anything else about it, but it looked like a
useful thing for situations like this.  Does that ring a bell with anybody
else?

Don

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, November 20, 2006 3:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Excel Import

If you insert a new row at the bottom of the range, you don't have to
redefine the range -- Excel does it for you automatically. You could come up
with a macro that does the work for you. I swear, I wrote about that, but
I'd never find it now. But, here's how it would go -- you'd enter a record,
press Ctrl+I or some other keyboard hot key combination to imitate a macro
that would insert a new row at the bottom of the range and position your
cursor at the first cell in the new row -- that way, Excel is constantly
extending the range. 

Susan H. 

Thanks.  This worked.  Although, for an ongoing process...I can just see me
forgetting to re-define my range...and not uploading all the proper data.
:(  For now, however...this worked.  :)


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


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

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.