Adarsh
01-27-2016, 01:53 AM
Hello everyone,
I am a novice to VBA and am trying to make a code in VBA, which can take 3 values from different columns in an Excel file and fill it up in a sentence in a Word file. And I wish this Loop to continue and make the same sentence and fill it up as many number of times as the number of data sets filled in the Excel file.
I would be really grateful if someone could suggest how to start and go with achieving it or give the code straightway ! Thanks in advance.
Example >
Excel file
A B C ----Columns --
1 5 9 ----Values --
2 7 3
3 8 4
Word file
Position of Point (value from column A) is X (value from column B) Y(value from column A)
>>>>>Required Output<<<<<<
Position of Point 1 is X 5 Y 9
Position of Point 2 is X 7 Y 3
Position of Point 3 is X 8 Y 4
I am a novice to VBA and am trying to make a code in VBA, which can take 3 values from different columns in an Excel file and fill it up in a sentence in a Word file. And I wish this Loop to continue and make the same sentence and fill it up as many number of times as the number of data sets filled in the Excel file.
I would be really grateful if someone could suggest how to start and go with achieving it or give the code straightway ! Thanks in advance.
Example >
Excel file
A B C ----Columns --
1 5 9 ----Values --
2 7 3
3 8 4
Word file
Position of Point (value from column A) is X (value from column B) Y(value from column A)
>>>>>Required Output<<<<<<
Position of Point 1 is X 5 Y 9
Position of Point 2 is X 7 Y 3
Position of Point 3 is X 8 Y 4