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

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more