Rustywinger Posted April 4, 2009 Report Share Posted April 4, 2009 This might seem obvious to the more Excel saavy crowd... The question: I delete rows of data in an excel CVS, and then use a macro to append text to it, however the appended text will skip the deleted rows in Excel, leaving blank rows for however many rows you have deleted. <-This is me with a problem. The background, which is skippable if you know the answer to the above and have blessed me with it.... ( <- this would be me with the answer) I have a Macro that uses an Excel CSV source file run through a 'Process Text file' loop, it will grab data and use it to process a record in an application and then append the line to a destination CSV file. This process can be interrupted by errors or other undetectable events and the files are several thousand lines long. I restart the macro by running the destination file through a Process Text File loop in order to determine how many rows have been completed before restarting the main process with the source CSV file. All the above is all contained in one Macro which is simply fed a file name and then detects or creates the destination files it needs. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.