View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JingleRock[_2_] JingleRock[_2_] is offline
external usenet poster
 
Posts: 45
Default XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet

On Nov 12, 7:35*pm, JingleRock wrote:
I get a new .rtf file on a weekly basis; the format is exactly the
same in each. I want to copy/paste three adjacent 8-digit numbers,
using VBA, (each is in a different "cell", as far as doing a manual
copy/paste from the .rtf file to a spreadsheet is concerned) from
each .rtf file to a spreadsheet.

Is it necessary to open the Word .rtf file using XCL VBA? How is it
possible to refer to the locations of the three adjacent 8-digit
numbers?


I now see that the three numbers I want to copy/paste are three cells
in a 4x5 table in my .rtf file.