How to Import Text (.txt) Files Into Excel - Excel VBA Tutorial - Awesome!!

How to extract text or specific text only from notepad to Excel using VBA

Nice. I really like that last part with application.getopenfilename() . Never seen that before but it's powerful ;)

Hi is it possible to loop through a word pad file extracting specific criteria based information and adding it to an excel spreadsheet? Thanks 🙏

Great video, thanks

Very good

Sir is main coloum wise Nahi as Raha hai

Hi, how can I do the same for multiple text files.

I have a question. In listbox the colour blue that select items I want to change for other colour. Can I change it. and If is posible, How I can do it. Help me please.

Hi Dan thanks for this
I work in garment industry and there are many approvals and discussions so is it possible to embed an email as an attachment in excel automatically?

i love you Sir

Thanks great JOB!!!!!

what if I have more than one text file with different names

this is just one file on the desktop, what if you want to use VBA to open multiple text files? how to loop them

Very helpful, the videos contributed to my capacity as a professional. A big thank to the providers

চ্্

I am working in Accounts Receivable team were i need to download 21 different bank statement and copy and pest all bank statement in Excel on daily bases
Is there any way to import these statements Directly from Bank Website to Excel Help Me out please

Hi
I am working in Accounts Receivable team were i need to download 21 different bank statement and copy and pest all bank statement in Excel on daily bases
Is there any way to import these statements Directly from Bank Website to Excel Help Me out please

Thank you so much for this video😊

God Bless you man, this video save my ass

Is there a way I can get my Music.txt file with all play count and ITunes info into an .xml or ITunes library.ltd
And import all the info from Music.txt so it can be in that order with dates etc?

Hello sir,

how can we get mail content data into excel file using VBA, the mail content format will be like, Date, Company Name, Total Expenses, Spending Date, Location.
These are the headers, and below this there will be some 20 rows of data,

How to get this into Excel and save in a specific folder with the mail subject line name automatically,

This will be a great help sir,

Regards,
Prakash,
Bangalore, India

Thank you

good one Dan:)

lol that says JP Morgan

Is there a way to do this, with PDF files?
I've found a way to get the data I need from manually saving a PDF file as an Excel file, with the help of some Excel formulas after that.
But I'd like to have the PDF-Excel conversion run automatically when I click on a button or something.
OR!
Is there an easier way to get data from a PDF file (only specific data/text/nums) with VBA?

THANK YOU =)

Hello guys,
I download PPC Auto Report file in txt. document and it I see asterisks *
Does anyone know how can I see the keywords behind these * ?
Is it something I have to convert to on my Excel (where I insert the txt.) or there in the txt. file?
Thanks anyways!

I need some help in vba? can someone call me at 913-972-0117 ask for David

Hi Dan. Great video. Is there a way to set up a checksum or something similar to ensure that all data from each .txt file has been imported?

How would you charge to put commas on a colum? Thank you

Sir your contents worth millions of Rupees(for us)

docReader to Excel?

hey Dan thanks for sharing! i have a question though, is there anyway to make the macro import the text on a specific sheet in a certain excel file?

Good one Dan :). I was looking for this today and happy to see a detailed video on the same :). Thanks for sharing the knowledge!
Are you still active with this stuff? I see your last videos are around 1 year old. Cheers !

how to take a Script Text File ] and turn it into Tweets..please explain how to do this

too much talking

My .txt data should convert like this in excel? can anyone help me




 
  SCID00 -
  PI1
 
 
  SCID01 -
  P01
 
 
  SCID02 -
  IE5
 


 
  KRW,5
  HUF,0
 
 
  LMV,3
 
 
  KRW,2

OK quick question possibly stupid but how would you take this macro and keep adding on to it. Like I want to combine multiple text files into 1 excel file just like its done in this video

Thanks Dan, great video.  I have a question, is there a way to create a macro to automatically collate data from a numerous number of other excel documents, without going through and showing it what to do for each one?  I want to automate the automation.  Any suggestions?  Thank you.

Thanks.  That is awesome!  How do you import text into an open workseet?  I tried the ActiveWorkSheet.QueryTables.Add but where my problem lies is that the File path I want to add is a variable which is concatenated with the filePath of the workbook and the text file name (i.e:  myVarPath + "fileName.txt").  I can't seem to get the ActiveWorkSheet.QueryTables.Add constructor to use my variable.  Any ideas?

how to move the content in html file. like when we open it it appears moving. like that so plz provide me

Thank you,
When I try to follow your eminent tutorial it does not work.
The macro does not record all the parts, when I run it again, just paste it into all values ​​straight up and down without separation in different columns. Think formats election efterråt has something with it all to do. If I do it right and then select the text will return the worksheet to a normal Ctr + V paste. 

It is strange that it does not record everything that I do.

Beloow  is the macro code, do not worry about the first few rows:


Sub Makro3()
'
' Makro3 Makro
'
'
    Sheets("ImportAgressoKKKONTO").Select
    Cells.Select
    Selection.ClearContents
    Range("A1").Select
    ActiveSheet.PasteSpecial Format:="Unicode-text", Link:=False, _
        DisplayAsIcon:=False
End Sub

Thanks again!

As a project I've taken on, I am trying to figure out how to import data from a Word Document form into Excel. Unfortunately, because there is a lot more text in the word document besides the information that I need, it is very difficult to extract what I need to. For example, the form says, "Full Name" and then there is a spot for the individual to put their name. It then says, "Preferred Name" and then there is a spot for the individual to put their preferred name. I only want the data entered by the individual to be imported. How can I do that?

Your videos have been a great help! Thanks

Great job Dan, Thanks for videos

Hello Dan..Thanks a lot for this video...
I would like to learn more about the VBA programs you have explained in this video. But i could not able to see the text clearly after run around 7 mins. could you please help on this, so that i can go through full video with clear text. please help me understand your information. Thanks in advance for your help!

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

It was very informative video.I am a beginner and want to learn VBA-Excel , so please provide other tutorial video. Thanks

uploading a video on how to open a link in Firefox, Chrome or internet explorer. Hope this helps you, you were my inspiration for this vid. Thanks!

You are a excel genius. How would you crate a hyperlink that opens in a nother webbrowser like Firefox, when Explorer do not work and is not certified to use??? Thanks Michael!