I am attempting to import a text file, but I get an error "(10094) ActiveX Automation: Object var is 'Nothing'."
Not sure what the mistake here is.
Code:
Sub vba_excel_importing_file() Dim strFileName As String strFileName = InputBox("Enter the full path to the comma " & _ "separated file to import")