How to Remove Excel VbaProject Password in XLSM file

1. open XLSM file with 7-Zip
export/drag xl/vbaproject.bin file somewhere in your computer

2. edit exported file vbaproject.bin with HEXEditor

find/replace "DPB" with "DPx"

save and import back it into 7zip xl/vbaproject.bin location
close 7zip.

3. open file with excel, it gives error press OK.
press F11 to open vba editor.

4. in Tools Menu > VBAProject Properties > Protection (T)
Uncheck: Lock project for viewing.
ok and save.


We are Done 😊

Abdul Qadeer

Database configuration formula | Maximo

Formulas are introduced from Maximo 7606 on ward, which leveraged us to make calculation related things easier as we were already doing it through auto scripts.

Although it is not new after 761 release but still not very common.

There are 2 types of DB formulas; attribute formulas and Object level formulas.

Below mentioned is one example of Attribute formula in database configuration.

In this example we write a simple Excel style IF condition formula.

IBM Cognos Contents for BI Report Development

What is Cognos connection

Examine Cognos connection UI elements – create a URL, Login, Logoff

Entry properties: General Properties, Permission, Report, Query, Analysis, Job, Agent and Page Properties

Navigation – Public and Private Folder

Open reports with report name, Go to links, Run reports from a view

Run Reports – Prompt Pages, Printing a report and Open in excel

View the run history of a report and historical reports

Closing and creating quick links to reports – my folder

Shortcut and browser bookmark

Metadata Modelling

Introduction to framework manager

Framework manager basics

User interface, navigation, objects