Adjusting Font for Different Sections of Same Paragraph - Excel VBA -

-

i feeding data word doc excel via vba. want format following.

1. service ticket# 452345: lorem ipsum dolor sit amet, consectetur adipiscing elit, sed eiusmod tempor incididunt ut labore et dolore magna aliqua.

the service ticket part bold , italicized , description italicized only. service ticket number , description come different cells in excel.

here's code:

'' bookmark inserting data. wdapp.selection.goto what:=-1, name:="service_ticket_comments"  dim integer dim serviceticket string  = 4 shaudittrail.range("a4").end(xldown).row       '' pulling comments comments column.     if not isempty(cells(i, 11))            serviceticket = "service ticket #" & cells(i, 1)            wdapp.selection.typetext "service ticket #" & cells(i, 1)           wdapp.selection.font.bold = true           wdapp.selection.font.italic = true             wdapp.selection.typetext " - " & cells(i, 11) & chr(10) & chr(10)           wdapp.selection.font.italic = true     end if  next

this makes service ticket part , description bold , italized because selection applied whole piece. how keep first part bold , italicized , other part bold?

don't work selection, instead, work range, same in excel.

it's not clear selection in target word document comes from, have no choice in using starting point. you'd use technique if target chosen user...

dim rng word.range set rng = wdapp.selection.range rng.text = serviceticket rng.font.bold = true rng.font.italic = true rng.collapse wdcollapseend rng.text = cells(i,11) & vbcr rng.font.bold = false rng.font.italic = true

note: should create / use character styles formatting, rather applying formatting directly. results in more efficent code , more manageable document.


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more