1. S

    VBA copy cells from csv file to next empty row on another workbook, no duplicates

    Hi all, I'm brand new to writing VBA code so need all the help I can get. I have got 'N' number of files located within a folder (for sake of argument use C:\Users\wthomas\Desktop\Data), with the files I need all following the same naming convention "MAL1234567 Data.csv". This folder will...
  2. S

    JSON to CSV - Repeat all row items

    Hello, I have a JSON file that I converted to CSV using an online converter. When I open the CSV file, I have all the data but some rows have blank cells that I want filled. (See image below) Notice how rows 2 through 8, and row 14 are single row items. However, rows 9 through 10 and the...
  3. D

    Parsing a word document into a csv or other machine readable format

    Hi all, I have a non-delimited text file of health data called "2013_data.txt". This text file doesn't have any structure to it and the only way to structure it into columns and rows is to use the specified fixed length positions for each variable as indicated by the data dictionary...
  4. A

    Making a text file with identical name & Path

    Hello all! I have some VBA that is creating a pipe delimited text file, but I am struggling to get the name correct. I have managed to save it in the same location, but attempting to name it the same as the excel file has failed. Any help would be greatly appreciated. Sub PipeDelimited()...
  5. I

    CSV exports and Windows Regional Settings

    hi all, I was complaining today to someone about his file formatting to realize that CSV file formatting depends on your regional settings in windows. I had this issue with exports having space instead of 1000 separator. Plot twist! I compared my regional settings on both work and home PC and...
  6. C

    Input a value in a cell IF another cell contains a value

    I think this is a tricky one. I have a sheet where I paste different amounts of rows every time I use the sheet. I want the cells below C2 to show "TEXT" only if the cells below B2 contains value as I show on the image. If I paste 6 rows below B2, I want 6 rows below C2 to show "TEXT" in every...
  7. A

    Complicated Excel Sheet including formula and VB Script

    Dear Experts I have a complicated issue for which I need your help. Attached is the csv file 01012020.csv Problem I need to import these csv files for each day of 2020 into an excel sheet and create an excel file filtered for each dept. So for example I have imported csv files from 01012020 to...
  8. S

    How to Import or link CSV with more than 255 columns in ACCESS?

    Hello, I have a .csv with more than 255 columns (395 exactly), I only need 3 columns but I cannot manipulate the source file manually, that is, I cannot divide it in two. The columns are: 131, 208 and 282 I have tried to do it by wizard but Access won't let me do it because it has more than...
  9. S

    Cómo Importar o vincular CSV con más de 255 columnas en ACCESS ?

    Hola, tengo un .csv con más de 255 columnas (395 exactamente), únicamente necesito 3 columnas pero no puedo manipular el archivo de origen manualmente, es decir, no puedo dividirlo en dos. Las columnas son: 131, 208 y 282 He intentado hacerlo por el asistente pero Access no me permite hacerlo...
  10. M

    Convert Bar and Comma Separated Values into a single row with one record per cell...

    I have example data that is structured as the below with aggregated values on the end in one cell. I'm hoping to split this out into each record if it is split with a comma, space or pipe. The intended output of it would be to use vba to show it the column with the separated values and then have...
  11. O

    Insert Data from a column (B2:B45) from csv file, via Dialog box opening from standard excel file ( xlsm )

    I want to Insert Data from a column (B2:B45) from csv file,directly via Dialog box (( to choose csv file )) , which opening from the standard excel file ( xlsm ) the CSV file called : StudentClass.CSV I've tried this : Private Sub importv_Click() Dim fd As Office.FileDialog Set fd...
  12. C

    Loop through range. Use range data as input

    I am struggling to add further functionality to my code. I would like for my code to run a loop through a range of dates, found in column "E:E", and thereby use this input into cell C2 and then perform the rest of my code - saving the file to CSV (SaveAsCSV()). The spreadsheet is such that it...
  13. X

    Exporting Certain Cells to a New CSV - with Custom Headers

    Hello, Does anyone know how I could create a button in my workbook to export certain cells into a new CSV file? For example, here is some data: Cell A1: John Cell A2: Doe Cell A3: Irrelevant Cell A4: Irrelevant Cell A5: Manager Name Cell A6: Job Title I would like to be able to pull cells...
  14. B

    File size cap when saving to csv?

    I am seeing really, really strange behavior right now. Would appreciate any and all thoughts. I created an excel file with 2500 columns and 100,000 rows and saved it as a csv to practice loading large csv files into Python using Pandas. I was able to load the 100,000 row file with pandas...
  15. I

    VBA: Edit HEX of Existing CSV Style File

    I have a file produced by a proprietary third party application that is effectively a CSV with one specific exception: the first 3 rows do not follow a tradtional CSV format. I can open the file in Excel, and the file represents itself correctly. If I open, hit save (changing nothing) and then...
  16. R

    Run-time error "1004" Method "SaveAs"

    Good day, I have the below REALLY simple code to save a sheet in a workbook as CSV for upload to a database, however I keep getting the Run-time error "1004" Method "SaveAs" when I try and execute it. I can't figure out what I have got wrong - any advise? Thanks Sub SaveCSV()...
  17. J

    Struggling to change the CSV format to comma separated from semicolon separated despite changing the regional settings etc.

    Hi guys, I would like to ask for a help related to saving the CSV file in the UTF 8 encoding with comma delimiter as so far I was not able to achieve this. I have tried to traditionally save the the excel sheet as CSV UTF-8, however when opening the file in Notepad++, I can see that the...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back