C
Culichi
Greetings--
I'm relatively new at this VBA thing, but have recently had some
moderate success writing a program to do some things within a Word file.
Now, I would like to figure out how to get information that is indexed
in an Excel file to copy/paste some of this information into an
appropriate place in a Word file. I'm working with Office XP versions of
both.
Specifically, I am doing research with news articles I have pulled off
of CDs. I can save an index of all titles, dates, etc., for each article
in an Excel spreadsheet, and I can save each article appended into a
single Word file. The odd thing is that the full-text articles don't
contain the dates for the article (!!!). I need to get this into the
Word file from Excel. I'd also like to give each one an ID number that I
create in Excel. So, I want to (a) select the title from a cell in
Excel, (b) search for this title in Word, (c) paste the date/ID that is
adjacent to the title cell into Word at the appropriate place, and (d)
do this for the whole set of titles (1500-2200 per file, 50-60 files).
My request is this: Does anyone have a basic procedure that does
ANYTHING like this that they might share with me so that I can get some
idea how to make the two programs talk to each other (I'm not yet very
familar with all the "Excel Objects" terminology) and learn how to do it
myself by adapting the code to my situation? I'm not looking for someone
to provide some free work for me; just a little help getting started.
Thanks for taking the time to read this.
Kelley
I'm relatively new at this VBA thing, but have recently had some
moderate success writing a program to do some things within a Word file.
Now, I would like to figure out how to get information that is indexed
in an Excel file to copy/paste some of this information into an
appropriate place in a Word file. I'm working with Office XP versions of
both.
Specifically, I am doing research with news articles I have pulled off
of CDs. I can save an index of all titles, dates, etc., for each article
in an Excel spreadsheet, and I can save each article appended into a
single Word file. The odd thing is that the full-text articles don't
contain the dates for the article (!!!). I need to get this into the
Word file from Excel. I'd also like to give each one an ID number that I
create in Excel. So, I want to (a) select the title from a cell in
Excel, (b) search for this title in Word, (c) paste the date/ID that is
adjacent to the title cell into Word at the appropriate place, and (d)
do this for the whole set of titles (1500-2200 per file, 50-60 files).
My request is this: Does anyone have a basic procedure that does
ANYTHING like this that they might share with me so that I can get some
idea how to make the two programs talk to each other (I'm not yet very
familar with all the "Excel Objects" terminology) and learn how to do it
myself by adapting the code to my situation? I'm not looking for someone
to provide some free work for me; just a little help getting started.
Thanks for taking the time to read this.
Kelley