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.
|