
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Amit Sharma has Published 38 Articles

Amit Sharma
647 Views
Please try using below script −Dim sapConn As Object \Declaring a connection object Set sapConn = CreateObject("SAP.Functions") \Creating an ActiveX object sapConn.Connection.user = "username" sapConn.Connection.Password = "xxxx" sapConn.Connection.client = "client#" sapConn.Connection.ApplicationServer = "Application Server” sapConn.Connection.Language = "PT" If sapConn.Connection.Logon(0, True) True Then //Checking connection here MsgBox ... Read More

Amit Sharma
175 Views
Copy the below code in PERSONAL.XLSM module of your workbook and then refresh −Private WithEvents App As Application Private Sub Workbook_Open() Set App = Application End Sub Try adding below code, in your module: Private Sub App_WorkbookOpen(ByVal Wb As Workbook) MsgBox "New Workbook: " & Wb.Name End SubRead More

Amit Sharma
331 Views
You can make use of split as below −// To split the text on carriageLocal Stringvar Array lines: = Split( {table.field}, Chr(20) );// To return carriage 1 less than the number of linesLocal Numbervar delimiters := Ubound(lines)-1;Let us see one more example, how to use split to divide a string ... Read More

Amit Sharma
759 Views
SAPUI5 provides different static mobile packages: sapui5-mobile-opt-static.zip or sapui5-mobile-static.zip. SAPUI5 supports two options for building mobile apps- it can be used as a web application loaded from a URL or it can also be developed as a hybrid app consisting of a native app wrapper.Example: PhoneGap and an HTML viewer ... Read More

Amit Sharma
140 Views
In JavaScript, variables are defined using the var keyword followed by the variable name. Before you use a variable in a JavaScript program, you must declare it. Variables are declared with the var keyword as follows.var rank;A data type isn’t needed in JavaScript. Variables in JavaScript are not handled like other ... Read More

Amit Sharma
504 Views
You can make the connection by using the name of Global variables. A Global variable can be defined by using this code:DATA matnr TYPE MATNR-> to create a global variable matnr. You can define DDIC structure or table like Tables: MARAIn Screen Painter, you can reference of fields of table/structure ... Read More

Amit Sharma
2K+ Views
HTML has various tags to format content, heading, align content, add sections, etc to a website. The most important tags for an HTML document is doctype, , and .doctypedoctype is the doctype declaration type. It is used for specifying which version of HTML the document is using.The HTML ... Read More

Amit Sharma
464 Views
With HTML, the essentials are doctype declaration, and . But, you will be amazed to know that a valid HTML document can work without the element. The doctype declaration will come always since it tells and instructs the browser about what the page is about.Let’s see an example; ... Read More

Amit Sharma
208 Views
Definitely, the following way of declaring multiple variables is more efficient:var variable1 = 5; var variable2 = 3.6; var variable3 = “Amit”;Suppose you need to add, remove, or update a variable, then you can easily do it.But with the following method, you need to do more changes. For example, on ... Read More

Amit Sharma
94 Views
JavaScript variables are not typed but their values do have a type. The same variable can be assigned new values.ExampleLive Demo var a; document.write(typeof a+"\r"); a = true; document.write(typeof a+"\r"); a = 5; document.write(typeof a+"\r"); a = "web"; document.write(typeof a+"\r");