Neodubois
05-15-2014, 03:07 AM
Hello,
I have searched the forum and haven't found any identical thread.
I also tried to record this but all actions outside Excel are not recorded
I am using Excel and Word 2013.
I have a word document in a specific folder which I use as a template.
I have a Excel file and one of the tabs named "final information" contains the data I want to use in columns A and B, the number of rows is different every time.
I would likte to use a macro which would
1. open the word template
2. replace in 3 places in the word document data from colum C from Excel
3. "save as" the word document in a specific folder : the name should contain:
a. "INT." : followed by a 3 digit number starting at 1 example INT.001 for the first document INT.002 for the second one and so on
b. "INT.001" should be followed by a space than a "-" than a space than the data in column A1 followed by a space than a "-" than a space than the data in column for the first document from the Excel file
example INT.001 - red - table
4. save and close the word document created
5. start over unless the data in the next row of the Excel is empty. And of course us the Excel data from the next row and so on
example : doc 1 would be INT.001 - data A1 - data B1
doc 2 would be INT.002 - data A2 - data B2
I hope my request is clear and easy to understand and hope you will be able to help me out :)
Thank you
I have searched the forum and haven't found any identical thread.
I also tried to record this but all actions outside Excel are not recorded
I am using Excel and Word 2013.
I have a word document in a specific folder which I use as a template.
I have a Excel file and one of the tabs named "final information" contains the data I want to use in columns A and B, the number of rows is different every time.
I would likte to use a macro which would
1. open the word template
2. replace in 3 places in the word document data from colum C from Excel
3. "save as" the word document in a specific folder : the name should contain:
a. "INT." : followed by a 3 digit number starting at 1 example INT.001 for the first document INT.002 for the second one and so on
b. "INT.001" should be followed by a space than a "-" than a space than the data in column A1 followed by a space than a "-" than a space than the data in column for the first document from the Excel file
example INT.001 - red - table
4. save and close the word document created
5. start over unless the data in the next row of the Excel is empty. And of course us the Excel data from the next row and so on
example : doc 1 would be INT.001 - data A1 - data B1
doc 2 would be INT.002 - data A2 - data B2
I hope my request is clear and easy to understand and hope you will be able to help me out :)
Thank you