Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. JoeSchepis

    Problem opening/reading text files into worksheet

    Thanks Skip! You're my vote for TipMaster of the week!
  2. JoeSchepis

    Problem opening/reading text files into worksheet

    Skip, Yes, I caught that! This fix works! In the end, the final code is: Private Sub CommandButton1_Click() 'Button to read in STARTING torque values from Vibrac DET file Dim vFile As Variant 'Showing Excel Open Dialog Form vFile = Application.GetOpenFilename("VIBRAC...
  3. JoeSchepis

    Problem opening/reading text files into worksheet

    Gruuuu, I unchecked as you suggested but the the code crashes at the ".Refresh True" statement. Since I'm new at this, I changed to ".Refresh False" but I still get an error at that line. In both cases, the selected file is not imported. Joe
  4. JoeSchepis

    Problem opening/reading text files into worksheet

    Thanks to both Bubba100 and Skip. You both have a good appreciation for the problem but it persists so let me explain a little further... First, Skip is correct. I want to read the same data structure from multiple files to statistically and graphically analyze/review the data. The text data...
  5. JoeSchepis

    Problem opening/reading text files into worksheet

    Hi, I am creating an Excel workbook as a template. In this template, I have 6 worksheets defined. This first worksheet is a summary and contains VBA code (not working so well). In this code, I want to select and read in a text file (file extension "DET") and fill in the data into one of the...

Part and Inventory Search

Back
Top