i have this format 08:4516:45 where both the time in and time out of an employee is inside a cell (no space) . I want to split them using column to text where only 08:45 is seen. And since i dont really know how vba works, i always use record macro that gave me the code below.
The problem is...
I have macro written that i want to repeat on several text files. How can i have the macro prompt me to select the file I want ? My Macro is as follows:
' Import Macro
' Keyboard Shortcut: Ctrl+a
With ActiveSheet.QueryTables.Add(Connection:= _