![]() ![]() With ActiveSheet.Range("A1"). You need many more parameters than you have supplied in order to guarantee that it is going to operate the way you want. Next, the Range.TextToColumns method 'remembers' all of the settings that were used the last time it was run through it doen't matter whether that was by the user on hte worksheet or through VBA. ![]() StrLine(LineIndex) = Replace(strLine(LineIndex), Chr(9), Chr(32)) Look in the Column / block group towards the middle of the ribbon and click on the CSV Convert drop down, then select Convert to fixed-width. With the CSV file active, click on the Edit tab. 'STRIP TABS OUT AND REPLACE WITH A SPACE!!!!! Step 1: Convert to fixed-width Open the CSV file you’re going to be working with. Open txtFldrPath
0 Comments
Leave a Reply. |