Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2014, 01:58 PM
macropod's Avatar
macropod macropod is offline Find specific rows then copy and paste to new doc Windows 7 32bit Find specific rows then copy and paste to new doc Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,512
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


Those variable references are to documents, not just document names. The code I posted assumes you've opened the documents and therefore need only to tell the macro which is which. As coded, the macro assumes it is in the source document, which isn't the active one, and that the active document is the target document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 02-20-2014, 06:46 AM
konopca konopca is offline Find specific rows then copy and paste to new doc Windows XP Find specific rows then copy and paste to new doc Office 2003
Novice
Find specific rows then copy and paste to new doc
 
Join Date: Apr 2011
Posts: 27
konopca is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
As coded, the macro assumes it is in the source document, which isn't the active one, and that the active document is the target document.
Hi Paul - Please excuse me, I'm confused by this statement. So I tried running the macro while I was in the IndexSource dcoument and then while I was in the IndexTarget document. I get the same error code regardless. My code is in my Normal template, maybe that's the problem?

Carol
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Find specific rows then copy and paste to new doc Deleting rows with specific criteria joflow21 Excel 9 11-22-2013 12:10 PM
Why cant I just copy/paste new flippin rows into a flippin table? jethrouk Word 8 11-17-2013 06:09 PM
Find specific rows then copy and paste to new doc Paste Special: Copy and Paste Formatting Only? tinfanide Word 6 03-06-2013 12:21 AM
Find specific rows then copy and paste to new doc Find Results in excel copy the rows to another sheet khalidfazeli Excel 2 02-06-2013 09:38 AM
Find specific rows then copy and paste to new doc Find, copy and paste into a new page jperez84 Word VBA 24 09-20-2012 11:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:44 AM.


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