vba & csv

I have a folder in C:\CSV\ where more then 6000 csv files are available and the more important thing is, every csv file has only one colum but many rows. Now i want to transpose all csv files and make it one file in excel where transposed data shown. there is no name of column and rows. Any one...

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...

I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet Sub EOD() Dim i AsLong For i =4To ThisWorkbook.Worksheets.Count...

I have some data points that are unique in each sheet and the same unique data points need to pasted as a value in the same worksheet but at different range I have write down following VBA code for copy paste in same sheet <code style="margin: 0px; padding: 0px; border: 0px; font-style...

Hi all! I'm super new to macros/vba and am working on a project for work that requires me to import csvs from a folder into a specific workbook. Each csv will need to go into a new sheet of this same workbook. I read around on the site to get the code I need to pull this off, but for some...

Hi Everyone, I have figured out some code to copy all the data from a table, create a new workbook, paste the data and then save the workbook as a CSV as the name of the original table the data came from. I now am trying to figure out how to save the file as a custom name from cell L23 from...

I have a series of addresses that are in the following format: 273 Winding Road Boyertown OH, 19512 16 Penn Lane Wayne PA, 19087 519 Conshocken State Rd Happy Valley PA, 15208 What separates the city from the address line is two spaces. I'm trying to figure out how to pull the City, State...

I want to create a VBA add-in that imports a CSV file, split the data columns into separate arrays and returns these multiple arrays to the sub that calls this add-in. Not sure what is the best way to go about this. For example, my data folder contains many CSV files where each has 5 columns of...

Hello I am trying to create VBA code where it extract data from the most recent folder in a directory and uses it to drop data to another folder. I got the latest file part working but i'm having trouble with the Vlookup portion i.e calling out the latest file. Here is my latest file code...

Hi, Im trying to detect duplicates on column("G") of my input workbook and by using lastrow of its data at column("E") to merge upwards by using & "" & after which it will delete the entireRow and this process continue until there are no more duplicates. I tried and also look up for many codes...

I created a code which can open a .csv file and copy data from .csv to an excel file without opening both.(It looks like not opening) Actually it works for excel files (.xlsx) but When I use a .csv file as below code it displays me an error message "SUBSCRIPT OUT OF RANGE". How do I solve this...

Hi Guys, I have an open binary excel file (named "Masterfile"). I badly need the codes where the macro will browse from certain Source Folder and import multiple files onto the binary file. There are 3 files inside the Source folder namely: 1.) Survey.xlsx 2.) Checklist.xlsx 3.) CB.csv . I need...

Hello, I have search far and wide to find a solution to this but was unable to. Maybe I am using the wrong keywords. If someone could point me in the right direction I would be truly grateful. I am trying to create an Excel macro to import CSV attachments from multiple emails into a single...

I have sheet1 with data, <colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody> BL11 FO204 GBC PBDCB BL10 FO204 GBP PBDCA BL13 FO202 GBB PBDCB BL11 FO206 GBC PBDCE </tbody> in Sheet2, Data Validation list, <colgroup><col...

Hi i have two set of data,one for training and another set is testing. Can i use this data for k-nn algorithm on this?If yes , can u let me know how to do this?? training data <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> timestamp c1 c2 c3 c4 c5 c6...

Hi, I have an output file from a device which is appended to each time the device is used. I then need to add some additional data to output in a separate excel sheet via some control buttons. My plan is to import the last line from the output csv in to a results sheet then add some qualifiying...

Hi. Hope someone can assist with the following. We have a shared folder where csv files are dropped on monthly basis. I need to identify the latest files with name File1 and File2. The file name changes each month as it ends with the month it is produced e.g. File1Feb18, File1Mar18...

Hi All I have a piece of code which simply copies data from all cells in one workbook and pastes it into a table in another. However I am finding that one column (Column N) which is in a "MMM-YY" format keeps changing the Year part from 17 to 18 when it paste values over. On the raw file all of...

Hi Guys, Here's a snap of my codes but it automatically paste the CSV file data on the data sheet. I was wondering if you could help me find the codes for GetOpenFile whereas the path file directory will open. After I paste the address, the macro will open the CSV file and paste everything on...

I currently have a template which I can upload onto our database system. This template is filled in with sales data across consistent products. The caveat is that the data that we receive from 3rd parties to put into the DB system can be in many formats e.g. Excel but worded differently, or in...