Search results for query: *

Hi Sorry, An excel file. I have also come up with the fact that each row will either have this heading information or others values, so can I do the first row of headers, then check the first cell of the second row, if it doesn't match cell 1 row 1 then not a header but if contains other values...

Hi, I have managed to sort out a lot that I asked about in my last post. What I am now trying to do, I just read the first row, column 1 to 9, define that each of these cells contain specific data. After this I am then trying to class these particular cells as headers, then when I move on to...

Thanks for your comment, I believe i broke it down to the best i could, and I knoe what I want, just couldn't do it in code as I have only just started learning it. I beleive I have now managed to achieve what I wanted, I just need to tweak it and test it. Thanks again :)

I'm not sure how to break it down anymore. Do you have any ideas to what it can be?

Thank you for your response. I have done what you said I just can't/ don't understand how to intemperate it into code. My structure is (And i believe this is probable simple to do for someone who knows how); Loads all Excel files from an input directory, Once loaded the Excel files are then...

I am really new to all this and I have have taken on a project that now seems abit out of my depth. I have found snippets of code through browsing and put them in some structure for what I beleive in need as you see below. the excel files have rows of data that I need to read and transfer...