wes2706
03-30-2017, 01:40 PM
I will need to load a text file into excel into a particularworksheet called “Temp_Cal” in cell “A1”… the text file should be loaded as delimitedand the delimiters are tab and space only.
As an input I have the folder location in an excel cell…letssay Sheet1 in cell C3
And the file name is also in an excel cell lets say Sheet1in cell C4
Using the values in Sheet1 cell C3 and Sheet1 Cell C4 as my input, I need to create a string with the file name and location, then openthe text file and insert it into Excel Sheet (“Temp_Cal”) from Cell “A1” onwards…
Can someone please help?
As an input I have the folder location in an excel cell…letssay Sheet1 in cell C3
And the file name is also in an excel cell lets say Sheet1in cell C4
Using the values in Sheet1 cell C3 and Sheet1 Cell C4 as my input, I need to create a string with the file name and location, then openthe text file and insert it into Excel Sheet (“Temp_Cal”) from Cell “A1” onwards…
Can someone please help?