Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2022, 06:57 AM
simonrimington simonrimington is offline Remove rows and create PDFs Windows 10 Remove rows and create PDFs Office 2019
Novice
Remove rows and create PDFs
 
Join Date: Jul 2022
Posts: 2
simonrimington is on a distinguished road
Default Remove rows and create PDFs

I have cracked removing blank rows and creating PDF's but cannot get both processes to run at once - I can have PDF's or rows removed not both.



Anyone any advice? I just need to find a way to get the Macro to do both!
Reply With Quote
  #2  
Old 07-22-2022, 06:25 PM
macropod's Avatar
macropod macropod is offline Remove rows and create PDFs Windows 10 Remove rows and create PDFs Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,601
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Since you haven't posted whatever code you're working with, it's impossible for anyone to provide meaningful advice about that.

That said, see:
Split Merged Output to Separate Documents and, better still, Send Mailmerge Output to Individual Files in the Mailmerge Tips & Tricks 'Sticky' thread at the top of this forum - https://www.msofficeforums.com/mail-...s-tricks.html; and
https://www.msofficeforums.com/137121-post2.html & https://www.msofficeforums.com/129119-post4.html. The For each Tbl loop in either post could simply be inserted before the 'Save As' line in either of the macros referred to above.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-22-2022, 11:12 PM
simonrimington simonrimington is offline Remove rows and create PDFs Windows 10 Remove rows and create PDFs Office 2019
Novice
Remove rows and create PDFs
 
Join Date: Jul 2022
Posts: 2
simonrimington is on a distinguished road
Default

Sorry, I should be clear I've been in both those threads and managed to do that. Also been on another thread and managed to collect a code which removes rows if blank when looking at a particular column of cells.

The bit I'm struggling with or if it even possible is if I can combine those macros so it removes the rows as it creates individual documents.
Reply With Quote
  #4  
Old 07-23-2022, 04:08 AM
macropod's Avatar
macropod macropod is offline Remove rows and create PDFs Windows 10 Remove rows and create PDFs Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,601
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Did you read the last sentence in my previous reply?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove rows and create PDFs Create PDFs dita Word VBA 3 10-31-2019 11:09 PM
Remove rows and create PDFs Compatibility of 2 macros in mail merge: Delete table rows + save individual PDFs Btop Word VBA 26 03-07-2018 01:45 PM
remove rows without certain word ewso Word VBA 4 05-28-2017 01:27 AM
Remove rows and create PDFs Remove rows less than 10 gbaker Excel Programming 18 07-21-2014 04:51 AM
Remove rows and create PDFs How to remove blank rows from a specified range? Learner7 Excel 1 04-19-2011 02:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:02 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft