PDA

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



surya prakash
03-01-2005, 12:24 AM
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
03-01-2005, 02:58 AM
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