Search found 5 matches
- 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...
- 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...
- 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...
- 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 ^{...
- 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...