VBA Export Data as Text from Excel to Word
Hi,
I am kind of new to VBA, especially Word. I was wondering if it would be possible to create a macro that could take a report from excel and insert that information directly into word? The information is numerical, dates, and words with some of the numerical information needing to be summed. The rows are also variable in that each subset has a different amount of rows associated with it (if that makes sense). I was also wondering if it would be possible to create a popup screen where I can type in the code that I am wanting so it will only populate that codes information into the word document. The word document is a report that doesn't change (it's a template), and I have already put bookmarks into the word document. Please let me know if this is possible or if more information is needed or if a sample would help!! This is a very manual process to copy and paste the information from excel to word, and would be helpful to have in my work place. Any help would be greatly appreciated!!
Thank you
|