hello,

i have a huge problem - i want to copy a text from a word file into an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the cell,
but then the text is not formated.

can anybody help me?

If you paste all the text one cell, you will lose the formatting.
If you paste over multiple cells, formatting will remain.
Choose which.

There are ways to format the text within a cell (using .Characters), but you
will have to check each char in Word for bold, colour etc, then apply that
to the character in the cell.

NickHK

wrote in message
oups.com...
hello,

i have a huge problem - i want to copy a text from a word file into an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the cell,
but then the text is not formated.

can anybody help me?

You can get all the text in one box by selecting cell and then pasting in the
F(x) box at top of worksheet. I don't know what format will be retained. I
think the CR/LF will be kept.

" wrote:

hello,

i have a huge problem - i want to copy a text from a word file into an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the cell,
but then the text is not formated.

can anybody help me?

On 29 Mrz., 12:33, "NickHK" wrote:
If you paste all the text one cell, you will lose the formatting.
If you paste over multiple cells, formatting will remain.
Choose which.

There are ways to format the text within a cell (using .Characters), but you
will have to check each char in Word for bold, colour etc, then apply that
to the character in the cell.

NickHK

wrote in message

oups.com...

hello,

i have a huge problem - i want to copy a text from a word file into an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the cell,
but then the text is not formated.

can anybody help me?


okay, this is very complex. could you tell me, how I should do this? I
do not know how to check each character and how I paste this into the
cell.

On 29 Mrz., 14:58, wrote:
On 29 Mrz., 12:33, "NickHK" wrote:



If you paste all the text one cell, you will lose the formatting.
If you paste over multiple cells, formatting will remain.
Choose which.

There are ways to format the text within a cell (using .Characters), but you
will have to check each char in Word for bold, colour etc, then apply that
to the character in the cell.

NickHK

wrote in message

roups.com...

hello,

i have a huge problem - i want to copy a text from a word file into an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the cell,
but then the text is not formated.

can anybody help me?

okay, this is very complex. could you tell me, how I should do this? I
do not know how to check each character and how I paste this into the
cell.

and very important is the numbering and bullets. how can I check this?

Personally, what you are asking is to make Excel work as a word processor.
If you need that functionality use Word.
You can embed a Word document in Excel, InsertObject...

NickHK

wrote in message
oups.com...
On 29 Mrz., 14:58, wrote:
On 29 Mrz., 12:33, "NickHK" wrote:



If you paste all the text one cell, you will lose the formatting.
If you paste over multiple cells, formatting will remain.
Choose which.

There are ways to format the text within a cell (using .Characters),
but you
will have to check each char in Word for bold, colour etc, then apply
that
to the character in the cell.

NickHK

wrote in message

roups.com...

hello,

i have a huge problem - i want to copy a text from a word file into
an
excel sheet in one cell, but when i try to paste the text with vba,
the text is pasted over more than one cell. i have tried to save the
text in a string first and after that i pasted the text into the
cell,
but then the text is not formated.

can anybody help me?

okay, this is very complex. could you tell me, how I should do this? I
do not know how to check each character and how I paste this into the
cell.

and very important is the numbering and bullets. how can I check this?