Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-19-2018, 08:05 AM
d4okeefe d4okeefe is offline State management? Windows 10 State management? Office 2016
Advanced Beginner
 
Join Date: Apr 2013
Posts: 77
d4okeefe is on a distinguished road
Default


Have you thought about using the Range.ConvertToTable method?

If the pdf saves to word in a fairly structured way, it may be easiest to use this built in tool. It may have some errors, but that is almost inevitable when trying to access data from a pdf.
Reply With Quote
  #2  
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
Reply

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 05:26 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