Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-19-2018, 09:30 PM
Zars01 Zars01 is offline State management? Windows 10 State management? Office 2013
Novice
State management?
 
Join Date: Jun 2018
Posts: 3
Zars01 is on a distinguished road
Default

@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.
Reply With Quote
 

Tags
state, tabstops



Similar Threads
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
State management? User Selectable Buttons That Express State 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft