Graph updating function
The procedure below does that, with the effect of clearing all of the settings from the Text To Columns dialog box (and making no changes to your workbook).
Sub Clear Text To Columns() On Error Resume Next If Is Empty(Range("A1")) Then Range("A1") = "XYZZY" Range("A1").
Macro Options _ Macro:=Func Name, _ Description:=Func Desc, _ Category:=Category, _ Argument Descriptions:=Arg Desc End Sub You need to run this macro only one time. Cell C2 contains this formula, which was copied to the cells below: The function identifies the complete word trapped, but not the word trap, which is part of trapped.
After doing so, the descriptive information is stored in the workbook (or add-in) that defines the function. Also, note that a space is not required after a word in order to identify it as a word.
The macro assumes the active cell contains a compete filepec for an MP3 file (that is, the full path and the filename).
The Play MP3 procedure creates an OLE object that links to the file in the active cell.
Sometimes remembering these settings really is helpful, but often, it's not.
To clear these delimiters, you must display this dialog box, clear the settings, and click Cancel.
If cell A1 is empty, the code inserts a temporary string (because the Text To Columns method will fail if the cell is empty).
If you're importing or pasting via a macro, there's no direct way for your macro to check these settings or reset them.
The solution is to "fake" a text-to-columns operation.
In such a case, the User Form is not centered in the Excel window. Today I discovered another method that's much simpler. Google's Chrome browser is actually better for this task because it doesn't precede the file names with "File:" and it puts the date and time in a single cell. If you need to get a list of files in multiple directories, you must repeat the procedure for each directory.
On my system, User Forms always display on the left side of the secondary monitor, even if Excel is maximized on the primary monitor. For more flexibility, use the Filename Lister utility in my PUP add-in.