Displaying Excel spreadsheets in MS Word

django · Apr 7th, 2002, 08:53 PM

I am using MS Office 97. I would like to display a spreadsheet in my Word document exactly as it appears in Excel. Every method I try results in some form of corruption - colours, formatting or clipping etc. How can I achieve this?

Mark O'Brien · Apr 7th, 2002, 08:54 PM

In Word, have you tried Insert|File then browsed to your Excel file?
...Or Insert|Object?
_________________
[b] Mark O'Brien

[ This Message was edited by: Mark O'Brien on 2002-04-07 19:57 ]

django · Apr 7th, 2002, 10:01 PM

Yes - tried that, and get formatting problems. Also tried copy/paste, and insert object/create from file with same result.

Anne Troy · Apr 7th, 2002, 10:13 PM

Paste as picture generally provides the best WYSIWYG.

Jack in the UK · Apr 8th, 2002, 05:46 PM

Hi

To add search find file sample.xls this will give VBA code to send excel to word.. desighned my Microsoft...

django · Apr 10th, 2002, 04:35 PM

Thanks Dreamboat - the paste as picture worked once I turned the "wrap" feature off. A bit clunky (thanks Bill) but it worked.

Apr 7th, 2002, 10:13 PM	#4
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Paste as picture generally provides the best WYSIWYG. __________________ ~Anne Troy

Apr 8th, 2002, 05:46 PM	#5
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi To add search find file sample.xls this will give VBA code to send excel to word.. desighned my Microsoft... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 7th, 2002, 08:53 PM	#1
django New Member Join Date: Apr 2002 Location: Australia Posts: 3	I am using MS Office 97. I would like to display a spreadsheet in my Word document exactly as it appears in Excel. Every method I try results in some form of corruption - colours, formatting or clipping etc. How can I achieve this?

Apr 7th, 2002, 08:54 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	In Word, have you tried Insert\|File then browsed to your Excel file? ...Or Insert\|Object? _________________ [b] Mark O'Brien [ This Message was edited by: Mark O'Brien on 2002-04-07 19:57 ]

Apr 7th, 2002, 10:01 PM	#3
django New Member Join Date: Apr 2002 Location: Australia Posts: 3	Yes - tried that, and get formatting problems. Also tried copy/paste, and insert object/create from file with same result.

Apr 10th, 2002, 04:35 PM	#6
django New Member Join Date: Apr 2002 Location: Australia Posts: 3	Thanks Dreamboat - the paste as picture worked once I turned the "wrap" feature off. A bit clunky (thanks Bill) but it worked.