If i want to import text file using VBA or Macro i can use below code
Fname = Application.GetOpenFilename("Text Files (*.txt),*.txt", , _
"Select Text Data File")
but does not work if we need to perform few steps Under file origin section after opening the file using above code. Is there...
If we have a variable "Flname" which contains value in a string format and the value is accepted from Input Box then how can we use that variable to name a sheet. Name of the Sheet to be displayed should be the value stored in the variable or the value accepted through Input Box.
Ex. Flname =...