I am using an excel sheet to keep track of the finances of my afterschool program. Each week I am creating an invoice for the families that have a different balance, outputing from the excel file to a new word file. Everything works except I was wondering if it is possible to format the output within or before the Print # statement. Just typically word formatting things like size, font, underline and what not. If not, is there an alternative solution that I could use?
I am not entirely new to programming, but am new to VB. I have found answers to all of my other syntax type issues on the web or through the VB help, but had no luck with this problem.
Sample:
'Find the number of C sessions attended
a = Sheets(Week_of).Range("P" & x).Value
'Print C Session # and associated cost
Print #1, a; " Session C (PM) @ $6.00"; Tab(40); "$"; a * 6
I would like to change the font size of the whole print statement as well as underline the a and a * 6 value.
Thanks for your help,
z