View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi

a lot of the time i find that people think that they need vba / macros to
achieve things that can easily be achieved in excel natively (if i have one
more person turn up to my Excel VBA courses wanting ONLY to know how to
subtotal a range of data i will scream!) ... so you may have been given the
books by someone who didn't realise that it can be done by menu items - or
as you say, there may be more to it!

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

Thanks JulieD-
I actually did try the paste link method and yes that does work, but I
guess I don't know if that is what I need. I was just assigned this
project a couple of days ago so I don't know exactly what the end
result is suppose to be. I was given VBA and excel Macros books so I
figured this would be how to go about doing it. If I get stuck and
find out more detailed info I will post again.

Thanks for your reply !!


Danielle

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