Hey guys,
I’m new to Visual Basic and I want to create a macro that will read excel files within a folder and will count the number of rows and columns. Then it will output the Name/Number of Rows/Number of columns into the current excel file.
So output will look like this
Excel File Name Number of Rows Number of Columns
I have managed a macro to read the files and columns but the output is giving me a hard time.
any help would be great! thanks in advance!
Thanks in advance!!Please Login or Register to view this content.
Bookmarks