Hi, I have an excel spreadsheet, on which I have 'Shown comments'. This
sheet is part of a training manual so i need to cut and paste various
sections of this excel sheet into Word, in order to explain it. However, I
would like small sections in word, to match the actual excel sheet and would
thus like the comments from the excel sheet to show in the Word document so
both look the same.
i know how to add seperate comments in word, but they appear at the right of
the document and are not as clear to read as the Excel ones that relate to a
cell. Is there any way of showing comments as well when you export from
Excel to Word

You may want to cature the screen image. Press in Excel "Cntrl - Print
Screen ". Then paste in word. You can use Crop Picture to just view the
area in excel you want. Before the Print Screen you can change the viewing
size from 100% to 200% or 400% to see a larger area or go smaller. You can
also in word scale the picture to what ever size you need.

"Ali" wrote:

Hi, I have an excel spreadsheet, on which I have 'Shown comments'. This
sheet is part of a training manual so i need to cut and paste various
sections of this excel sheet into Word, in order to explain it. However, I
would like small sections in word, to match the actual excel sheet and would
thus like the comments from the excel sheet to show in the Word document so
both look the same.
i know how to add seperate comments in word, but they appear at the right of
the document and are not as clear to read as the Excel ones that relate to a
cell. Is there any way of showing comments as well when you export from
Excel to Word

You also may want to view the comments all the time by changing the following
option

Menu Tools - Options - View - "Comment and Indicator" (not indicator only)

"Ali" wrote:

Hi, I have an excel spreadsheet, on which I have 'Shown comments'. This
sheet is part of a training manual so i need to cut and paste various
sections of this excel sheet into Word, in order to explain it. However, I
would like small sections in word, to match the actual excel sheet and would
thus like the comments from the excel sheet to show in the Word document so
both look the same.
i know how to add seperate comments in word, but they appear at the right of
the document and are not as clear to read as the Excel ones that relate to a
cell. Is there any way of showing comments as well when you export from
Excel to Word

Maybe you want to look at Debra Dalgleish's site:
http://contextures.com/xlcomments03.html#CopyToWord

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Ali wrote:

Hi, I have an excel spreadsheet, on which I have 'Shown comments'. This
sheet is part of a training manual so i need to cut and paste various
sections of this excel sheet into Word, in order to explain it. However, I
would like small sections in word, to match the actual excel sheet and would
thus like the comments from the excel sheet to show in the Word document so
both look the same.
i know how to add seperate comments in word, but they appear at the right of
the document and are not as clear to read as the Excel ones that relate to a
cell. Is there any way of showing comments as well when you export from
Excel to Word

--

Dave Peterson

Thanks Joel you are a wizz, this is exactly what i needed.

"Joel" wrote:

You may want to cature the screen image. Press in Excel "Cntrl - Print
Screen ". Then paste in word. You can use Crop Picture to just view the
area in excel you want. Before the Print Screen you can change the viewing
size from 100% to 200% or 400% to see a larger area or go smaller. You can
also in word scale the picture to what ever size you need.

"Ali" wrote:

Hi, I have an excel spreadsheet, on which I have 'Shown comments'. This
sheet is part of a training manual so i need to cut and paste various
sections of this excel sheet into Word, in order to explain it. However, I
would like small sections in word, to match the actual excel sheet and would
thus like the comments from the excel sheet to show in the Word document so
both look the same.
i know how to add seperate comments in word, but they appear at the right of
the document and are not as clear to read as the Excel ones that relate to a
cell. Is there any way of showing comments as well when you export from
Excel to Word