All Questions
18
questions
0
votes
1
answer
4k
views
Import multiple TXT files to one Excel csv sheet using Text Import Wizard macro?
I need to import data from approximately 30 individual TXT files into one CSV sheet. They are all formatted the same, so the Text Import Wizard should work. However, instead of running the Text Import ...
- 3
0
votes
1
answer
55
views
Macro - "Save As" original Workbook name
Intended actions:
Copy & Paste columns CA:CF from 123.csv to 123a.csv
Could anyone please assist with the "SaveAs" original workbook name with the appended "a"?
Thanks.
Sub ...
1
vote
0
answers
632
views
Automating Excel to save file as CSV and run live updates
For starters - I am raw and have limited skills, thus the guidance here is important to me.
We have to supply data to a 3rd party in CSV format. The data must be updated at frequent intervals with a ...
- 11
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
298
views
Excel Macro building: How do I pull .csv and .xlsx files from my downloads
I am working on a tool to help my business order products. Right now, We have a tool that pulls all of the .csv files from our downloads folder and add them to one excel work book.
I am trying to ...
- 1
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 ...
- 1
-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
790
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
1
vote
1
answer
89
views
Applying settings by default to CSV documents opened in MS Excel
End-users of a system we are developing are given a plain-old CSV file that end users will be opening in MS Excel. One of the columns will contain entries which consist of strings of numeric digits. ...
- 281
1
vote
1
answer
87
views
Macro exports date column to csv as numeric value rather than dd/mm/yyyy
The following code has achieved what I require except that the date [cell B2] is exported as as five digit numeric value rather than dd/mm/yyyy.
How to I amend the code to force B2 to export as dd/mm/...
- 21
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
1
vote
1
answer
1k
views
How can I write only certain rows of an Excel worksheet to CSV?
I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...
- 13
1
vote
1
answer
1k
views
How to export full data from excel as a csv using macro?
I want to export an excel file as a csv using macro, but my code is only exporting the header only. How to export the full data?
Here's my code:
Sub CSVFile()
Dim My_filenumber As Integer
Dim ...
- 11
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 ...
- 380
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