csv file

Hi - I tried using a 'tool' / addon but when doing this - the xlsx file has the values but when there is leading zeros in a cell - the zero is stripped out by the addon so now I am thinking only a macro might be able to do this. I need something that would enable me to convert say 20 csv's into...

Hi all, Whenever I open a csv I get this warning message: Furthermore, my data shift's over to the right, there is an example below but the issue can be random - it may add lots of different empty rows and shift a few rows over to the right, or sometimes the data overlays the rows on top of...

I'm in the UK and am trying to interface our database system with Excel in order to comply with some new tax legislation (MTD - Making Tax Digital). What I want to do is make an excel file with 3 worksheets - Income, Expenditure and Analysis. I can generate all of the data in three separate csv...

Hello! I have a issue with making a code that will extract the data/table from the csv file to a designated Excel(.xlxs) file and sheet. The thing is that the full table is only visible when .csv file is open with Excel Power Query option (Data--> From Text/CSV). So i tried to make some code...

Hello I have an excel sheet in which I regularly need to import data that is in *.csv format. I would be very grateful if someone can provide me a VB code where I can import in a query all these csv files into the existing Excel file. I have been able to find code where the codes *.csv files are...

Hello, I'm developing a project where I must update a web connection (CSV file) and return some of the updated data. For updating the connection I use RefreshAll function. In the first tests, using Office 365, it worked perfectly. However, when the tests using Office 2016 started, there was a...

My code opens 7 new workbooks and saves them as CSV files without closing them. Later in the code I need to activate the relevant CSV file to post data into it. However, I can't seem to activate the appropraite CSV file. If the files are saved as FileFormat:= xlNormal the code runs perfectly...

Does anyone know how to link an csv file to an Access database? I can link xlsx or a text file, but not sure about csv. Thanks

I have a workbook (BoardTime.xlsx) tracking board member time. Each board member will send me a CSV file with their information for a period of time (CSVExport.csv). I need to copy the data from columns A through E from CSVExport.csv starting in cell A2 to a worksheet in BoardTime.xlsx named...

Hi. I occasionaly download a .csv file which contains exactly one year of 1-minute interval data, held in 8 columns (A to H) and copy the data that I do not already have into a Master .xlsx file. The csv data looks like this: <tbody> A B C D E F G H 1 Timestamp Z1 Z2 Out Flo EnC Enp OpMo...

Hi I would like to create macro that imports the newest CSV file. The file name is changing every day and is located in Z:\ drive (no folder here). This folder holds two different file types with same name (.FLG and .CSV) So far I’ve got to the error stage ’Run time error 1004’ file could not...

I revised the URL as follow so that download the CSV file from Yahoo Finance history data, but there are occur error 1004 after "End With". Anyone solve it? Thank... Sub GetStock(ByVal stockSymbol As String, ByVal StartDate As String, _ ByVal EndDate As String, ByVal Kbar As String) 'Get and...

Hi, I wonder whether someone could help me please. Using a script I found online as a 'base' I've written the query below. Sub Test() Dim wb As Workbook Dim ThisSheet As Worksheet Dim NumOfColumns As Integer Dim RangeToCopy As Range Dim RangeOfHeader As Range 'data (range)...

Dear people at MrExcel.com Some years ago I did some programming in Excel VBA. Now however I am quite rusty in this department. I hope someone can push me in the right direction in order to write a procedure, which will automatically manipulate a certain Excel file, containing more than a...

Hi Was hoping that someone might kindly help me with the following. I found the code below for importing csv files into a single sheet and adapted it slightly. It works great except that if two files have exactly the same column it only keeps one of them while I want all the files imported as...

I have a .csv file with dates in the first column. The date format is US i.e. mm/dd/yyyy HH:mm:ss. I am working with UK date format (dd/mm/yyyy HH:mm:ss) and need to convert the date format. I have tried the following and neither works: 1) Data - From Text - (import .csv file) - Under Text...

Hello I need to finalize this script to copy paste data to my "H:\x\x.csv" file, ideally on column B of csv file. My script works fine till command move cursor 3, 14, (see red line in code) which is actually the data I need to copy paste to column B of my CSV file Any help? Thanks, Sub...

Hi Everyone, I am trying to create a macro that will allow me to selected multiple CSV files in a folder to import into an EXCEL spreadsheet. The CSV files are already in an EXCEL worksheet after being downloaded from another database. There are four columns of data in each file that I want...

Trying to query a csv file (have to average the records as I'm pulling the results in, averaging over simulations (say 2000 in a file) each of which has ca. 27 groups which need to be reported separately. I have this code which works, but it fails if the csv filename is >64 characters. Sub...

I would like to import data in an email on gmail to a spreadsheet in excel. what would be the easiest way to do this? any help would be greatly appreciated.