I have notes in a Word Document that point to spreadsheets within an Excel
workbook.

I want to create an end of month Powerpoint Presentation as follows:

1. From an open word document, I want to use section headers to create slides.

The slide title should be the section header text.

The text in the body of the slide should be the text from the relevant
section of the Word Document.

By searching through the relevant section of the word document, if the text
on the row starts with the words Excel Link: I want it to open the Excel
file, go to the sheet and the (named) range defined in the text, copy the
data onto the Powerpoint slide, then close the Excel Workbook.

Then repeat the process for each section of the document.

Question: How do I get word to open both the powerpoint and excel
spreadsheets?

BerbatovIsGod

http://support.microsoft.com/kb/302460/en-us

--
Regards,
Tom Ogilvy



"PaxtonRoadEnd" wrote:

I have notes in a Word Document that point to spreadsheets within an Excel
workbook.

I want to create an end of month Powerpoint Presentation as follows:

1. From an open word document, I want to use section headers to create slides.

The slide title should be the section header text.

The text in the body of the slide should be the text from the relevant
section of the Word Document.

By searching through the relevant section of the word document, if the text
on the row starts with the words Excel Link: I want it to open the Excel
file, go to the sheet and the (named) range defined in the text, copy the
data onto the Powerpoint slide, then close the Excel Workbook.

Then repeat the process for each section of the document.

Question: How do I get word to open both the powerpoint and excel
spreadsheets?

BerbatovIsGod

Thanks, just the job.
--
BerbatovIsGod


"Tom Ogilvy" wrote:

http://support.microsoft.com/kb/302460/en-us

--
Regards,
Tom Ogilvy



"PaxtonRoadEnd" wrote:

I have notes in a Word Document that point to spreadsheets within an Excel
workbook.

I want to create an end of month Powerpoint Presentation as follows:

1. From an open word document, I want to use section headers to create slides.

The slide title should be the section header text.

The text in the body of the slide should be the text from the relevant
section of the Word Document.

By searching through the relevant section of the word document, if the text
on the row starts with the words Excel Link: I want it to open the Excel
file, go to the sheet and the (named) range defined in the text, copy the
data onto the Powerpoint slide, then close the Excel Workbook.

Then repeat the process for each section of the document.

Question: How do I get word to open both the powerpoint and excel
spreadsheets?

BerbatovIsGod