Pavi S

Pavi S

  • NA
  • 41
  • 74.6k

Reading from Excel & Writing to Word using Macro (VBA)

Mar 3 2013 10:40 PM

Reading from Excel & Writing to Word using Macro VBA


I want to read the data from the excel and want to create word file and need fetch the data frequently.
Excel contain data like this

A1      B1
0100   Urban systems(4325)
0500   Ponds

Need to write like this in the word

[0100]
Data= Urban systems
Year= 4325

[0500]
Data= Ponds


Please any one help me to solve this im very new to Vba.