ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Links and Linking in Excel (https://www.excelbanter.com/links-linking-excel/)
-   -   exporting excel worksheet to word (https://www.excelbanter.com/links-linking-excel/25020-exporting-excel-worksheet-word.html)

morrowkd

exporting excel worksheet to word
 

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

JulieD

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





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com