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/24892-exporting-excel-worksheet-word.html)

morrowkd

exporting excel worksheet to word
 

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

JulieD

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





All times are GMT +1. The time now is 01:48 AM.

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