Untitled.jpg

Admin

DeeDee Baldwin

<div>
<div class="content wysiwyg-content">
I have a large number of excel files I need to open and run a macro to count columns and count non-blank and blank values on a row. &nbsp;The first 8 columns are the same and then after ~ the columns per file various. &nbsp;It could be 1 column to 45 columns. &nbsp;Also a file could have only 1 record or it could have over 300 records. &nbsp;I am trying to figure out a way to open all of the files at once apply the macros to remove a few columns and add 3 columns to hold the &quot;total count&quot;, &quot;blanks&quot;, and &quot;completed&quot; values, along with having &nbsp;the output from each file combined into one larger file. &nbsp;Any help would be greatly appreciated.
</div>
</div>


I have a large number of excel files I need to open and run a macro to count columns and count non-blank and blank values on a row.  The first 8 columns are the same and then after ~ the columns per file various.  It could be 1 column to 45 columns.  Also a file could have only 1 record or it could have over 300 records.  I am trying to figure out a way to open all of the files at once apply the macros to remove a few columns and add 3 columns to hold the "total count", "blanks", and "completed" values, along with having  the output from each file combined into one larger file.  Any help would be greatly appreciated.

Excel Files Combined

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.