Good Morning,
Hope you are having a great day!
*Objective: I want to convert all the excel files (.xls,.xlsx etc) in a
folder to .csv files (with original file names) & place the csv file in
another target folder.*
I am not an excel expert, however I managed to write the below piece of
code. It converts a single xl file to csv but places it in my desktop.
Please help!
Public Sub xls2csv()
Dim varArrFile As Variant
Dim intCtr As Integer
Dim strFiles As String
Dim wb As Workbook
varArrFile = Application.GetOpenFilename("*.xls,*.xlsx", , "Select
file(s) to convert", , True)
If IsArray(varArrFile) = False Then
MsgBox "No file is selected, select a file to continue"
Exit Sub
Else
For intCtr = LBound(varArrFile) To UBound(varArrFile)
Set wb = Workbooks.Open(varArrFile(intCtr))
wb.SaveAs ThisWorkbook.Path & "\" & intCtr & ".CSV", 51
wb.Close
Set wb = Nothing
Next
MsgBox "The files are successfully converted into .csv format &
placed in target folder"
End If
End Sub
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
