Import data from text file to excel workbook

[cjl22]

I have a text file containing multiple rows of data and I want to copy it all and paste it into an open workbook (without performing any formatting like text to columns). Is there an easy way to do this via vba? The text file will always be on my desktop and have the same name but the workbook name will change from month to month.

[hrlngrv]

You don't want to use Text to Columns. Is there any structure to your text file? How are data on the same line in the text file supposed to be split into multiple columns?

In general, yes, VBA could import your text file. If you'd always be importing the text file into the active workbook, the VBA macro could refer to ActiveWorkbook and not need to know the workbook's filename or drive/directory path. And that's as much of an answer as I can give without more details from you.

[Marc L]

Is there an easy way to do this via vba?

From the top tab Data : Import From File …