Good way to open a .txt file, copy/paste all text into Excel?

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

All,
What is a good way to open a .txt file, select all (it's all text),
copy.... then paste into an empty excel sheet; using VBA code?

Here's the situation:
I would like to run this sub when the workbook opens. The location
and name of the .txt file are always the same. I just need to simply
select all in txt file, copy, then regular paste into an excel sheet.
However, i will need to code past the question pop-up in excel about
the 'Data on the Clipboard is not the same size and shape...." .
clicking ok to that pop-up gives me what i want. Then close the .txt
file.

Any help would be greatly appreciated.

Thanks,
Steve
 
All,
What is a good way to open a .txt file, select all (it's all text),
copy....   then paste into an empty excel sheet; using VBA code?

Here's the situation:
I would like to run this sub when the workbook opens.  The location
and name of the .txt file are always the same.  I just need to simply
select all in txt file, copy, then regular paste into an excel sheet.
However, i will need to code past the question pop-up in excel about
the 'Data on the Clipboard is not the same size and shape...." .
clicking ok to that pop-up gives me what i want.  Then close the .txt
file.

Any help would be greatly appreciated.

Thanks,
Steve
Click to expand...

Have you tried a simple recording of a macro while doing it?
 
Have you tried the macro recorder?

If so, what results did you get and what improvements do you need?

Might be easier to simply open the *.txt file directly with Excel??


Gord Dibben MS Excel MVP
 
Have you tried the macro recorder?

If so, what results did you get and what improvements do you need?

Might be easier to simply open the *.txt file directly with Excel??

Gord Dibben     MS Excel MVP








- Show quoted text -
Click to expand...

I wasn't thinking to open within excel and convert it. Looks like
using the Import External Data option will work great in this case.

Many Thanks for the replies!!

C ya,
Steve
 
Back
Top