![]() |
|
#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 | 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 |
![]() |
loki005 | Word VBA | 4 | 10-25-2018 02:18 PM |
![]() |
Greengecko | Word VBA | 5 | 06-14-2016 07:54 AM |
![]() |
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 |