import csv

I have a need to adjust a master excel file to accommodate a new process. I have a csv file that has data in A thru N with D thru K showing times in format h:mm:ss. This csv file is auto generated daily and will need to be imported into a master spreadsheet into a “data” tab keeping previously...

Hi, I have an excel where each time after the user bring it up, he or she would click in a button that call the procedure refresh(). Sub refresh() ThisWorkbook.RefreshAll Call timer End Sub Sub timer() Application.OnTime Now + TimeValue("00:10:00"), "refresh" End Sub On the...

I have a Transaction log as .csv file with a 22 digit tracking #. Import to excel 2007 gets me 9.400109898643E+21 instead of 9400109898643002777660. So all the info in the last 9 numbers is lost. Not just displayed wrong, a change of format and they are all 0. Is there an easy way to get excel...

I am currently working with a macro I found here My excel file currently sits in a directory with all the CSV files I need to import. The CSV information will get imported in column B starting in row 4. These are just single line information, so each csv file takes up one row. I then need the...

Hello All, Thank you for letting me join the community, I'm pretty new to building VBA script and am attempting to import a folder of 130 odd csv files in to an workbook and then with a second macro combine them into a single worksheet. The below code is what I am using to bring them into the...

Dear all excel super users I have a problem I would like you to help me with  I have the following VBA code, this imports data from a separate file name “query_export_results.csv”, and sort, format etc. In my import file (“query_export_results.csv”) I have added a new coloumn (L) which I would...

Hello, Im having trouble importing a csv file. The first row works fine, but the rest are all wonky. Here is a sample of the first and second row from the csv: "Order # ","Purchased From (Store)","Purchased On","Bill to Name","Ship to Name","G.T. (Base)","G.T. (Purchased)",Status...

I have a lot of CSV files (>150) all with the same columns (5) amount, separated with ";" and all with the same column data. Question: How can I get those files copied into 1 major file and then transform it into a .XLS file? Here the excel columns I want: <tbody> site_page_url domain...

Hello, I have a problem when opening CSV files and the data is all jumbled. I would like to open the file and have the data sorted like 'text to columns' but without doing it manually. I did create a macro to remove the delimiter but I need to simplify the process even more. Any help is...

Hello, I'm looking for the program that should able import CSV file into New Excel file, User will give the input to select which CSV file, and program should import purticular data in new excel file and data should be in user defined order., Thanks in advance..

I download data from a website as CSV file. When I open the data in excel, it automatically parses it into columns. My colleague who also has Excel 2013 opens the file and it shows up as one cell per row and if he tries to manually convert text into columns, he doesn't always get consistent...

I have a folder containing multiple CSV files and I have another folder containing an Excel workbook. I want to import all the CSV files from the workbook by the click of a button into seperate sheets (fx 3.csv will have sheetname "3" etc.) without having to specify which one to open. These CSV...

So Im not sure what to do with this. Im trying to make VBA to import any .csv files into excel. PLEASE HELP Someone told me to use this ' Open GetOpenFilename with the file filters. Fname = Application.GetOpenFilename( _ FileFilter:="csv Files (*.csv), *.csv", _...

Hi, I am trying to automatically import all text files (csv type) from a given folder. My code to pick the folder and loop through the files is working but the code (which was recorded during Get External Data) that is supposed to drop the data in my workbook is throwing an error: Run-time...

I need to import the text file DPLOTUS.csv from whatever folder the workbook that contains this macro is located. The macro below works great for me but when I give it to my fiance, the folder names will be different. What won't be different is the workbook AND the text file will be located in...

Hello: I have a semi-working macro that I discovered primarily with Recording. The premise is to have a main workbook with two buttons. One to open a dialogue box, navigate to a csv file, copy the contents, and paste into a predetermined tab of the main workbook. The second button does the same...

Hi there. It has been years since I wrote my last VBA code, and hence I would really appreciate some help. I've searched forums, but no matter what I do I can't get the examples I find to work. I feel kind of stupid and assume that this is a very simple problem, and I would be grateful if...

Hi all, I've got 170 csv files that I'm looking to compile into excel so as to analyse them, but am hoping to avoid having to do that one by one, adding each as a seperate tab. Does anyone have any ideas of how I could do this, e.g. a macro or script, or if there's an "add all as tabs" add-in...

Hello everybody, I am a PhD Student at the University of Freiburg in Germany.I manage csv data and I would like to import such data in excel and organize them in a worksheet. I have already written something in VBA but not really want I wanna do. I am searching for everyone who want help me or...