Hi,
Can anyone please let me know how to get the following functionality:
My requirement is, in excel i need to provide an option to browse for the text files. User can select one or more text files at a time. Once the text files are selected, the data from the text files has to be imported to the excel sheet (creating each seperate sheet for a each selected text file, the name of the sheet will be the name of the text file).
The text files will be in a specified format with a delimiter $.
Can you please help me put on this? Do we need to write a macro for this?
Thanks in Advance.
Can anyone please let me know how to get the following functionality:
My requirement is, in excel i need to provide an option to browse for the text files. User can select one or more text files at a time. Once the text files are selected, the data from the text files has to be imported to the excel sheet (creating each seperate sheet for a each selected text file, the name of the sheet will be the name of the text file).
The text files will be in a specified format with a delimiter $.
Can you please help me put on this? Do we need to write a macro for this?
Thanks in Advance.