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..
you can watch tutorial to convert csv to excel and excel to csv at below link : th-cam.com/video/VDN9w6PBZIQ/w-d-xo.html For multiple files, you can send me email, I have a team to work on excel vba automation work.
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?
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
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
Amazing video very helpful... Can you please tell us how can we convert all files in the folder to binary format?
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 ?
Hi, Can this be used to save as a text file also?
Appreciable, very easy to undersatand
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.
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?
Tq Sir. Can you do a session about vb code to send a video file to whatsapp?
This is great for a noob like me. Thank you
Welcome
What is the code for convert multiple files
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..
Hi after creating one copy how to stop this like if already csv file is present
Thank You...How to convert vba file to excel..please let me know
I want excel to convert a particular range only from the file, how to specify the range
how to convert Excel file with multiple sheets? I want to convert multisheet workbook into csv(containing all the sheet data).
Thanks a lot! Super helpful
You're welcome!
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 :
th-cam.com/video/VDN9w6PBZIQ/w-d-xo.html
For multiple files, you can send me email, I have a team to work on excel vba automation work.
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?
powershell
Sir How to convert Excel 2007 VBA file to 'C'
Hi, is It the same for Excel to Text file?
Logic would be same........with some different code.
how to save as .csv utf-8
Thanks for the video
Pls confirm how to change .csv to .xlsb with the help of VB
you need to modify the code little bit.
@@ExcelDestination How to do that
@@ExcelDestinationkindly guide what changes to do
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
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
let me
Thank you so much!!!
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
@@ExcelDestination Here is the command error 1004
Tks
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?
yes, we can do that. Let me share the code soon.
@@ExcelDestination i need the same can u give me dad code? thanks
Hii shall we convert multiple files at time?