can a string value be created reflecting the contents of a txt file in a single string?

[spurs]

I am trying to open a text file by the name of response.txt using VBA code.
I don't actually want the file to open or close on the screen; but I just want the vba code to assign the string variable A with the contents of the text file. The string is not more than 20 characters.

What coding would be needed to assign the contents of the text file response.txt to the variable A followed by the file response.txt file being deleted off the memory drive.

 

[=ODIN=]

This code might work:

Sub parseTxt()
    Dim sTemp As String  'This will be your string from the text file
    Dim iFileNum As Integer
    Dim sFileName As String
    sFileName = "C:\Users\Surface5\Desktop\test\Response.txt" 'this should be the path to the text file
    
    iFileNum = FreeFile
    Open sFileName For Input As iFileNum
    


    
    
       sTemp = Input(LOF(iFileNum), [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=iFileNum]#iFileNum[/URL] )
     Close iFileNum
     'Debug.Print sTemp
     Kill "C:\Users\Surface5\Desktop\test\Response.txt" 'this again should be the path to the text file to delete it.
     
     'Debug.Print sTemp
End Sub

 

[spurs]

This worked perfectly and it was so simple !

Thank you !