Automated Text Import in Excel with File Selection - The Easy Way - VBA

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 67

  • @amadouib
    @amadouib Месяц назад

    I'm very thankful. i was struggling on how to import data into a master sheet. the video is very clear. Keep going. Thanks

  • @motonanga12
    @motonanga12 Год назад +1

    Quick Question: How do you skip break line? The text file I am importing contains empty lines which is stopping the import process. no error but only a portion of the file is imported. Thanks for your help

  • @philipboakes2974
    @philipboakes2974 3 года назад +5

    Really helpful. The explanation is absolutely clear, have been a subscriber for a while now and glad I found your channel. Thanks.

    • @TeachExcel
      @TeachExcel  3 года назад

      I'm so glad you think so and thank you so much for following me and your nice comment :)))

  • @DuyenLe-kt3xx
    @DuyenLe-kt3xx 6 месяцев назад +1

    A very informative and helpful tutorial ever, I'm truly thankful.

  • @otisskinner2039
    @otisskinner2039 2 года назад +2

    I am trying to do what this tutorial teaches but my code fails saying that the object doesn't support this property or method. This happens at the point where the code to copy the wsTextImport.Worksheets(1).Range("A1").CurrentRegion.Copy wsMaster.Range("A1"). I even tried to specify the range as in Range("A1:Q100") but same result. The code does open another tab in the workbook I want it to but the copy paste never happens. Any help?

  • @TeachExcel
    @TeachExcel  3 года назад +1

    MY FULL EXCEL VBA COURSE (Beginner to Expert) [60% Discount]: www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_EzUTK5hhjWM
    200+ Video Tutorials - 200+ Downloadable Excel Reference Files - 50+ Hours of Content

  • @juliopaniagua7293
    @juliopaniagua7293 3 года назад +1

    I am learning a lot from you... but I still need to find a way to keep adding data (from more text files) to the same table... do you have a video about that?

  • @satishloke
    @satishloke 3 года назад +2

    great , simple, complete, to the point,

    • @TeachExcel
      @TeachExcel  3 года назад

      Thank you! I'm glad you like it!!

  • @stevenbrown1287
    @stevenbrown1287 Год назад

    How would I make it so the it doesn’t just start the text file at row 2 but also a certain column?

  • @yami39
    @yami39 11 месяцев назад

    I have a question. When I import a txt file, how do I treat my numbers as strings rather than a number? Because it automatically formats cell (in my case my number is converted to scientific).

  • @keitharaneta3465
    @keitharaneta3465 7 месяцев назад

    Hello, If the file being imported contains an empty cell, it stops further copying the proceeding contents of the file. how can this be resolved? thanks for the answer

  • @jeffanderson6740
    @jeffanderson6740 6 месяцев назад

    Does all of the data import as text?

  • @bhaskarroy3364
    @bhaskarroy3364 2 года назад

    Kindly announce the keyboard shortcuts that you are using while you are explaining, keeping up with the pace is just insane! Thanks and best wishes!

    • @TeachExcel
      @TeachExcel  2 года назад +2

      Sorry about that - usually the shortcuts will be: Alt + F11 to go from worksheet to VBA window and then Alt + F8 to view the macros to run from the worksheet.

    • @bhaskarroy3364
      @bhaskarroy3364 2 года назад

      @@TeachExcel Thanks! Although imI shouldn't ask it here, but, could you kindly tell me how to backtrack a calculated field on my excel pivot table so that I can check the vlookup functions that are running to display the data?

  • @OmkarThorat-u7m
    @OmkarThorat-u7m 10 месяцев назад

    Is there a way to do this from a pdf document?

  • @robertkaniewski3281
    @robertkaniewski3281 2 года назад

    Thank you so much.. Is it possible to import data to a specific row, e.g. no. 10?

  • @DagamerJc22
    @DagamerJc22 Год назад

    I want to do the same thing but the only difference is that my file has spaces between some rows and when i run the code, excel only reads a portion of the file up until it detects a space in a row. How can i change that??

  • @joeb253
    @joeb253 9 месяцев назад

    These codes hard to understand for beginner do you have videos make it easier.

  • @roor20
    @roor20 Год назад

    Excellent Tutorial! Well put together and thorough. I do have a quick question. Is it possible to bring the data in without disrupting the formatting with Workbooks.OpenText? I've tried to figure out a way but and getting stuck. Thanks!

  • @KWEDA27
    @KWEDA27 3 года назад

    How to import multiple different txt to different worksheets in same excel in automated way. pls help.

  • @Tech-h4i
    @Tech-h4i 3 года назад

    i need to auto update CSV data into excel file without opening excelsheet can you help me for this.

  • @fjnomad
    @fjnomad 3 года назад +4

    Great tutorial ! the only issue I have with this is importing csv . Even if I put StartRow : 2 or 3 it keeps importing the first row

    • @sandrodaniel2928
      @sandrodaniel2928 2 года назад

      omg I get the same issue

    • @HenareW
      @HenareW Год назад +1

      timestamp 08:30 re-write and apply below will fix your issue
      wbTextImport.Worksheets(1).Range("A1").CurrentRegion.Offset(1, 0).Resize(Range("A1").CurrentRegion.Rows.Count - 1).Copy WsMaster.Range("A2")

  • @mateomontoyanaranjo5948
    @mateomontoyanaranjo5948 2 года назад

    Thanks mate, this really helped me heaps

  • @jackiebanta1299
    @jackiebanta1299 3 года назад +1

    Hello, i love this video! Very helpful. Is it possible for you to add one more to this coding? Add the CSV file name that was selected in any cell. So when anybody else is looking at the excel file, they know where the data came from.

  • @Akbar-ux3bc
    @Akbar-ux3bc 2 месяца назад

    I did the same thing but when it came to uploading a huge CSV file, it imported but displayed unorderly in the sheet [Data]. Is it because of DataType:=xlDelimited,?

    • @Akbar-ux3bc
      @Akbar-ux3bc 2 месяца назад

      Oops, I found it. It was because of [Tab:=True]. I changed it into [Comma:=True]. Thank you for the good lesson.

  • @christopherlindsay1440
    @christopherlindsay1440 3 года назад

    This is awesome, but the code will not allow me to select where the file comes from (location). when I run the code, it automatically pulls up all the files on my computer, not just the text files in the location I put in originally with the "fileToOpen = "location of text file.txt". Do you have any advice on that?

  • @diwakarsingh2156
    @diwakarsingh2156 3 года назад

    for forward slash (\) what we take ?? Delimiter

  • @kannanmassey5783
    @kannanmassey5783 2 года назад

    Very well explained. Thanks a lot
    Current range selects only column A

  • @JadhavKeshav
    @JadhavKeshav Год назад

    If i want to run it several times , it gives the error of file name already exists

  • @solomong.gebrhana1204
    @solomong.gebrhana1204 2 года назад

    Hey, what if I want to automate importing a text file to a database table on MS SQL server Management? Please the key word here is "Automate", I know how to do it manually, but I want to do it automatically. Thanks a lot.

    • @xXNitemareXx
      @xXNitemareXx 11 месяцев назад

      Save As *.csv (MS-DOS) if you have that option. I have to reconfigure my analytical data and save the exported file as MS-DOS .csv or our SQL DB gets cranky.

  • @sachin0200
    @sachin0200 3 года назад

    hi sir, concept was awesome, i have one doubt , how we import (add) more data in same database without replacing old data. for eg:- you have prepared for 15 data and if we import another file in same database staring from 16th data or next from 15th data...pls reply sir...

  • @BUSINESSRESOURCES130
    @BUSINESSRESOURCES130 3 года назад

    Thanks so much for this excellent video. I create Excel systems for subscribers and usually I have them copy/paste input data. Now I can have them import directly from CSV/Text. What I want to know is how to append newly imported data to the first empty row (on the master) automatically. I imagine this might be a more advanced topic.

  • @diya2909
    @diya2909 Год назад

    If in a folder multiple text files are there then how to use this code sir

    • @xXNitemareXx
      @xXNitemareXx 11 месяцев назад +1

      You should make a separate output subfolder in the same file folder that holds the text copy of your converted original files. Give it a general import file name that will remain static within the code (i.e. IMPORT.TXT) but will be overwritten every time you save to it. This will protect your data files in their normal file folder by making a separate folder just for the import text file, and there shouldn't be as many duplicate files confusing things. The directory string will be mostly the same except your text file will have one extra string for the subfolder it belongs to, so make sure you account for each path string as it relates to the different syntaxes (open file path vs. save as file path).

  • @jcgaming9749
    @jcgaming9749 3 года назад

    This is an amazing tutorial, though I’m having issues with the leading zeros in numerical data in the CSV file not appearing and then not importing through to the destination file. Any tips on how I can fix this in the VBA code at all?

    • @mroberts2112
      @mroberts2112 2 года назад

      Leading zeros are not numbers, they are character strings.

  • @2750nav
    @2750nav 2 года назад +1

    INSTEAD OF SPECIFYING THE ROW NUMBER, IS IT POSSIBLE TO DEFINE A WORD, THE PROGRAM CODE NEEDS TO SEARCH FOR THIS WORD IN TEXT PAD, THEN IMPORT THE ROWS (SAY 10 ROWS STARTING FROM THE ROW WHERE THE KEY WORD IS SPECIFIED) EG: IN YOUR CASE "asc-39" this word is in 9th row 3rd column, write the codes with "asc-39" as key word, SO EXCEL SHOULD IMPORT ROWS 9 TO 16. I CAN PAY FOR YOUR SERVICE. THANK YOU IN ADVANCE FOR YOUR VIDEOS AND LESSONS.

  • @gaminxden11
    @gaminxden11 3 года назад

    You deserve my subs👏

  • @pj5151
    @pj5151 3 года назад

    Superb! Well documented and explained. Thank you

  • @omarrahim673
    @omarrahim673 2 года назад

    Great work, respected sir. Please export code for txt paper, as well as import code from txt paper. Thank you

  • @tubemanfredo
    @tubemanfredo 3 года назад

    It doesnt work with excel 365. Why?

  • @lucabottini9302
    @lucabottini9302 Год назад

    Thank you so much! No other words to say! =)

  • @yolo_burrito
    @yolo_burrito Год назад

    Are you still doing the premium course? The site seems sketchy the price on the site is $199 but checkout is $295. Also when I try to ask a question in the form it says error and asks me to contact a site administrator.

    • @TeachExcel
      @TeachExcel  Год назад

      Hi M. Port, where do you see the price for 199? And which forum are you trying to ask a question in? Have you tried to contact the site admin on TeachExcel.com via the contact page?

    • @yolo_burrito
      @yolo_burrito Год назад +1

      @@TeachExcel yeah, and they changed it. So scummy. I’m out.

  • @Harycan0
    @Harycan0 10 месяцев назад

    Unbelievable fantastic , supper , thank you .❤❤❤❤

  • @bvvenkatesh2992
    @bvvenkatesh2992 3 года назад

    Thank you so much for this video

  • @darrylmorgan
    @darrylmorgan 3 года назад +1

    Great Tutorial!! Really Enjoyed The Explanation For The Cool VBA Code...Thank You Sir :)

    • @TeachExcel
      @TeachExcel  3 года назад

      I'm glad you like it Darryl! I rather enjoyed making this one)

  • @alexrosen8762
    @alexrosen8762 3 года назад +1

    Super useful! Thanks :-)

    • @TeachExcel
      @TeachExcel  3 года назад

      You're welcome Alex! Glad you think so :)

  • @allensilva3066
    @allensilva3066 3 месяца назад

    Hello how about excel to notepad? 0:30

  • @ajitkumarverma4411
    @ajitkumarverma4411 3 года назад

    Sir i need to help . one folder there 3 to 4 txt file.
    how to these txt file data copy and paste in one excel . In text file separate by comma(,) columns
    Plz help sir how to implement this solution in vba

  • @vishp4tel_507
    @vishp4tel_507 3 года назад +1

    Thank you so much. Great explanation. This is my first time writing any sort of code and this helped me greatly with my task. Keep up the great work. 😊

  • @ravindrabisht7520
    @ravindrabisht7520 3 года назад

    How to open multiple .txt file?

  • @longthuy8311
    @longthuy8311 11 месяцев назад

    Good

  • @mdtanweer555
    @mdtanweer555 Год назад

    ❤❤

  • @dwayne9456
    @dwayne9456 2 года назад

    Question: Why are you answering questions of relevance to the topic- @otisskinner2039
    @otisskinner2039
    6 months ago
    I am trying to do what this tutorial teaches but my code fails saying that the object doesn't support this property or method. This happens at the point where the code to copy the wsTextImport.Worksheets(1).Range("A1").CurrentRegion.Copy wsMaster.Range("A1"). I even tried to specify the range as in Range("A1:Q100") but same result. The code does open another tab in the workbook I want it to but the copy paste never happens. Any help? among others?

    • @dwayne9456
      @dwayne9456 2 года назад

      Use this instead: wsTextImport.Worksheets(1).Columns("A1:Q100").Copy wsMaster.Columns("A1:Q100"). FYI this was from a beginer.