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

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

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

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

Both onclick & href have different behaviors when calling JavaScript directly. Also the script in href won’t get executed if the time difference is short. This is for the time between two clicks.ExampleHere’s an example showing the usage of href vs onClick in JavaScript. Live Demo           ... Read More

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

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

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

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

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");