How to import data with JSON?

Vba help - import data from multiple .txt files into 1 worksheet

• , I am just learning VBA/Macros, and I am trying to create a macro that will import data from multiple .txt files (all located in the same directory) into a single worksheet. All of the data files are formatted the same, but with different data. Basically, each file contains 86 lines of fluff (dates/times/parameters that I do not need to import), followed by lines that contain 2 columns of tab-delimited data until the EOF. The first column is the Wavelength data, and the second column contains Absorbance data. If needed, I could send you an example data file. In the end, I want myfile to be a table, in which the first column is the Wavelength data (which will be the same in all .txt files), followed by columns that contain a header (the filename of the .txt file) and the absorbance data from that .txt file (one column per file after the initial wavelength column). For example, Filename1 Filename 2 ETC(for all files) Wavelength Absorbance Absorbance 850 3 0.04 849 5 0.05 848 4 0.03 847 5 0.05 846 4 0.04 ETC(for all wavelengths) Any assistance would be greatly appreciated... Sarah

• Answer:

  Sarah, Please send two or three sample files to include version ofand the contents of this posting I need to understand if the wavelength entries will be the same in each file or if I have to search to find where to place the absorbance data. Two or three files should answer that. Thanks