I have an Excel sheet that will have different information on the sheet everytime I open the file. Ex: Saving Excel sheet and overwriting file .

I have a macro that goes into the Excel Sheet and auto arranges the cells in an order that I can read the information more clearly...stacked rather than all in one row.

I need to export certain cell values over to a Word 2007 doc file for further use (auto populate a template letter).

What I am wanting to know is the first step in the many steps needed and I may be able to figure it out from there.

Let's say that I have a macro on the Excel sheet that will always be there...how can code the macro to create a textbox and input the value of cell A1 into the textbox after it's creation?

Thanks