Create RTF file in VBA to include formatting?

D

DaveO

Howdy- I searched this group for possible answers, but couldn't find
relevant hits.

My company uses an MS Excel file to collect information about labor
elements in a proposal response. Part of this process is to generate a
printable summary of that information. Excel can do the job, but I'm
sure I can do it better if I collect the data in VBA and write that
data to an RTF to open in Word.

I've written the code to generate the RTF file from Excel. My question
is: can I include commands in my code that instruct Word to use a
particular font, headers, footers, etc.? Is it possible to write Excel
VBA code to generate a .DOC file directly that would include
formatting of my choice?

Thanks,
Dave O
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create RTF file in VBA to include formatting? 1
Drop down list control value in vba 2
How can I get a Shareable URL via VBA code to a OneDrive image? 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Autonumber field in Excel that behaves the same as Access 0
Adding data to MS Access from csv file 0
XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet 7
Linking data in MS Word into Excel 5

Top