Wednesday, April 27, 2016

How to create new folder at runtime using excel VBA?

Maintain folder structure is a vital task in  automation projects. Sometimes, it is very essential to delete and create folders at runtime. to achieve this task user needs to add a code which will be create folder at runtime.

Since to create specific folder at runtime, user need to automate this task in excel macro itself. Automating new folder creation task not only maintain folder structure but also ensures quality of work if there are several several folders to be deleted and create at runtime.

Tuesday, April 12, 2016

How to delete a excel workbook from selected folder?

Delete specific workbook or excel file is a usual task in many reporting project. As a routine activity user needs to delete old report and create new one based on latest data. Performing delete activity seems to be very risky when it is a manual, specifically when folder contain several report with slightly change in names.

Since to delete old files from the specific folder, user need to automate this task in excel macro itself. Automating file deletion task not only accomplish 100% quality but also saves a lot time to delete old files if there are several files to be delete from the folder