I have a word document that I create from data in an excel spreadsheet to create reports. I need to insert a page break at the end of each report. The code I have is below. The error I receive is:
Object doesn't support this property or method.
Please Login or Register to view this content.
Hello twyblue,
You did not declare the Word constants. Remember from yesterday? Any named constant starting with wd is not available at compile time because you are using late binding.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I thought I did - at the top I placed
Please Login or Register to view this content.
Hello twyblue,
How about wdDoNotSaveChanges?
Also did not a Const for this one wdCollapseEnd.
It actually all works except inserting the page break without declaring the other word constants. If I comment out inserting the page break, it exports to pdf and closes the open word files without any problem.
Hello twyblue,
You got lucky this time because the other constants have zero values. Shortcuts more often than not will come back to haunt you. Practice good coding habits now and you will still hair when you're sixty.
Can you attach a copy of the workbook for review?
Attached is the word doc I populate from the excel spreadsheets. For multiple reports, I populate the document, add it to a new document, then close and re-open the template, populate with next report, etc.
Hello twyblue,
Is the error occurring on the line where the page break is inserted?
If this is a single page document, why do you need to insert a page break?
Yes it is. They can choose just a single report, or all the reports for the department.
When they choose to view all the reports in one document, I am looping through and creating a document for each report, then adding it to a new temp doc before exporting it to a pdf. I need a page break in the new document after each report so the reports won't run together in the pdf.
Hello twyblue,
It has been awhile since I wrote any Word macros, I need to experiment with code bit to give you an answer.
Hello twyblue,
I need to construct another Word document for testing. Using the one posted is not working correctly and I am not sure why.
I am not sure how this exactly works, but placing this line in the code gives me the page break.
Please Login or Register to view this content.
Last edited by twyblue; 03-06-2014 at 10:38 AM.
Hello twyblue,
It works and that what really matters. Good job on finding a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks