Hi all,

I am trying to input some data in word from excel. I want to know if
there is any way to erase rows from a table in word.

thanks a lot!


--
internacio
------------------------------------------------------------------------
internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727

Hi internacio,

Once you have identified where your cursor is located in your table :

Selection.SelectRow
Selection.Rows.Delete

HTH
Cheers
Carim

Thanks a lot! although still have problems!!

How can I identify from a whole document, lets say, the text "hello"??

thanks again!!!


--
internacio
------------------------------------------------------------------------
internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727

It might be a bit easier to give you some direction if we knew a little bit
more about what you are trying to do. Is the text in the Word table you
want to import into Excel? Is it the row you want to delete? It might be
easier to deal with all of this after you have it in Excel. Or it might be
easier to use Word VBA to get the data like you want it, then push it into
an Excel workbook.

Ed

"internacio" wrote
in message ...

Thanks a lot! although still have problems!!

How can I identify from a whole document, lets say, the text "hello"??

thanks again!!!


--
internacio
------------------------------------------------------------------------
internacio's Profile:
http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727

Yes, an explanation may help.

I have some data in excel and I want to create a word document. I don´t
know how many rows I would have to export since it can change depending
of the selection.

So if I select "x" I would like to export to a table in excel:

Name 1 Adress 1 Telephone 1
Name 2 Adress 2 Telephone 2
Name 3 Adress 3 Telephone 3
Name 4 Adress 4 Telephone 4

but if I select something different I would like to have 10 rows
instead of 4. I have created a template and defined a matrix inside it
as follows:


{1,1} {1,2} {1,3}
{2,1} ................
........................
{15,1} {15,2} {15,3}

and what I am doing is using find and replace from VBA Excel to change
this values to name, adress and telephone. If I have only 4 records in
my list, the rest of the values to 15 I replace them with a blank
space.

The problem is that I want to add some text after the table, and if I
add only 1 row to it, the text below it its going to be far below (like
if I had 15 rows). I want to be able to select some of the table and
delete the rows I have not used.

Hope it helps a little bit more.


--
internacio
------------------------------------------------------------------------
internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727

Need somebodys help.... :(


--
internacio
------------------------------------------------------------------------
internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727

So if I select "x" I would like to export to a table in excel:
This is a bit confusing to me. I'm assuming you want to select something,
and your selection will determine which rows you export into Word as a
table?

How were you going to determine which rows? It almost sounded like you were
going to export everything, and then try to delete the rows that you didn't
want. Would it be easier to use a sort or filter in Excel to create a
collection of only the data you want to export? Or am I missing something
here?

Ed

"internacio" wrote
in message ...

Yes, an explanation may help.

I have some data in excel and I want to create a word document. I don´t
know how many rows I would have to export since it can change depending
of the selection.

So if I select "x" I would like to export to a table in excel:

Name 1 Adress 1 Telephone 1
Name 2 Adress 2 Telephone 2
Name 3 Adress 3 Telephone 3
Name 4 Adress 4 Telephone 4

but if I select something different I would like to have 10 rows
instead of 4. I have created a template and defined a matrix inside it
as follows:


{1,1} {1,2} {1,3}
{2,1} ................
.......................
{15,1} {15,2} {15,3}

and what I am doing is using find and replace from VBA Excel to change
this values to name, adress and telephone. If I have only 4 records in
my list, the rest of the values to 15 I replace them with a blank
space.

The problem is that I want to add some text after the table, and if I
add only 1 row to it, the text below it its going to be far below (like
if I had 15 rows). I want to be able to select some of the table and
delete the rows I have not used.

Hope it helps a little bit more.


--
internacio
------------------------------------------------------------------------
internacio's Profile:
http://www.excelforum.com/member.php...o&userid=30960
View this thread: http://www.excelforum.com/showthread...hreadid=519727