GTU previous question papers
GUJARAT TECHNOLOGICAL UNIVERSITY
BE- Vth SEMESTER–EXAMINATION – MAY/JUNE – 2012
Subject code: 15 0706
Subject Name: Visual Basic Application and Programming
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1 (a) (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?
(ii) Explain Check Box and Option Box.
(b) List out all the Date and Time Functions. Explain any seven functions in details with examples?
(b) List out all the Math Functions. Explain any seven functions in details with examples?
Q.3 (a) (i) Explain Multi-Dimension Array and Dynamic Array with examples?
(ii) List out all methods of MailItem Object for E-mail Messages?
(b) Explain the Handling of Incoming and Outgoing message using ItemAdd and
ItemSend methods with example?
Q.3 (a) (i) Explain CreateObject method with its all Application
Name and Object Type?
(ii) Write all cursor type and Lock types of Recordset in ADO database connection?
(b) Explain OPEN method with syntax of ADO recordset in details?
Q.4 (a) Explain Do…Loop and While…Wend in details with examples?
(b) Explain On Error statement in details with examples?
Q.4 (a) Explain For…Next, For Each…Next and If…End if conditions with examples?
(b) Explain MsgBox and InputBox in details with Examples?
Q.5 (a) (i) What is the Private and Public Procedures?Explain its Scope and syntax
(ii) Explain Selection Object in Word Application?
(b) Explain all the following methods of DOCUMENT Objects of word
Application in details? [ Add, New, Open, Close, Save, SaveAs]
Q.5 (a) (i) What is the Function? Explain in details with
(ii) Explain Range Object in Word Application?
(b) Explain Addnew,Update and Find Method of ADO Recordset with Example?
To download engineering ebooks, medical ebooks, management ebooks, free ebooks please visit www.kopykitab.com