Macro help--paste unformated text

[groovesmith]

Hi,

I'm new to the site, so I searched to see if my question was already answered...if I missed the answer to this question in my search, please simply point me in the right direction...great site BTW!

I've just switched from Word 2000 to 2003 and i can't get one of my macros to work correctly...I re-recorded it but it isn't working the same in 2003 as in 2000.

I constantly have to paste text from files such as excel or web pages into Word but i want them inserted with the same text properties as are already in the document (i.e. font, size, color, without table, etc). In Word 2000, i recorded a keyboard macro (F12) that would follow the steps to do this and it pasted exactly as it was supposed to...

Here's how the keyboard set works...

record macro

Alt E for "edit" menu,

"s"(for "paste special"),

then either "page up" or "f" to get the selector ABOVE "unformatted text"

then "u" for unformatted text

enter

stop record

This format worked perfectly for me in Word 2000...not in 2003...any suggestions?

Thanks

Chad

[iltanoco]

Hi,

I'm new to the site, so I searched to see if my question was already answered...if I missed the answer to this question in my search, please simply point me in the right direction...great site BTW!

I've just switched from Word 2000 to 2003 and i can't get one of my macros to work correctly...I re-recorded it but it isn't working the same in 2003 as in 2000.

I constantly have to paste text from files such as excel or web pages into Word but i want them inserted with the same text properties as are already in the document (i.e. font, size, color, without table, etc). In Word 2000, i recorded a keyboard macro (F12) that would follow the steps to do this and it pasted exactly as it was supposed to...

Here's how the keyboard set works...

record macro

Alt E for "edit" menu,

"s"(for "paste special"),

then either "page up" or "f" to get the selector ABOVE "unformatted text"

then "u" for unformatted text

enter

stop record

This format worked perfectly for me in Word 2000...not in 2003...any suggestions?

Thanks

Chad

Hello!

I was expirienced the same problem as you, but I think that the cause is in the MS word 2003. It does not make the macros good.

Below I geve a right macros code. You can put it into you normal.dot template as a saved text file by importing to macros, or to create new macros from Tools menu , click Macros, then click create button. A visual basic editor opens witn sample code: Sub Macro() and End Sub at end of macro. You can put my code as is:

Sub Paste_Unformated_Text()

'

' PasteUnfText Macro

' Macro recorded 15.8.2003 by Ilia

'

Selection.PasteSpecial Link:=False, DataType:=wdPasteText, Placement:= _

wdInLine, DisplayAsIcon:=False

End Sub

I think this will resolve your problem. If you have any questions or problems, feel yourself freeto write me!

Kind regards,

Iliya