csv

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

The question is in the title, but I've attached a screenshot\edit to sort of get at what I'm trying to do. Let me know if you need any clarification on what I'm trying to accomplish!

I’m trying to create CSV file with 52 columns. There is only data in field 1 and 8. There are no column headers and The problem I’m finding is after collimate there are no commas how do I create them please

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

Hi guys, Posting a lot on here so thanks for your help. The title should explain it all. I have a file name 'Growbots CSV' which i want all files to retain, but i would also like to add the values from two different cells to that text. the cells contain the words 'Film' (cell 1) and '50k'...

Hi All, I'm new here but figured some of you might be able to assist: I have been working with a excel file that has a large amount of macros written into it. In short, it takes 2 separate files that I receive everyday (csv and xls) and creates relationships between the two to make a pivot...

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

So I have tried so many different ways before reaching out to you guys. Is there anyway to have a CSV file with leading zeros in a number field that will not drop the zero when reopening the file?!

I have a code that is able to Append a range of data in a worksheet to an existing CSV file. However, I noticed that when the existing CSV file contains empty, but formatted cells beyond the end of the data range, the Append function takes into account those empty cells as well. For example...

Hiya I'm using the following function to open a UTF-8 csv file and save it safely as an xlsx file. I use this to preserve the foreign characters from corruption (which happens when I open it directly in Excel): Function wsUCF8_CSV_Worksheet(strPathFilename As String, Optional...

Hey, I have two issues, I have written this to save my workbook as excel then save a sheet as csv using the cells in one sheet as the name of the files, I run it and select my destination but the files are not saved, secondly I need to remove the " that appear at the start and end of each line...

Dear Sir or Madam: My name is Robert, and I am a middle school math teacher who wants to EXCLUDE specific worksheet tabs from being converted to CSV files. The specific worksheet tabs to be EXCLUDED are XLSX, Math Grades Messenger, Directory Paths, POW Grader and POW Grader Student List. Please...

Hello all, I need the macro created below to preform same action in subsequent rows, same column. I though the range copy method would work, but I am missing something. Sub RemoveHypens() Dim the_string As String the_string = Sheets("Gopher Items CSV Test").Range("E3") the_string =...

I have some random number of hyper links under column G. Clicking a link will open internet explorer downloads dialog box and asks to choose whether to open or save the CSV file. When clicking save button, csv file will be saved to default downloads folder. Here I need a macro to automatically...

Here's the question: is there a way to retrieve the range name created by the Import External Data feature? Now, here's a little background: I am creating a spreadsheet that will let me retrieve my bank credit card transactions in CSV format and then output a QIF file that I can import into...

i have this odd issue original CSV files have data in various columns ... if i rename the csv files to xls manually FIRST then open the file, i am able to delimit according to semi colon because apparently that manual rename moved all the data in column A however, if i rename the csv...

Hello, I am look for options how to read a CSV file with a certain structure (see attachment: csv_input.csv) and create a XLSX file from the data in the CSV with a specific formatting (see attachment: result_output.xlsx). https://drive.google.com/open?id=1XkMBWZQarR3Z9zTPU2VgJ0Z_PS7qNIon...

I have been playing with this code for a few days now. :mad: I have a spreadsheet that has about 10 tabs. Only 4 of the tabs I need to use for this code. I created a master sheet called "Quickbooks" to make uploading materials into QB easier for the team and save hours a week for the...

I'm trying to save first column of the each sheet as a separate csv file who's name depends on name of each sheet in work book. Once i'm done saving those sheets i want to open those files one by one to align the data in them. below is my code can you please assist how can i open files from same...

HI, I'm trying to run the following code from customized ribbon and wants to run this code for all sheets but when i do that it just skips the second case and exits the program. Can you please assist how can i make this to run in module for all sheets. I'm fairly new to VB and i really...