GTU Visual Basic Application and Programming Question Paper June 2012
GUJARAT TECHNOLOGICAL UNIVERSITY
BE- Vth SEMESTER-EXAMINATION – MAY/JUNE – 2012
Subject code: 150706
Subject Name: Visual Basic Application and Programming
Total Marks: 70
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1 (i) Which are the functionalities of VBA? Explain All in details?
(ii) Give a short note on Event-Driven Programming?
(b) Explain All the VBA operators, its precedence in details with examples?
Q.2 (a) (i) Explain the Working of Range Object in VBA code for Excel Application? 05 (ii) Explain Check Box and Option Box. 02
(b) List out all the Date and Time Functions. Explain any seven functions in details 07 with examples?
(b) List out all the Math Functions. Explain any seven functions in details with 07 examples?
Q.3 (a) (i) Explain Multi-Dimension Array and Dynamic Array with examples? 05
(ii) List out all methods of MailItem Object for E-mail Messages? 02
(b) Explain the Handling of Incoming and Outgoing message using ItemAdd and 07 ItemSend methods with example?
Q.3 (a) (i) Explain CreateObject method with its all Application 05
Name and Object Type?
(ii) Write all cursor type and Lock types of Recordset in ADO database 02 connection?
(b) Explain OPEN method with syntax of ADO recordset in details? 07
Q.4 (a) Explain Do.. .Loop and While.. .Wend in details with examples? 07
(b) Explain On Error statement in details with examples? 07
Q.4 (a) Explain For…Next, For Each…Next and If…End if conditions with examples? 07
(b) Explain Msg Box and Input Box in details with Examples ?
Q.5 (a) What is the Private and Public Procedures? Explain its Scope and syntax 05 with examples?
(ii) Explain Selection Object in Word Application?
(b) Explain all the following methods of DOCUMENT Objects of word 07 Application in details? [ Add, New, Open, Close, Save, Save As]
Q.5 (a) (i)What is the Function? Explain in details with examples?
(ii) Explain Range Object in Word Application?
(b) Explain Addnew,Update and Find Method of ADO Record set with 07 Example?