Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 07-10-2016, 05:59 PM
Irene H Irene H is offline Looping through word and writing to excel when certain conditions are met Windows 10 Looping through word and writing to excel when certain conditions are met Office 2016
Novice
Looping through word and writing to excel when certain conditions are met
 
Join Date: Jul 2016
Posts: 3
Irene H is on a distinguished road
Default

Doug,

Thank you for that suggestion.

The problem with having it where it was (other than being untidy and redundant) was that I re-initialised the xlRow variable to 2 every time, so in fact I was simply rewriting everything to the same row, instead of incrementing the counter and writing to the next row.

One of those mistakes when you're overtired and been looking at something too long!


Cheers,
Irene
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Formula for Multiple Conditions & Results nowco Excel 4 03-16-2016 11:24 AM
Writing PDF from Mac Word dickmill Word 0 01-13-2016 08:17 AM
Looping through word and writing to excel when certain conditions are met Generating Multiple Word Docs from Master Depending on Conditions ljg713 Word VBA 6 12-09-2015 03:23 PM
Looping through word and writing to excel when certain conditions are met How to stop MS word writing in margin gerretw Word 2 02-05-2013 07:01 AM
Looping through word and writing to excel when certain conditions are met Replacing cells in Excel-Very basic with minor conditions mag Excel 1 10-26-2012 10:59 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:06 PM.


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