Errol Farro
asked on
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 xxxxxxxxxx xxxxxxxxxx xx
Date: 2017-03-20
Customer number: 586
Invoice number: 25641
xxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xx
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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
@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
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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!