Thank you so much!!!
Appreciable, very easy to undersatand
Amazing video very helpful... Can you please tell us how can we convert all files in the folder to binary format?
Thanks for the video
Thank you for your tutorial.
I would like to use this could on a folder with for example 20 files with .xls extension and save them as .xlsx extension, how would I achieve this?
bro can you guide to create a command button in userform asking to export in specific format ie either excel file or pdf format only.
Thank you. I tried to adjuste the Code to Chance the file from csv to Excel. But unfortunatily it not worked... please can you do it concrete ?
how to convert Excel file with multiple sheets? I want to convert multisheet workbook into csv(containing all the sheet data).
Hi, this video is useful...can i have the video for converting Excel CSV file to excel binary workbook. main reason for my use is to reduce the file size of which contains nearly up to 4/5 gb to less than 50 kb -50 mb..
I want excel to convert a particular range only from the file, how to specify the range
Hi after creating one copy how to stop this like if already csv file is present
Sir How to convert Excel 2007 VBA file to 'C'
Hi, Can this be used to save as a text file also?
Hii shall we convert multiple files at time?
hi sir. can i have a code for convertion for multiple file of csv convert to xlsx.. i only see 1 convertion per vba
you can watch tutorial to convert csv to excel and excel to csv at below link :
czcams.com/video/VDN9w6PBZIQ/video.html
For multiple files, you can send me email, I have a team to work on excel vba automation work.
What is the code for convert multiple files
Hi, I want ask why I cannot save multiple sheets in single excel file by using the CSV format, after I click to save it, excel will pop out a dialogue, then I click yes. After I reopen it, just only one sheet had saved in my excel file. Otherwise, multiple sheets must be save respectively. Pls help me.....
You can use this code withing loop statement. However some r&d would be required by you. Try yourself. If not possible for you.........then send me email at exceldestination@gmail.com
Thank You...How to convert vba file to excel..please let me know
how to save as .csv utf-8
Tks
How to ask the path of file from a user
can you tell me excel to csv conversion. you just explain only excel to csv conversion
Csv to excel binary convert
Can we create a CSV file from excel with the values of the selected columns using VBA code? can you share code for the same?
Error 1004 bro,, when im done and double tap the Click to convert file
without looking at code, can't say anything. you can share your code at exceldestination@gmail.com
@@ExcelDestination i know now bro,,, thank you,, i just make small mistakes but now its perfect and i know
Private Sub CommandButton1_Click()
Dim wb As Workbook
Set wb = Workbooks.Open(Worksheets("Sheet1").Cells(2, 11).Value)
wb.SaveAs Filename:="C:\Users\Jonel Atendido\Desktop\csv2pdf\csv2pdf.csv", FileFormat:=xlCSV, CreateBackup:=False
wb.Close savechanges:=False
MsgBox ("workbook is converted into csv format")
End Sub
Hi, I would like to ask if I have more than two excel file change to CSV format. What should I need to add or change in your program?