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)
- 取得連結
- X
- 以電子郵件傳送
- 其他應用程式
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
- 取得連結
- X
- 以電子郵件傳送
- 其他應用程式
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
- 取得連結
- X
- 以電子郵件傳送
- 其他應用程式
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
- 取得連結
- X
- 以電子郵件傳送
- 其他應用程式
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 ;