Split MS Word document in PDF
Good day,
I have a large MS Word document containing invoices for customers.
Each invoice is one page long and contains a row denoting customer number.
A sample invoice is
xxxxxxxxxxxxxxxxxxxxxxxxxx
Date: 2017-03-20
Customer number: 586
Invoice number: 25641
xxxxxxxxxxxxxxxxxxxxxxxxxx
I would like to use a macro to automatically create one page for each invoice in PDF and have the PDF name be the customer number? Is this possible?
I have a large MS Word document containing invoices for customers.
Each invoice is one page long and contains a row denoting customer number.
A sample invoice is
xxxxxxxxxxxxxxxxxxxxxxxxxx
Date: 2017-03-20
Customer number: 586
Invoice number: 25641
xxxxxxxxxxxxxxxxxxxxxxxxxx
I would like to use a macro to automatically create one page for each invoice in PDF and have the PDF name be the customer number? Is this possible?
ASKER
Each customer has one and one invoice only
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@Joe Winograd - the VBA solution link i provided above was written by Graham Skan who, as you well know, posts quite often on Word solutions in EE...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
We haven't heard from the asker in four weeks, and without feedback, it's impossible to go any further. The Graham Skan solution posted by Paul has value and is worthy of some points, although, as Paul notes, it produces sequential page numbers only, NOT utilizing a value from the document, which is a key requirement for the asker (i.e., Customer Number). The method mentioned in my posts is a proven solution that I have implemented successfully in many custom programs. It is worthy, imo, of being the Accepted Solution and, along with my follow-up post, getting the lion's share of the points.
If not, you will overwrite any duplicate invoices!