Hi
Rathey than simply copy paste is there anything in Excel similar to MS Access?
In MS Access if you highlight a table.
Then the Menu bar the office links gives you the option to -
-Merge it with Microsoft Word
-Publish it with Microsoft Word
-Analyse it with Microsoft Excel
The second option is a very neat way to get Excel into Word
Thanks
Jay
From Publisher 2003 Help.............
Export text
Although you cannot export directly from Microsoft Publisher, you can cut and
paste all or part of the text in a publication to a document in another
application. You can also save the publication in a different file format to
use in the other application.
On the File menu, click Save As.
In the File name box, type a name for the text.
In the Save as type box, click the file format used by the other program.
If you don't know the format, click either Rich Text Format or Plain Text.
Click Save.
Open the program and document to which you want to add the text.
Add the text you've saved by using the Insert Text, Import Text, Insert File,
or Open command of the program.
..............................
Unfortunately, Excel is not one of the file formats so go with the copy and
paste or save as a *.txt file and open that with Excel.Gord Dibben Excel MVP
On Fri, 23 Dec 2005 01:32:02 -0800, Jay gt; wrote:
gt;Hi
gt;
gt;Rathey than simply copy paste is there anything in Excel similar to MS Access?
gt;
gt;In MS Access if you highlight a table.
gt;Then the Menu bar the office links gives you the option to -
gt;-Merge it with Microsoft Word
gt;-Publish it with Microsoft Word
gt;-Analyse it with Microsoft Excel
gt;
gt;The second option is a very neat way to get Excel into Word
gt;
gt;Thanks
gt;
gt;Jay
- Sep 10 Mon 2007 20:39
From Ms Excel can you directly publish with Ms Word
close
全站熱搜
留言列表
發表留言