All Questions
29
questions
0
votes
0
answers
46
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
898
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 ...
- 15
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 ...
- 11
0
votes
0
answers
171
views
How to create custom Word dictionaries from .CSV files
I work with documents that use a lot of specific words that are flagged by the spell checker in Microsoft Word, such as scientific names of insects.
Ideally, I would take data in .CSV format, and be ...
0
votes
1
answer
61
views
excel 365 macro that previously worked fine is now saving tabs as CSV with 9999 rows even if the rows are empty, why would it do that?
update: I also just tried to do a plain old 'save as' on my tab manually and that also results in the comma rows appearing up to 9999.
When the spreadsheet is open I see no data in the rows that end ...
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 ....
- 151
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 ...
- 174
0
votes
1
answer
877
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 ...
- 1
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
888
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 ...
- 1
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 ...
- 101
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 ...
- 191
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 ...
- 1
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 ...
- 31
1
vote
1
answer
9k
views
Save Excel Sheet as CSV in UTF-8 Using VBA
I'm working on the following macro in excel, which loops through all of the Worksheets in a Workbook and saves each to its own .csv file. The issue is that I need it to save as a .csv encoded with UTF-...
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 ...
- 101
-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 ...
0
votes
1
answer
787
views
add space after nth commas in Excel, Notepad++, or emEditor?
Notepad++ 6.8.8
I want to be able to turn several lines that start like this:
0,2,3,45,67,89,01,234,567,890,123,4567,8901
0,7,8,9,0,11,12,13,14,151,162,173,184
x,z,q,r,n,f,t,a,e,f,z,n,a
into
0, 2,...
- 623
0
votes
2
answers
192
views
How can i change the directory in this VBA code? VBA "Excel to TXT or CSV"
I really want to change the directory of this code in Application.ActiveWorkbook.Path but i don't know where to put it.
Public Sub CharacterSV()
Const DELIMITER As String = "|"
Dim myRecord ...
- 61
0
votes
1
answer
362
views
Error running macro after trying to run it from pesonal workbook
So I wrote a macro. The scenario of use is:
I open a fresh and new CSV file downloaded from somewhere
My macro runs and does some magic with the data
Since I don't want to copy-paste my macro to ...
- 218
3
votes
1
answer
3k
views
Regex to find commas, excluding commas inside a string demarcated by double quotes
I would like to manipulate a closed .csv file without opening it through a button on an Excel AddIn. I am able to complete all the steps but am having a problem with finding a regex that would ...
- 31
0
votes
1
answer
2k
views
Export multiple (specific) worksheets to CSV files in a specified directory
I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected.
Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular file ...
- 1
-1
votes
1
answer
2k
views
Visual Basic and Excel data streaming in real time [closed]
I'm currently working on a program that runs in visual basic (not VBA). The program collects data from sensors and produces a data file (*.csv) of the information it collected after a certain stretch ...
1
vote
2
answers
3k
views
Changing DateTime format in multiple CSV files
I've got multiple csv files with this structure:
text, text, 01/27/2001 01:00:00 PM
I need to update ALL csv files with this datetime format:
text, text, 27-Jan-2001 13:00:00
Is there a known ...
- 125
0
votes
1
answer
4k
views
Deleting entire row in excel if missing data in certain column or columns?
I just downloaded a Micosoft CSV file from Google Contacts and I would like to modify it so that I can organize the contacts in my phone. I am going back to my "dumb" phone as part of an experiment of ...
- 370
0
votes
1
answer
6k
views
Macro to Import CSV files into Excel
I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
- 61
0
votes
2
answers
271
views
Extra blanks worksheets in looped import of folder of csv files
(This is a revision of a similar question)
I often import a folder of .csv files into the active workbook (the workbook with the macro), so I want to automate this with VBA.
I pieced together the ...
- 1,137
1
vote
1
answer
14k
views
Excel: change data source with macro
I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ?
Another acceptable answer to my problem would ...
- 727