Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data from an excel worksheet into an excel template | Excel Worksheet Functions | |||
Installed Word XP only, then applied Office SP3, then Excel - need 2 re-update? | Excel Discussion (Misc queries) | |||
moving excel in word back to excel | Excel Discussion (Misc queries) | |||
Convert Word Table to Excel Spreadsheet | Excel Discussion (Misc queries) | |||
getting specific info from a word document into excel | Excel Discussion (Misc queries) |