Copying Word text to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a program that copies text from Word into Excel.

I've tried copying the text into a string and writing that into Excel;
I've tried copying the Word text into the clipboard and pasting into Excel;

Either way, the text is a mess when it comes in and I can't seem to get it
very clean. Does anyone have a function or method for doing this cleanly? Is
it even possible?

The text is not highly formatted (only some bold). Thanks much in advance
for your suggestions.
 
Try this:

dirtyStr = 'Assing this to the text from the WinWord
clnStr = Application.WorksheetFunction.Clean(dirtyStr)
Worksheets("Sheet1").Range("A1").Value = clnStr

Sharad
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA task: Copy selection in Word and paste in Excel 1
copy text from textbox to another application 3
Pasting Between Excel and Word 1
Copy excel text on a range and paste special to Word 5
Text from word to be pasted in excel 2
Good way to open a .txt file, copy/paste all text into Excel? 3
copy excel to word 8
Alt codes 4

Back
Top