I'm probably trying something too intense for a newbie such as myself, but I am attempting to construct/convert a program that will load all the text files from a specific folder and make them all worksheets in the same workbook, name them after their original titles, format the columns, and then make some graphs. So far I've been using other programs I've found online and attempting to glue the bits and pieces together, but can't get the whole thing to work together.

My program can download and rename without a problem, but can only do the initial formatting (column widths and hiding columns) for the first sheet. It also pops up an error whenever I try to have it insert a row between differing values in column U (which I am trying to do so I can graph more easily).

The final goal is to have a workbook full of spreadsheets that show the data and graphs of the BOD and Flow results. Am I going about this the wrong way? Any tips on what to change to finish the formatting and to have it carry across all the sheets?

I've included both the program as it stands now and a sample of the data (it compressed the blank cells, but the colum containing Flow Rate and BOD5 is U). Thanks!

Please Login or Register  to view this content.
Please Login or Register  to view this content.