Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

txt and Bold

Status
Not open for further replies.

jshanoo

Programmer
Apr 2, 2002
287
IN
Hi,
I have txt files generate by the application, but i need a particular line in the txt to be bold, so that when sent by email. It should be received and he can view it in bold text.


Regards
John philip

*** Even the Best, did the Bad and Made the Best ***

John Philip
 
Here is how it goes:

open Excel file
Tools/Macros/Record New Macro/OK

Now go
Right Click on Normal text/Format Cells/Font/Bold

Now Go
Tools/Macro/Macros/Edit

Range("A1").Select
With Selection.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 10
.Strikethrough = False
.Superscript = False
.Subscript = False
.OutlineFont = False
.Shadow = False
.Underline = xlUnderlineStyleNone
.ColorIndex = xlAutomatic
End With
End Sub

Worked ? I hope

TIA
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top