Sub 마우스오른쪽버튼윗주죽이기()Dim i As Long, txt As StringDim ctr As CommandBarControlCommandBars("Cell").FindControl(ID:=1614).Enabled = FalseCommandBars("Cell").FindControl(ID:=1614).Visible = FalseEnd SubSub 마우스오른쪽버튼윗주살리기()Dim i As Long, txt As StringDim
Private Sub Document_New() For Each tb In ThisDocument.Tables tb.AllowAutoFit = False For Each col In tb.Columns col.Width = 50 Next Next For Each oTable In ThisDocument.Tables Dim oCols As Integer oCols = oTable.
Public Sub AllInternalPasswords()' Breaks worksheet and workbook structure passwords. Bob McCormick' probably originator of base code algorithm modified for coverage' of workbook structure / windows passwords and for multiple passwords'' Norman
while문을 빠져나가는 것은 여러가지 방법이 있습니다.먼저.. Do While문으로 고치면 Exit Do라는 구문을 활용할 수 있습니다.------------------------------------Do While exetime <> Data2.Recordset.Fields("시간") If Data1.Recordset.EOF <> True Then Exit Do End If
Excel VB 일력Private Sub Calendar1_Click()Range("A1") = Calendar1.ValueEnd SubPrivate Sub Calendar1_DblClick()Range("A1") = Calendar1.ValueCalendar1.Visible = FalseRange("A1").SelectEnd SubPrivate Sub Worksheet_SelectionChange(ByVal Target As Range)If
1. DB를 만든다.2. Tablespace를 만든다.3. User를 만들고 DBA 권한을 준다.4.새로 만든 User로 로긴해서 Table 및 기타 Object를 만든다.5. Data를 Export해서 새로운 DB에 넣는다.6. Export 필요없이 DB Link를 임시로 만들어서 Data를 넣어도 된다.(Data 건수가 많으면 나눠서 Commit후 이어서 넣는다.7.DB Characterset은 실제 DB와 똑 같이
DM1.EDA CELL.V01DM1EDA CELL.V1 Develop Multi Version Ex:) Big Version Ver:Bata.1.1 Doc Name Origin File:D03.EDA CELL_DEV_V01 Version Release:2011-10-19 Sub Version
if you can change the registry then close all BO windows, open the registry editor and find this: Code:HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 6.0\default\BusinessObjects\BusObj General Preferences\busobj\Options\Addin\OlapConnectHere is