Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy information from Excel to Word using 1 macro
Is there a way to copy information from Excel to Word without having to
format it? For example, I have a list of clients and each has an address. The data is in Excel. The user goes to an Excel spreadsheet and selects the client from a pick list and the data comes up for them. They then go to Word and paste the data. I need to create a macro that will copy the data for them to the clipboard, got this part in Excel, and then when the user hits the paste button in Word the data will be pasted unformatted at the curser location. To better understand what I need here is the menu progression in Word: Edit PASTE Special Unformatted Text In VB from the Macros Recorder its: Selection.PasteSpecial Link:=False, DataType:=wdPasteText, Placement:= _ wdInLine, DisplayAsIcon:=False Can these Macros be combined into 1 Macros? Can this be done? If so any help would be appreciated!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel copy cells to word template | New Users to Excel | |||
Copy and paste Excel chart in Word -- font compresses | Charts and Charting in Excel | |||
copy from Excel to word by macro with certain format | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) | |||
Excel macro that opens new MS Word file and pastes data as a pictu | Excel Worksheet Functions |