Search found 5 matches

by aaabbbccc180
05 Dec 2021, 13:01
Forum: Ask for Help (v1)
Topic: Deleting all of a style in word
Replies: 0
Views: 384

Deleting all of a style in word

Hi all, Looking to delete all instances of a style in a word document. The basic function is easy enough to implement in VBA, by simply finding one instance of the style, using WordBasic to select similar formatting, and then deleting the selection: Sub SelectAllAnalytics() ' ' SelectAllAnalytics Ma...
by aaabbbccc180
30 Nov 2021, 14:06
Forum: Ask for Help (v1)
Topic: How to organize data from excel in word using headers? Topic is solved
Replies: 7
Views: 743

Re: How to organize data from excel in word using headers? Topic is solved

Awesome - here's the final version. ^`:: ; when Control + ` is pressed xl := comobjactive("excel.application") oword := comobjactive("word.application") Send ^{Enter} ; exit edit mode for c in xl.range(xl.ActiveCell.Address, xl.ActiveCell.Offset(200, 1)) { style := (c.text && c.column = xl.activecel...
by aaabbbccc180
30 Nov 2021, 12:48
Forum: Ask for Help (v1)
Topic: How to organize data from excel in word using headers? Topic is solved
Replies: 7
Views: 743

Re: How to organize data from excel in word using headers? Topic is solved

That works great, except that the header style carries over to the rest of the text, so all the text ends up appearing as a header. I guess I want to apply a different style to the rest of the text. Here's my attempt at doing this but I am assuming something about this syntax is wrong: ^`:: ; when C...
by aaabbbccc180
30 Nov 2021, 11:36
Forum: Ask for Help (v1)
Topic: How to organize data from excel in word using headers? Topic is solved
Replies: 7
Views: 743

Re: How to organize data from excel in word using headers? Topic is solved

Amazing - thank you so much! It executes quickly enough that it seems I can just set the range to a large number so I don't have to worry about checking for blank cells. With slight edits I landed on this: ^`:: xl := comobjactive("excel.application") oword := comobjactive("word.application") Send ^{...
by aaabbbccc180
29 Nov 2021, 18:28
Forum: Ask for Help (v1)
Topic: How to organize data from excel in word using headers? Topic is solved
Replies: 7
Views: 743

How to organize data from excel in word using headers? Topic is solved

Hi all, Sorry if this question is a little basic - I'm a complete novice. I'm looking to move data from an excel sheet and organize it in an already opened word window with headers. For any cursor starting position in the excel sheet, I want the column the cursor is in to become a header, and put th...

Go to advanced search