Solved: Copy .txt file

[Meatball]

I want to be able to choose a .txt file from several in a folder and copy /paste the entire contents into an Ecxel sreadsheet. How hard is this to do? I tried getting some different codes to combine and do this but with no luck.

[GTO]

Hi Meatball,

Try recording: Data|Get External Data|Import Text File

Excepting picking which file to import, this should give you a start. Then look at Application.GetOpenFilename for picking.

Hope that helps,

Mark

[Meatball]

:motz2: :motz2: :motz2:, I wish I knew one quarter of what most of you know. That worked great and I think I can rework in some parts of other macros to choose the file. Thank you very much Mark