Sleeper: Macro to copy data from a text file and place data in Excel

[surya prakash]

Hi,

I manually open the text file (set2.rea) and copy the data to a excel sheet.

Only the data shown in blue (in the excel sheet) is moved to different cells using Text to Column function and the data above the blue colored text is unmoved.

I am wondering if the manual operation of copying and moving selective data using text to column function can automated.

Thanks
Surya

[Killian]

Hi Surya,

you can use Excel dialog boxes to get your data in:

Application.Dialogs(xlDialogImportTextFile).Show

and if you can't get the formatting done through the wizard, you could then run your code