Hello All,
I'm currently working on a coding that takes information from an excel spreadsheet and fills out a word document. I have set is up that the information is entered into field. My situation is that there are is a field on a line in the document that depending on variable in spreadsheet would be delete the entire line on the sheet. The code i use to enter the information is the following:
Wordapp.ActiveDocument.FormFields("TXPerfAmount").Result = Format(PerfCash, "Currency")
I'm currently working on a coding that takes information from an excel spreadsheet and fills out a word document. I have set is up that the information is entered into field. My situation is that there are is a field on a line in the document that depending on variable in spreadsheet would be delete the entire line on the sheet. The code i use to enter the information is the following:
Wordapp.ActiveDocument.FormFields("TXPerfAmount").Result = Format(PerfCash, "Currency")