JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
I have fairly large daily text files of approximately 4000-5000 rows that I am importing into a worksheet then running a macro that looks for specific data in certain columns. I have about 40 different criteria I search for.
Problem is that the file size varies each day row wise as well as column wise. Using the Import Wizard Excel makes guesses where there columns should be yet based on the text within the text file Excel has different guesses each day an the columns that I am coding in my macro to search for the data are not always the same and even some data is split so my finds in the macro's do not work correctly since the columns are different than my practice import used to write the macro.
On the practice import I have columns all the way up to FF but within the macro I delete the columns down to about 25 to search for my data.
I was thinking of writing some code that would check to see if certain data has been imported to the correct columns thus knowing my macro will be searching for the correct finds in the filtered columns I have coded.
Just wondering if this is the way I need to go or is there another solution out there someone has.
I did try opening the text file with Excel which then puts each row starting in column A then I try text to columns but still the wizard guesses where the columns should be and thus I am not sure if my data & columns will be lined up correctly.
Any help will be appreciated.
James
Problem is that the file size varies each day row wise as well as column wise. Using the Import Wizard Excel makes guesses where there columns should be yet based on the text within the text file Excel has different guesses each day an the columns that I am coding in my macro to search for the data are not always the same and even some data is split so my finds in the macro's do not work correctly since the columns are different than my practice import used to write the macro.
On the practice import I have columns all the way up to FF but within the macro I delete the columns down to about 25 to search for my data.
I was thinking of writing some code that would check to see if certain data has been imported to the correct columns thus knowing my macro will be searching for the correct finds in the filtered columns I have coded.
Just wondering if this is the way I need to go or is there another solution out there someone has.
I did try opening the text file with Excel which then puts each row starting in column A then I try text to columns but still the wizard guesses where the columns should be and thus I am not sure if my data & columns will be lined up correctly.
Any help will be appreciated.
James
