1. C

    CSV Import while skipping "column" data from CSV

    OK...I have some code that imports a csv into a sheet, but I don't want ALL of the data... I need to be able to skip certain "fields" in the line string from the CSV. How can I accomplish that with the below? Sub ImportCSV(customerfilename, unitnam, targetSheet) Dim rw As String With...
  2. U

    Import last row of csv to excel

    Hi! I really need your help. I got one file named - "TargetScan Data.csv" (source file). File contains 10 (static) columns and dynamic rows. Each day one row is added. File is on D:\OneDrive\TargetScan and What I want: I want to be able to import last row to my "File.xlsm' file (destination...
  3. D

    Appending Data from Web Data Connection to a Table

    There is a CSV data source online that publishes the latest data on COVID-19 cases in Austria. COVID-19: Überblick - data.gv.at The CSV file consists of one row with the latest number (cases, recovered, hospitalized, deaths, etc). I connected the data to an Excel file as a data connection...
  4. M

    Load cumulative data from Web .csv data Query to Excel table for a different Parameter Date each time

    Hi all, I hope everyone is keeping well during these difficult times! I have an Excel Power Query question and I hope someone is able to help me! I created several connections in Power Query which are currently 'connections only' within Queries & Connections. All data is being imported from...
  5. J

    VBA to open a CSV, average data and return the result to textbox in userform

    Hi all, I'm looking to have a button in a userform. Once pressed, allow the user to select a CSV file and open it. The code then needs to take an average of a specified range, for example B2:B14 and report the result in a textbox in the userform. The CSV can then close. Note, the file...
  6. J

    Importing data from a lot of differente .csv files

    Hello guys, I'm new at the forum and i'm looking for some help solving my problem. I have a lot of different .csv files with data - 1 file per day named with the date, for example: 2020_03_23_data.csv. What I need to do is something like: give the input of the day, month and year I want to...
  7. L

    VBA to gather data

    Hi, I have a folder of CSV files downloaded from yahoo finance and I have written code to get data from each of them. It took a long time and is a lengthy process if I want to add another 5-10 files. The code is below. The first block is some preliminary set up then the 2nd, 3rd and 4th are...
  8. F

    How to make Macro read the current folder and change tabulation ?

    Hi All I have a macro in which I have to change the folder adress everytime I want to convert CSV to XLSX. how do I make it read the folder that I copy the excel file in it ? and how do I convert the tabulation of those CSV file that have semicolon ; to xlsx with separate columns ? this is my...
  9. P

    Transposing data in column B as rows for 59 csvs using VBA

    I have 59 csvs in the same folder that contain field names in column B. A1 contains just the filename. The csvs need to be set up in a certain way to facilitate data migration to a state database. I would like to transpose the data in column B as rows (for example, instead of field names in...
  10. F

    Activate csv file with partial name with VBA

    Every morning I need to open a csv file from a web based server, sort and filter the data, then copy the relevant data over to an Excel sheet. To make things even more interesting, only part of the file name stays the same. I prefer to not have to save the file as I am trying to make sure that...
  11. B

    VBA export to CSV error

    Hello all, I have the following code, but when this exports to a separate csv file, it comes up with an error message "File format and extension of xxx don't match. The filecould be corrupted or unsafe." Is there a way to stop this error message coming up, without going in and resaving it as...
  12. K

    How to Keep Leading Zeros in CSV File Format?

    Hello! I am trying to have a column of numbers include leading zeros so they all contain six digits. Scenario 1. I want all numbers in the first column to have six digits (if they already have 5 digits, add 1 leading zero, 4 digits = 2 leading zeroes, and so on). 2. When I follow a website I...
  13. V

    Multiple csv file importer

    Hello, I am trying to come up with a macro that imports multiple csv files to different sheets and using the name of the file as the sheet name. I also need to be able to select the delimiter and also Consecutive delimiters. I have found 2 variants, one that imports multiple files but does not...
  14. N

    Search multiple criteria for item

    I'm not sure how to word it, but here goes... I have two spreadsheets (1 old & 1 new) I need to compare specific criteria. I need to search the old CSV of parts and compare to the new CSV of parts and tell me if we have old parts that match the dimensions of the new parts. The CSV headers in...
  15. R

    Convert long text date in CSV to proper Excel date

    Currently exporting date into Excel in this format: Jun 22, 2019, 09:38 AM Update: the dates appear in each cell within the column (1 date per cell in a column needs to be converted into another column of short dates) Want to convert to: 22/06/2019 Have tried long way of Text to Columns and...
  16. H

    The extract range has a miising or invalid field name

    I borrowed some code that was in a worksheet that the people that came before me created... I have adapted it to work for me in another situation but I am wanting to modify it. Basically I have a data collection machine that creates csv files with information. I am wanting to extract...
  17. O

    Help with csv data import

    Hello, I am wondering if anyone can help. I am looking to do a data import from an excel csv. I want to use this for a table seating plan. On the plan, there will be upto 50 tables. Each table will have a title (table 1, table 2, table 3 etc). Under each table there will be upto 15 guests...
  18. J

    Issues with character encoding?

    What I have: A bunch of CSV files with data. Say 300k rows each one. CSV files: if opened directly, they're in the wrong encoding and characters don't show up as they should. There's no option to select which encoding to use or which should be the default for all files? What also doesn't...
  19. B

    CSV - Data format doesn't save

    Hi, I have a CSV and have formatted the date as DD/MM/YYYY but when I save the file and come to reopen, the formatting has gone, any idea why please?
  20. W

    Copy a file from a specific directory and make available in clipboard

    Good Morning All, I have searched Google long and hard for an answer to this question to no avail!! I need to copy a CSV file from a specific directory, and make it available to the clipbaord, so I can paste it later using ctrl + v. I have developed a Macro that manipulates an XLSM file then...

Some videos you may like

This Week's Hot Topics