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

On Sep 21, 1:55*pm, SS wrote:
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

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


On Tue, 21 Sep 2010 11:55:01 -0700 (PDT), SS wrote:

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

On Sep 21, 3:36*pm, Gord Dibben wrote:
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



On Tue, 21 Sep 2010 11:55:01 -0700 (PDT), SS wrote:
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- Hide quoted text -

- Show quoted text -

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