-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
csv to xls
-
L
How can I convert multiple delimited text files to xlsx using vba?
Hello, I'm wondering how I can convert multiple delimited text files selected from a dialog to xlsx using vba. I have used the select dialog before in a macro, but only for a single file. I know how to set the multiselect option. The question really is how can I get vba to convert all of the...- leknowlton
- Thread
- Replies: 1
- Forum: Excel Questions
-
S
Batch process csv files
Hi Folks: I have several files in D:\Folder3 and I wish to delete column N:P and rows 15:38 and then save the files as .xls in the same folder. All files have only one sheet and I use excel 2000. Any solution? Thanks- Suryaprakash
- Thread
- Replies: 5
- Forum: Excel Questions
-
M
copying data from a .csv to a .xls
Morning all - silly question really - just getting back into excel with a couple of years off! What's the best way of copying data from Column A, Sheet 1, Book 1 (.csv) to Column A, Sheet 1 Book 2 (.xls)? What's the best and recommended way of doing so?- mas_lerdanch
- Thread
- Replies: 4
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...