Get and manipulate data from cells [WiredBox.Net

Group: Microsoft Access » microsoft.public.access.macros
Thread: Get and manipulate data from cells

Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10

Get and manipulate data from cells

Nina 06.07.2006 16:51:02

I am importing information into Excel from another program in the form of two
columns, one with strings and one with numbers. Basically I want to read the
contents of each cell in the column with strings, assign the first character
of the string to a variable, and test this variable against the letter "A".
If the it doesn't start with A I want to delete the row. Here is a summary:

For Loop to go through all the rows in column 3
Get string from active cell
Assign first character of string to a variable
IF variable != 'A'
delete row and shift up

For example: the active cell reads "L1". I want to a variable that is
assigned to 'L' and test it against the character 'A'. Obviously they're not
the same so now I need to delete the row.

The For loop is another problem. The number of rows is not set so it changes
with every set of info I import into Excel. How do I determine the upper
bound for the loop? Any help would be wonderful. Thanks!

Re: Get and manipulate data from cells

"Joseph R. Pottschmidt" <me[ at ]joepottschmidt.com> 06.07.2006 17:46:53

This is a multi-part message in MIME format.

------=_NextPart_000_0022_01C6A0E9.7EC74310
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Dear Nina:

Is this an operation that you're trying to import into MS Access or
Import in MS Excel?

This forum is for MS Access questions.

If you're trying to do this in MS Access, you would simply link the MS
Excel Sheet to MS Access and then use an Append Query to filter out all
the unwanted rows.

Joe P.

-----Original Message-----
From: Nina [mailto:Nina[ at ]discussions.microsoft.com]
Posted At: Thursday, July 06, 2006 9:51 AM
Posted To: microsoft.public.access.macros
Conversation: Get and manipulate data from cells
Subject: Get and manipulate data from cells

I am importing information into Excel from another program in the form
of two
columns, one with strings and one with numbers. Basically I want to read
the
contents of each cell in the column with strings, assign the first
character
of the string to a variable, and test this variable against the letter
"A".
If the it doesn't start with A I want to delete the row. Here is a
summary:

For Loop to go through all the rows in column 3
Get string from active cell
Assign first character of string to a variable
IF variable != 'A'
delete row and shift up

For example: the active cell reads "L1". I want to a variable that is
assigned to 'L' and test it against the character 'A'. Obviously they're
not
the same so now I need to delete the row.

The For loop is another problem. The number of rows is not set so it
changes
with every set of info I import into Excel. How do I determine the upper

bound for the loop? Any help would be wonderful. Thanks!

------=_NextPart_000_0022_01C6A0E9.7EC74310
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7036.0">
<TITLE>Re: Get and manipulate data from cells</TITLE>
</HEAD>
<BODY>


Dear Nina:


Is this an operation that you're trying to import into =
MS Access or Import in MS Excel?


This forum is for MS Access questions.


If you're trying to do this in MS Access, you would =
simply link the MS Excel Sheet to MS Access and then use an Append Query =
to filter out all the unwanted rows.

Joe P.

 

-----Original Message-----

 From: Nina [<A =
HREF=3D"mailto:Nina[ at ]discussions.microsoft.com">mailto:Nina[ at ]discussions.mi=
crosoft.com</A>] 

 Posted At: Thursday, July 06, 2006 9:51 AM

 Posted To: microsoft.public.access.macros

 Conversation: Get and manipulate data from =
cells

 Subject: Get and manipulate data from cells


I am importing information into Excel from another =
program in the form of two 

 columns, one with strings and one with numbers. =
Basically I want to read the 

 contents of each cell in the column with strings, =
assign the first character 

 of the string to a variable, and test this variable =
against the letter "A". 

 If the it doesn't start with A I want to delete the =
row. Here is a summary:


For Loop to go through all the rows in column 3 =


 Get string from active cell

 Assign first character of string to a =
variable

 IF variable !=3D 'A'

 delete row and shift =
up

 

For example: the active cell reads "L1". I =
want to a variable that is 

 assigned to 'L' and test it against the character =
'A'. Obviously they're not 

 the same so now I need to delete the row.


The For loop is another problem. The number of rows is =
not set so it changes 

 with every set of info I import into Excel. How do I =
determine the upper 

 bound for the loop? Any help would be wonderful. =
Thanks!


</BODY>
</HTML>
------=_NextPart_000_0022_01C6A0E9.7EC74310--

Home | Search | Terms | Imprint | Contact

Newsgroups Reader - provided by WiredBox.Net