How To Open Excel In Vb Script? – InterviewSolution

InterviewSolution

1.	How To Open Excel In Vb Script?
Answer» ANSWER : SET xl=createobject(“excel.application”) set wb=xl.workbooks.open(“d:/sample.xls”) set ws=wb.worksheets(1) ws.cells(3,4)=”WELCOME” wb.save wb.close set wb=nothing set ws=nothing set xl=nothing

Discussion

No Comment Found

Related InterviewSolutions

What Is Sql Loader? Explain The Files Used By Sql Loader To Load File?
Explain Sga Memory Structures?
Explain Different Types Of Segment?
What Is The Function Of Smon?
What Is The Difference Between Vb Debugger And The Script Debugger?
Why Is The Use Of Exit Do Or Exit For Statements Within Loops Discouraged?
Write A Vbscript Procedure That Converts Feet To Inches. Hint: There Are 12 Inches In A Foot?
Assume You Have A Variable Called Age That Contains An Age Provided By The User. Write The Code That Ensures That The User Has Entered A Number As Her Age. If The User Hasn't Entered A Number, Tell Her She Needs To Enter Her Age Correctly?
Write The Code Required Within A Procedure To Create A Variable For Storing Your Name With Vbscript Code. Assign Your Name To That Variable?
What Aspects Of Vbscript Make It Safe So That A Web Page Using Vbscript Cannot Destroy Or Corrupt Information On A User's Computer?