![]() |
|
#1
|
|||
|
|||
|
Hello,
I have 400 word documents (.docx) in a folder. In all the 400 documents, second sheet is blank. I want to delete the second sheet from all of them. Is there any macro to do this? Thank you. |
|
#2
|
||||
|
||||
|
The code for that really depends on what is causing the second page to be blank - which you haven't told us about. It could be caused by any one or more of:
• manual page breaks; • section breaks; • paragraph 'page break before' formatting; and/or • empty paragraphs on the second page.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
#3
|
|||
|
|||
|
Hello, thank you for your reply.
I checked and it is a section break. Can you help with this? Thank you. |
|
#4
|
||||
|
||||
|
There would need to be more than just a single Section break. Moreover, indiscriminately deleting Section breaks can seriously mess up a document's layout.
Without actually seeing the problem document, it can be difficult for anyone to craft an effective solution for the issue. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab at the bottom of this screen.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
| Tags |
| macro, word vba |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Delete last page of .docx and then save as .pdf for all the files in a folder | kalton | Word VBA | 2 | 01-23-2020 10:05 PM |
Save all docs to pdf in specified folder
|
loki005 | Word VBA | 4 | 10-25-2018 02:18 PM |
Import a specific range (bookmarked section) from all Word docs in a selected folder
|
Greengecko | Word VBA | 5 | 06-14-2016 07:54 AM |
Sequential Page Numbering of Multiple Word Docs
|
bobmard | Word | 8 | 08-24-2011 08:51 AM |
| Weird problem - word docs are producing temp files that won't self delete | David92595 | Word | 0 | 07-07-2011 04:07 PM |