Hi all, my question is similar to a forum post here that was never answered:
http://p2p.wrox.com/topic.asp?TOPIC_ID=46138
I have an excel document that, via a macro, pulls in a bunch of data from multiple sources. I would like to then create a macro that pushes that data to a pre-created MS Word Form. However, I cannot seem to find any examples of this being done, and as I am a newbie when it comes to writing VBA, I have no idea how to go about this. I know I can write a macro to create the Word document and populate it with data every time, but then every time something on the form changed, I would have to change my code, even if it was not a part of the form that I was pushing data to. Can anyone help? I am merely looking for a good example, so that I can learn what to do.
Thanks!