csv

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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?
  11. 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...
  12. J

    Stop Date recognition when opening CSV file

    I have an file in csv format that has a field with page ranges in it such "3-4" or "6-10". When you open this into Excel, it converts it to a date. Once converted, I can't get it back to text. Any workaround?
  13. T

    PivotTable.TableRange is returning the wrong value!

    I am trying to determine the number of rows of data in a Pivot field. My code looks like this: Sub LookupCommon() 'A sub to populate the CSV file with common data Set WS1 = Sheets("5. Final CSV") Set WS2 = Sheets("4. PivotTable") Set MyPivot = WS2.PivotTables(1) Counter =...
  14. A

    Auto formatting issue...

    Hi guys, I have a CSV exporter which converts a PDF into excel where the PDF file has customer details like Name, Guardian name, House no, Gender etc., Now the problem is whenever i use the CSV exporter the zero in house no removes automatically For example: Actual data of House no in PDF...
  15. W

    Import CSV file into table.

    Hi guys, Hopefully you can help me out, i want to import an CSV file into an table. Normally i setup a connection and i use that connection to import the csv file. But more people are using this excel file and a person is using office 365 and the connection is not working in the new excel...
  16. D

    [VBA] How to close CSV file after importing data

    Hi, I have poorly designed a VBA macro that opens/exports .csv data to an excel... works fine but when I export - say 10 csv, I'm left with 10 csv opened... I am trying to extend the coding so that the VBA macro also closes the csv files - thank you Sub Macro1() ' ' Macro1 Macro ' ' Set...
  17. V

    CSV text copied to Excel

    Hello, I have a problem when I am copying a csv text from a .txt file into Column A - on some rows the data is split between col A and C. I don't want to use the import csv. function because this is part of an RPA process and I want to keep it as simple as possible. Basically, what I am doing...
  18. C

    How to refresh daily data with additional text included in date filename

    Hello, We have a number of CSV files which are created daily by our modelling software. I would like to import the most recent csv data into their respective excel sheets. Each csv file is saved in a single folder generated by the model. An example of the saved csv file are saved like this...
  19. R

    Editing imported data

    First, I should point out I'm using Excel for Mac. So I've gone to File, Import, CSV file, selected the file and it has imported successfully on my spreadsheet. I've also got a Macro set up so every few seconds it checks for updates and refreshes the imported data. I'm trying to make it so if...
  20. R

    Unable to save date in csv file if date is greater than 10

    I am having a macro which opens multiple csv files one by one, extracts date from the file name and store this extracted date in a new rightmost column in each file. Then the file is saved in the csv format. All the revised files are then merged in one file as database and then I perform various...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top