All Questions
26
questions
0
votes
0
answers
47
views
How to append multiple .csv into one .csv (not multiple sheets .xlsx)?
Looking to do something like this:
Is there a script that can do that? I've tried searching and the scripts are either 404'ed or they merge them into a single .xlsx with multiple sheets.
0
votes
0
answers
919
views
How to import multiple csv-files in Excel at once with VBA
I am trying to import multiple csv-files within the same directory into my Excel sheet using VBA. The following code is working very well with just one csv-file. But I lack the knowledge to adapt my ...
1
vote
1
answer
1k
views
Excel - CSV file formats Date column in different ways
I am working on creating a personal finance dashboard and therefore integrating different CSV files downloaded from different sources into one big table.
The problem I am facing is that the date ...
0
votes
1
answer
5k
views
Excel VBA save to CVS file
I have an excel file which has a macro which saves the file as a .CSV file. I have a program that calls on the CSV file but the program only recognizes the .CSV file if I open it manually and save it. ...
2
votes
1
answer
3k
views
Converting excel files to UTF-8 .TSV
Every week I have to convert 25 or more Excel files to UTF-8 .tsv files. As of now I'm doing it using Editplus application manually.
I was searching Google and other sites where I'm getting UTF-8 ....
1
vote
1
answer
159
views
Merge CSV Files Error 1004
So I am trying to make a macro that will merge multiple .csv files into one excel worksheet. I used the following tutorial for it:
vba code
However, once I put in the correct path to the .csv files, I ...
0
votes
1
answer
882
views
How to export/update CSV file through Excel Macro?
Thanks in advance for any help!
I have a file that produces an output table that also contains a unique key for the set of data. I want to be able to export this data into a CSV file.
That is easy ...
0
votes
0
answers
181
views
Multiple excel data copy into one excel
I have multiple CSV file data i need to copy all CSV data into one excel based on the cell value Like
Source excel sheet1 B2:C2 to till end row data i need to copy Target Excel Sheet3 Column B2:C2 ...
0
votes
1
answer
893
views
Excel VBA index match a csv import
How can I use an index match function in VBA to find values in a CSV file then import those values to the matched index in a cell in Excel? Say I have a CSV file which contains the following comma ...
0
votes
0
answers
1k
views
Set Custom Path While Exporting in VBA
I am using this post's accepted answer for one my exports.
Based on the answer, it saves my exported .csv file in my C:\Users\username\AppData\Roaming\Microsoft\Excel\XLSTART.
However, I need this ...
3
votes
2
answers
2k
views
How do I clean ~500,000 records in Excel 2010 without crashing my PC?
I have to remove large chunks of information from tables in .xlsx files using Excel 2010. Every method I have tried so far has produced no results, either crashed or I've killed it after waiting for a ...
0
votes
1
answer
3k
views
How to update a CSV file whenever an Excel cell value changes
I have an Excel file that is linked to an application that updates the file a few times per minute. I would like to save the Excel contents (22 rows of 5 columns) to a CSV file whenever the contents ...
2
votes
1
answer
15k
views
How to automatically import data from csv file and append to existing Excel table
I have a .csv file and a master excel file. The master file contains a table and I would like to automatically append the data in the .csv file to the existing table. The data has the same headers and ...
0
votes
2
answers
4k
views
vba outlook save attachments in csv format
I'm trying to save a spreadsheet attachment in CSV format.
I can trigger the process when a spreadsheet attachment is found but I'm having a hard time combining that with a conversion script which ...
-1
votes
1
answer
1k
views
Convert multiple excel worksheets to .csv
I found this macro for converting multiple excel worksheet in a workbook to individual named .csv files, but don't know how to remove the workbook name from the converted file name. I'm sure its ...