Bulk Convert Multiple Excel Files [XLSX to XLS]

If you’re having lot of excel files in .xlsx format and you need to convert all those into .xls formats without opening each file one by one, here is a perfect solution.

Make your own excel converter using the below steps.

Open Notepad and copy the below code.

Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open(Wscript.Arguments(0))
objExcel.Application.Visible = False
objExcel.Application.DisplayAlerts = False
objExcel.ActiveWorkbook.SaveAs Wscript.Arguments(1), 56
objExcel.ActiveWorkbook.Close
objExcel.Application.DisplayAlerts = True
objExcel.Application.Quit
WScript.Quit

Save the file as xlsconvert.vbs (Please save it as .vbs file and not .txt file)

Now call this batch file using the following command. E:convertxlsconvert.vbs “E:convertinput.xlsx” “E:convertoutput.xls”

Note: In the above command, please change the folder path as necessary.

After converting the XLSX file into XLS format, it will be stored in the same folder.

Comments

How to lock any file or folder without any software.

With this trick, you can create a secure password protected folder in Windows which no one except you can access. To use this trick, follow the instructions given below:- 1. Open Notepad . 2. Copy and paste the exact code given below:- cls @ECHO OFF title computer-tricks-corner.blogspot.com if EXIST "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" goto UNLOCK if NOT EXIST MyFolder goto MDMyFolder :CONFIRM echo Are you sure to lock this folder? (Y/N) set/p "cho=>" if %cho%==Y goto LOCK if %cho%==y goto LOCK if %cho%==n goto END if %cho%==N goto END echo Invalid choice. goto CONFIRM :LOCK ren MyFolder "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" attrib +h +s "Control Panel.{21EC2020-3AEA-1069-A2DD-08002B30309D}" echo Folder locked goto End :UNLOCK echo Enter password to Unlock Your Secure Folder set/p "pass=...

The best free automation tools for Windows

When your job involves working on a computer, repetitive actions can be the bane of your existence. They're not only tedious, but also (even worse) time consuming. Fortunately, in case you're forced to execute the exact same actions over and over again, you can create macros (scripts) that will automatically do them for you. Let's say, for example, that every day you have to open your downloads folder; to do this, you would normally have to click on 'Start', then on 'Documents' and from there finally click on 'Downloads'. Using a macro, you could simply run a certain file from your desktop or (even better) use a key combination, and the download folder will be automatically opened. (Of course, this was very simplistic, but you can use macro scripts to perform much more complicated tasks.) Here you will find a list with some of the best automation tools on the market. These applications won't only help you improve your productivity with macr...

How to Deal With Your Drivers Issues

For those of you who are really new to this, drivers are software that make the connection between your hardware (motherboard, graphic cards, sound card, printer, etc) and your operating system. Each hardware component has its own driver (which works on specific Windows versions), and if you don't have the correct driver installed, the respective device will either run incorrectly or not run at all. So, after you've reinstalled Windows (or installed it for the first time), you are going to need drivers to make your computer fully operational. The first and easiest solution is to install them is by using the CDs that came along with your hardware. If that's no longer possible because the respective CD is no longer available or the drivers on it aren't compatible with your Windows version, you will have to improvise . My favorite solution in this situation is to use a combination of two programs: 3DP Net and 3DP Chip. Both of them are completely free and require ...

Amitsworld

Search This Blog