View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim W. Jim W. is offline
external usenet poster
 
Posts: 1
Default Problem Importing Delimited Data from IE

I am having a problem with getting the delimited text data
from IE to the clipboard to cell "A1". I can copy all data
into a single cell. I am trying to mimic the manual
process of Selecting All on a delimited text web page,
Copy and then Pasting it into my worksheet. I have Office
2K

I have tried:
Clipboard.Clear
Clipboard.SetText ie.Document.Body.InnerText.Copy
(I got this from working VB6 code)
It fails at the first reference of the Clipboard so I
didn't show the rest.

I've tried the following also:
ie.Document.Body.InnerText
Destination:=ActiveWorkbook.Worksheets(1).Range("A 1")

Any Ideas?
Thanks,
Jim