Thursday, September 16, 2010

Display Maximo System info in IE title bar

in the Installserver.cmd file edit the following

Use the JVM parameter -Dmxe.name= to name each server, where
is the name that you use to identify the server.

set CMDLINE="%JAVA_VM% %MEM_ARGS% %JAVA_OPTIONS% -classpath \"%CLASSPATH%\" -Dmxe.name=UI2MAN1-372 -Dweblogic.Name=%SERVER_NAME% -Dweblogic.management.username=%WLS_USER% -Dweblogic.management.server=\"%ADMIN_URL%\" -Dweblogic.ProductionModeEnabled=%PRODUCTION_MODE% -Djava.security.policy=\"%WL_HOME%\server\lib\weblogic.policy\" -Dcom.sun.xml.namespace.QName,useCompatibleSerialVersionUID=1.0 -DJMSQSEQCONSUMER.SEQQOUT1=1 weblogic.Server"

REF:http://www-01.ibm.com/support/docview.wss?uid=swg21366402&aid=4

Thursday, September 2, 2010

Delete all hyperlinks on a sheet in Excel

REF: http://www.techonthenet.com/excel/macros/delete_hl.php

Question: I've had a hyperlink problem in my Excel files for ages: false hyperlinks had crept in (even in empty cells) and were multiplying regularly whenever I inserted new lines. How can I delete all hyperlinks in a sheet at once and not have to delete them cell by cell?

Answer: You will need to create a macro to delete the hyperlink addresses in your Excel sheet.

Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press -F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Paste the following code into your new module:

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.

Now, go to the sheet that contains the hyperlinks that you wish to delete.

Under the Tools menu, select Macro > Macros. Highlight the macro called "RemoveHyperlinks" and click on the Run button