How do I turn on get data from a File in Excel?

How do I enable the Get tab in Excel?

I have used this answer: Get a list of worksheets in an Excel workbook and use them?

To get to the Get tab. Now, when I try to click on it, I get an error: "This feature isn't available at the moment".
If I can't even get to the Get tab, how do I make some cells more editable or viewable? Thanks for any help! Click on the File menu (at the bottom left), then click the Options. Button. You'll be presented with a small dialog box allowing you to adjust certain options for the workbook such as font sizes and colours. Click OK when you're done.

How do I turn on get data from a File in Excel?

It will get data from a file if the file contain an "X" in the first line.

You can do this with VBA if you are willing to spend the time and know what you are doing (VBA, but not a macro, is a very powerful programming tool). Simply read the File into a String variable, and then parse the data from that string variable.

Here is a basic idea of how to do that: Option Explicit. Sub Test(). Dim sData As String. Dim vRangeToImport As Variant. sData = IO.ReadAllText("C:ExampleInput.txt")
vRangeToImport = Split(sData, vbCrLf). Debug.Print vRangeToImport(0) End Sub. 'Outputs. 12, 24. The ReadAllText method returns a string which is the value of all the lines in the file, separated by the vbCrLf character. The Split function then takes the resulting string and parses it into a two-dimensional array.

The Array index can be any integer, so this means we can simply take the value of the first line and use that to pull it out of the string. Here is a slightly more complicated way of doing it: 'Note! This function requires VBA 8.0 or higher because of the New Long Array Function ConvertLongArrayTo2DArray(ByRef longArray() As Long, Optional ByVal nItemSeparator As String = ",") As Variant. If LBound(longArray) > 0 Then. ReDim aResult(LBound(longArray) To UBound(longArray) - 1) As Variant. End If. For I = LBound(longArray) To UBound(longArray) - 1. aResult(i) = ParseOneLong(longArray(i)). Next i.e. ConvertLongArrayTo2DArray = aResult. End Function. Here I have provided a function for parsing the input.