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 |
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