How to Create a Blank Excel File and Enter some data then Save it

Hey Guys !! I am sharing the ways to handle Microsoft Excel Automation in UFT. usually we use DataTable Method, however it has its own limitations, hence we use Excel Object using VBScript.

Below is the Code for –

How to Create a Blank Excel File and Enter some data then Save it

I will add Next post on Excel Automation Later..

 

Quicktip: Just Copy this code and save it in a notepad file with file extension as *.*vbs and double click that vbs file and voila !! your excel file will be create with some text in it.

Do share your thoughts !

 

email
Related Posts Plugin for WordPress, Blogger...

Leave a Reply

Your email address will not be published. Required fields are marked *