Скачать или смотреть How to convert Excel to CSV using vbscript | convert xlsx to csv

How to convert Excel to CSV using vbscript | convert xlsx to csv

Format microsoft documentation link
https://docs.microsoft.com/en-us/offi...

Code :

set fso = CreateObject("Scripting.FileSystemObject")
currentDir = fso.GetAbsolutePathName(".")
set folder = fso.GetFolder(currentDir)

for each file in folder.Files
if fso.GetExtensionName(file)="xlsx" then
pathin = fso.BuildPath(currentDir,fso.GetBaseName(file)+".csv")
Dim excel
set excel = CreateObject("Excel.Application")
Dim workBook
set workBook = excel.workBooks.Open(file)
workBook.SaveAs pathin, 6
workBook.Close
excel.Quit
end if
next

Chapters:

0:00 - Introduction to xlsx to csv
0:49 - Program for converting xlsx to csv
8:02 - Execution of the program
8:27 - end tags and subscription to the channel

Donation Section:
Now you can Donate us via Paypal or Google Pay
Paypal link : https://www.paypal.me/Azhar67
GooglePay/PhonePe/BHIM App UPI ID : shaikazharjamal@okhdfcbank

My second Channel:
WrestleTalkByAzhar -    / wrestletalkbyazhar  

Next Steps :

---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------
Must Watch Playlists

► 1. Javascript -    • Javascript Factory  
► 2. Puppetter -    • Puppeteer  
► 3. Cypress -    • Cypress  
► 4. Tech works -    • Видео  
► 5. Vbscript Basics To Advanced -    • VBScript Part 1 -  Features Advantages Dis...  
► 6. Jmeter -    • Jmeter Tutorials  
► 7. Excel -    • Videos On Excel  
► 8. Appium -    • Appium  
► 9. Shares -    • Shares  
► 10. Javascript Interview Questions -   • Javascript Interview Questions  
► 11. C# Tutorials -    • C# Factory  
► 12. HTML & CSS -    • HTML & CSS  
► 13. Browser Console -    • Browser Console  
► 14. JSON -    • Videos on Json  
---------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------

#xlsxtocsv
#convertxlsxtocsvinvbs
#vbstoconvertxlsxtocsv