Excel VBA Paste Special

Question

I am trying to eliminate a manual process that a user is doing. They have a VBA Button that when clicked will parse the text on the sheet to another sheet.

The procedure goes:
1. Copy Contents from HTML Site
2. Paste contents from clipboard as "PASTE SPECIAL" text only to Excel Sheet
3. Click button

They are doing this hundred of times a day and they requested if they can only do step 1 and step 3.

What I needed to do is replicate the Paste Special "TEXT" into that sheet, is this possible?

Answer 1

Entirely possible. Its just a case of using .PasteSpecial Format:="Text"

http://msdn.microsoft.com/en-us/library/office/ff839476(v=office.15).aspx