發表文章

VBA Insert top border for a row when cell content is different from the last row.  Sub Macro1() '     Dim strText As String     Dim strText2 As String     i = 2          For i = 2 To 4000              strText = Cells(i, 5).Value         strText2 = Cells(i + 1, 5).Value                  If (strText <> strText2) Then                      Rows(i + 1).Select                      Selection.Borders(xlDiagonalDown).LineStyle = xlNone             Selection.Borders(xlDiagonalUp).LineStyle = xlNone             Selection.Borders(xlEdgeLeft).LineStyle = xlNone             With Selection.Borders(xlEdgeTop)          ...

Type-over text (Overtype mode)

Applies To : Project Standard 2007 Excel 2007 Word 2007 Outlook 2007 Access 2007Project 2007 Typing text become overwrite in Word Try to use INSERT key but still not working as expected? Try to disable in option. On the File Menu Click Options Click Advanced Uncheck the option " Use overtype mode " Reference: https://support.office.com/en-us/article/Type-over-text-Overtype-mode-2fe125af-505f-4ce7-bbea-f0e64e381e75?ui=en-US&rs=en-US&ad=US&fromAR=1#bm14

Change the Normal template (Normal.dotm) - Make changes on default word document styles and layout

Applies To : Word 2016 Word 2013 Word 2010 Word 2007 The Normal.dotm template opens whenever you start Microsoft Word, and it includes default styles and customizations that determine the basic look of a document. On the File tab, click Open . Go to C:\Users\ user name \AppData\Roaming\Microsoft\Templates. Open the Normal template ( Normal.dotm ). Make any changes that you want to the fonts, margins, spacing, and other settings. You can use the same commands and features that you use to change a document — but remember that any changes that you make to Normal.dotm will be applied to documents that you create in the future. When you have finished, click the File tab, and then click Save . NOTE : If Normal.dotm is renamed, damaged, or moved, Word automatically creates a new version (which uses the original default settings) the next time that you start Word. The new version will not include any of the customizations that you made to the version that you renamed or move...

FND_GLOBAL.APPS_INITIALIZE

FND_GLOBAL.APPS_INITIALIZE is used for initializing the session before calling any public or private API’s in Oracle Ebusiness suite. Its not required for all the API’s but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND_GLOBAL.APPS_INITIALIZE function fnd_global.APPS_INITIALIZE(user_id=>l_user_id,                            resp_id=>l_resp_id,                            resp_appl_id=>l_resp_appl_id); l_user_id is the fnd user ID which will be utilized during the call. l_resp_id is the responsibility ID l_resp_appl_id is the responsibility application ID. You can use either sysadmin or use some user who has all the above listed responsibilities. For SYSADMIN, utilize the following query to get the respective values select fnd.user_id, ...

常見易明既日本地圖 (未計北海道)

圖片
常見易明既日本地圖 (未計北海道)

Move file in Oracle PL/SQL

Here is a example of dynamically define directory in PL/SQL, then use file utility UTL_FILE to move or rename a file. -- Defined DIR SELECT * FROM ALL_DIRECTORIES -- mv file DECLARE   vdir VARCHAR2 (255); BEGIN   vdir := '/source_dir' || '/sub_dir' ;   EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY SRC_DIR AS ''' || vdir || '''' ;      vdir := '/dest_dir'||'/sub_dir';   EXECUTE IMMEDIATE 'CREATE OR REPLACE DIRECTORY DEST_DIR AS ''' || vdir || '''' ;      UTL_FILE.FRENAME( 'SRC_DIR' , 'src_filename.ext' , 'DEST_DIR' , 'dest_filename.ext' ); END ;

網上付款費用

最近用信用卡在網上付款,發現原來用渣打的 Master Card 付港幣需付 1% 手續費,付外幣(如美元)則需 1.9% 手續費。 反而用 Visa Card 付港元無需付手續費。 下次要學聰明些,避免無謂收費。