vbscript to create a folder
handy script to create new folder, will check folder exisiting or not before create.
vbscript to copy files
copy or rename files Handy copy or rename files vbscript. test script you can copy files from source folder to target folder, or rename specific file to target file in target folder, here is test script.
vbscript to delete files with wild character
TestFiles First we check any file existing nor not before delete them, will generate a vbDirectory according to file pattern, then go through one by one until hit first file, return True. script to delete number of files under one folder test sample This is test sample to delete all …
vbscript to delete folders with wild character
Deleting a folder in vbscript is easy but how to delete number of folders like folder patten test*\ ? TestFolders First of all, we need to check any folder existing or not for folder pattern. DeleteFolders Then we can safely to delete folders. test sample We have sample1\, sample2\ under …
How to generate zip file using 7z in Execl sheet?
There are many vbscripts to generate zip file from one folder, however for me this is fast and easy way to create zip or 7z file. function zip test script Here is test script.
How to open folder in File Explorer from Execl sheet?
Sometime need to open a folder File Explorer, this short script will help.
How to return selected rows array in Execl sheet?
I need to process some data for selected rows in vbscript, I don’t care the exactly selected area, only care about row numbers, so develop this function to fill this common purpose. The result returns as vb array, index starts from 0. Few concepts here for selected area: Selection: consists …