View Single Post
  #1   Report Post  
morrowkd
 
Posts: n/a
Default exporting excel worksheet to word


HI,

the paste link was working for awhile until I was told that the word
and excel cannot be linked in a "live" fashion. In other words they
should be linked to where it is possible that they may even be on
different networks and definately not in the same directory.

I want the data in word in a specific template and then from that
template I want to be able to even add things inbetween cells, while
those cells that were exported from excel are uneditable and are the
same cells that will have this link that will allow you to update in
excel and have the changes automatically changed in word.

do you get this? I know it's confusing, but if you can help in anyway
please let me know.

Thanks,
Danielle

JulieD Wrote:

JulieD Wrote:-
Hi Danielle

you could try a simple copy the data in excel, then in word choose
edit
/
paste special - and click the paste link button and then OK to create
a
link
between an excel worksheet and word.

if this doesn't give you what you want could you please explain in a
bit
more detail how (& where) the data is in excel and how & where you
want
the
data in Word.

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"morrowkd" wrote in
message
...-

Hi,

I am trying to export an excel worksheet to word, but want to be able
to allow a user to update info. in excel and it automatically updates
in word. I have been told I will need to write a macro to do this,
but
have no experience with macros or VBA.

Can anyone give me some tips or help.

Thanks,
Danielle


--
morrowkd--


--
morrowkd
[/i][/color]


--
morrowkd