Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,560
Default Opening Word from Excel

How can open word and enter some simple text which is then posted back into
the cell I clicked. I work with people who are not very poatient about Excel
and want to enter text in an excel database using word
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,080
Default Opening Word from Excel

Sorry, but this seems like a terrible idea to me.

--

Vasant

"David" wrote in message
...
How can open word and enter some simple text which is then posted back

into
the cell I clicked. I work with people who are not very poatient about

Excel
and want to enter text in an excel database using word



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default Opening Word from Excel

Using Word could be done, but it would be very awkward and I don't think your
users would be terribly pleased. What would work better is a user-friendly
form set up for the data entry. If you are looking at setting up a
spreadsheet for database entry, have you tried the Data... Form... menu
option? If that will not meet your needs you could create a userform and
customize it however you like.

"David" wrote:

How can open word and enter some simple text which is then posted back into
the cell I clicked. I work with people who are not very poatient about Excel
and want to enter text in an excel database using word

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 19
Default Opening Word from Excel

hi David,

maybe you can manage this problem on this way, but unfortunatelly, i don1T
know exactly the english name of the menu and now i don't have time to set my
computer to english, but i think it can be use. So, if you choose the next
menupoints (or something similar):
data/importing data/reading data...
you can select a file to importing data. this file can be even a word
document, but sometimes only the txt files working properly.
once you have done this procedure you only have to refresh your data with
the refresh button.
--
sisco98


"David" wrote:

How can open word and enter some simple text which is then posted back into
the cell I clicked. I work with people who are not very poatient about Excel
and want to enter text in an excel database using word

  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,163
Default Opening Word from Excel

Data... Get External Data... New Database Query.
The above would be useful if the users wanted to work entirely within Word
and then you wish to import the results later. My earlier suggestion is if
you want to have the data go into Excel as soon as it is entered.

"sisco98" wrote:

hi David,

maybe you can manage this problem on this way, but unfortunatelly, i don1T
know exactly the english name of the menu and now i don't have time to set my
computer to english, but i think it can be use. So, if you choose the next
menupoints (or something similar):
data/importing data/reading data...
you can select a file to importing data. this file can be even a word
document, but sometimes only the txt files working properly.
once you have done this procedure you only have to refresh your data with
the refresh button.
--
sisco98


"David" wrote:

How can open word and enter some simple text which is then posted back into
the cell I clicked. I work with people who are not very poatient about Excel
and want to enter text in an excel database using word

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Opening a Word Template from within Excel perry Excel Discussion (Misc queries) 0 January 30th 07 12:23 PM
Opening a Word Template from within Excel perry Excel Worksheet Functions 0 January 30th 07 12:23 PM
Opening WORD from Excel Bob Reynolds[_3_] Excel Programming 1 August 4th 04 04:07 AM
Excel-Opening Word AW Excel Programming 0 April 2nd 04 09:21 AM
opening a word document from excel chris Excel Programming 5 April 1st 04 03:17 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"