![]() |
#5
|
|||
|
|||
![]()
@macropod -
I am trying to add speed to the code I posted. Preferably with some state management ... but I'm thinking that's not a thing in Word VBA the way it is in Excel VBA. My end game is turning this FROM.png into this AFTER.png Because Exporting a PDF to Word mangles the tables and I want to analyze the data. Exporting direct to Excel is worse. My code uses tabs, tabstop position info, column widths, alignment info, etc. to determine where text is on the page. Once that's done, I paste it to Excel then move all the text into columns according to where Word put them @slaycock - I didn't think of that - thanks - unfortunately, the file came through with different, less workable problems? Some rows were moved to the beginning of their respective pages at random. I think this just straight up destroys the association I need @d4okeefe - I didn't know about .ConvertToTable, so I played around with it - unfortunately, no joy. I mean, this is the kind of thing Acrobat Pro export spits out: Data1 tab Data4 Data1 | Data2 | Data3 | Data4 The single tab there uses a tabstop to visually move Data4 into the correct spot visually - but it isn't actually in column 4 So ConvertToTable just moved it to column 2, etc. |
Tags |
state, tabstops |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to Prevent auto period after two-letter state abbreviation | gogreen | Word | 12 | 05-19-2018 08:36 PM |
Cable management | adminstefan | Visio | 1 | 02-13-2017 08:48 AM |
![]() |
Andrew H | Word | 1 | 11-08-2012 07:36 PM |
Resetting to Default State not working | carlgrossman | Word | 0 | 08-02-2008 01:31 AM |
Please help with Sum formula to add totals by State! asap | dutch4fire23 | Excel | 0 | 07-28-2006 12:41 PM |