The issue arrises, when a user clicks on the command button inside the .xls to create the word document...Whats happening is, Im trying to tell certain lines to bold when the word document gets created, such as: (in the Excel sheet, Module 1, you will find)
"Sale File #: " & wks.Cells(ActiveCell.Row, 9) & vbNewLine & _
I change that to something like
"Sale File #: " & wks.Cells(ActiveCell.Row, 9) & (ActiveCell.Row.Font.Bold) & vbNewLine & _
Thereby when the macro is excuted inside the .xls sheet it should make the text "Sale File #" bold in the word document...
However - Im not getting any errors when changing the VBA, the problem arrises when the Word Document gets created, because the particular text I want bold, is not bolding in the word document...
Does that make a bit more sense?
Let me know if it doesn't, I can explain some more.