How to convert Excel to ODS using vbscript | convert xlsx to ods

Описание: How to convert Excel to ODS using vbscript | convert xlsx to ods

Microsoft Document :
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
'msgbox file.name
if fso.GetExtensionName(file) = "xlsx" Then
pathin = fso.BuildPath(currentDir,fso.GetBaseName(file)+".ods")
Dim excel
set excel = CreateObject("Excel.Application")
Dim workBook
set workBook = excel.WorkBooks.Open(file)
workBook.SaveAs pathin, 60
workBook.Close
excel.Quit
end if
next

Chapters:

0:00 - Introduction to convert xlsx to ods format
1:09 - Writing a program to convert xlsx to ods
2:09 - Execution of the program
2:52 - 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  
► 15. Specflow -    • Specflow Tutorials  
---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------

#xlsxtoods
#exceltoopenspredsheet
#vbscript