csv import

Using Excel 2007. Having a few problems. I need to make a workbook that will automatically import a log file and present a few different charts to choose from. A user form will present options to view charts, print, email and save as pdf. I'm using FileDialog(msoFileDialogFilePicker) and...

Hi All, I'm new here so i apologise if i'm not posting as needed - please let me know if not...Ive done a search of previous threads and cant find anything that i can use. Ok - so here's my scenario - I'm importing a csv file (its bank statements so i'll be doing the same process monthly) -...

Hi. How do I get excel to not auto format my csv data to columns on import, without changing the *.csv extension to *.txt? I have tried to google an answer but did not find a solution. I would like all *.csv files to have to go through the "data to columns" wizard. THank you in advance, Jenny

Hi all, I'm very new to excel macros and VBA, but I am trying to write a macro capable of importing all .csv files from a folder into separate worksheets of a workbook. I wrote a macro for ImageJ that is able to produce a .csv data file for each image processed (these have a fixed number of...

I have a CSV that is received from another department that I pull into my workbook. One cell contains fractions and the inch mark followed by 17-24 spaces. I'm trying to pull from that cell to indicate what file I need to look in for the information and I'm not sure how the pull the...

I have tried several different code changes to convert this macro code to pull in .csv files instead of .xls files. Can someone help me figure out how to make this work? All of the other forums that I have found do not provide a solution that works. Thanks in advance. Public Sub PullData() Dim...

Hi Board Members, I need help in creating a Macro which will help me to pull data from Multiple CSV files (text CSV as well as XL CSV, I mean different types of CSV) from a destination folder. The CSV file names can be stored in a separate sheet as a List. The code has to pickup file names...

Hello guys :biggrin: I have a master spreadsheet with summaries, stats, and observations on about a thousand experiment results and ongoing. Each row corresponds to a unique experiment ID#. The instrument I use also generates a csv with the same name as the experiment ID#. I have tried several...

Hi Excel Gods, I am looking to tweak below VBA code to be able to open X number of CSV file (; delimited) and to have the CSV file in the excel workbook as text (All columns). The current issue is that all the information per sheet are whitin one col thanks in advance Sub test() Dim...

I am trying to design a macro to automate importing a csv file. I currently put the filename without the extension in column A. I currently have the macro so it lets you choose the file first, then loops through column A to find that file name without extension. I want to offset by one column...

I have a macro that imports csv-files into sheets with the same name in a workbook. All the csv files end with ".csv" except for one file which ends with ".CSV". The macro is importing the csv files that end with ".csv" fine. But when it encounters the csv file with ".CSV" it adds a new sheet. I...

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've taken a code I've found by a google search and tried to implement it for what I need but I'm getting an error Subscript out of range error can anyone shed some light on why i might be getting this error? If you need any further information please let me known. I need the data to skip top...

Hi guys, I have been working on a VBA macro to import a CSV file into Excel 2010. On the whole it has been successful with most CSV files however with one particular batch the first "column" looks like this item:45758:0:0:0:0:0:0 As such Excel is insisting on breaking the data up using...

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

I have written a getprice function for retrieving stock tickers from yahoo and bitcoin prices from an online api. However the code for bitcoin results in an #value! in my excel cell. But it performs fine when I run the function from the immediate box in VB. I sense it's some sort of...

I have a macro that is supposed to import a downloaded csv file into a worksheet in my primary workbook. Currently, it only imports the csv file if it has been opened and saved before importing. I apologize in advance if this has been answered in previous posts, but I couldn't find the right...

Hello, I am trying to upload 100+ csv files into MS Access, I am a amateur in VBA, could i possibly have some help writing the code? The file location is, D:\Users\UKVIV00003\Desktop\Clients, the file format i need to import is csv, and i require all fields to be imported. Also, what is the...

I'm not very experienced with Access, but a client is currently using it as a basic CRM system. They are pulling in some sales data from Quickbooks to create an entry for products sold (using the Serial number as the unique identifier). Then we'll be getting a ton more data from a form on their...

Hi! I have a piece of code that imports data from a database on the web. It works but the import uses the wrong encoding. Excel also messes up a column with id-numbers, starting with three zeros that are removed by Excel. How can a change my code so that it imports the data as utf8 and the...