Hello,
I am assigned the task at work to transfer the data from the excel documents into the word document for the final proposals. We have been doing this without a VBA Code, this is quite time consuming process. The clearest way we found to transfer the data from excel is by in the word document, under insert tab, selecting object, then create from file, and select the excel file. From this we typically scale down the Object and get the clearest results. What I am asking is if anyone has written a Code to do this process for them Or has any idea how to start the code.
Thank you,
KT
I am assigned the task at work to transfer the data from the excel documents into the word document for the final proposals. We have been doing this without a VBA Code, this is quite time consuming process. The clearest way we found to transfer the data from excel is by in the word document, under insert tab, selecting object, then create from file, and select the excel file. From this we typically scale down the Object and get the clearest results. What I am asking is if anyone has written a Code to do this process for them Or has any idea how to start the code.
Thank you,
KT