µ¥«Ý¤W¤@µ{¦¡§¹¦¨, ¤~°õ¦æ¤U¤@¬qµ{¦¡
- ©«¤l
- 33
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-17
- ³Ì«áµn¿ý
- 2020-11-2
|
µ¥«Ý¤W¤@µ{¦¡§¹¦¨, ¤~°õ¦æ¤U¤@¬qµ{¦¡
¦³¤@vba »ÝŪ¨ú ms sql ¸ê®Æ, ¤Î½Æ¨î¨ì¥t¤@¤u§@¶,
¦ý¥Ñ©óŪ¨ú ms sql ¸ê®Æ¤´¥¼§ó·s§¹¦¨, ¤w½Æ¨îªÅ¥Õ¸ê®Æ¨ì·s¤@¶,
¦³¦ó¤è¦¡µ¥«Ý¤W¤@µ{°õ¦æ§¹¦¨, (§ó·s¸ê®Æ)¤~¦A°õ¦æ, |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 33
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-17
- ³Ì«áµn¿ý
- 2020-11-2
|
¦^´_ 2# GBKEE
°õ¦æ¨ì¦¹¥y, ¤Ë²{¿ù»~- Sub l_style()
- '
- Dim ST_NO
- ST_NO = Application.InputBox("¿é¤J´Ú¸¹", "¿é¤J´Ú¸¹", "", 200, 100)
- ST_NO = UCase(ST_NO)
-
- ' Sheets("stylebom").Select
- 'Cells(2, 2) = "& st_no"
- Sheets("stylebom").Range("E3") = ST_NO
-
- Application.CutCopyMode = False
- With ActiveWorkbook.Connections( _
- "192.168.101.203 Garment01 TxProjMatStyCons").OLEDBConnection
- .BackgroundQuery = True
- .CommandText = Array( "SELECT * from table 1 where style = '" & ST_NO & "'" )
- .CommandType = xlCmdSql
- .Connection = Array( _
- "OLEDB;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=True;Initial Catalog=Garment01;Data Source=192.16" _
- , _
- "8.101.203;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CWST021;Use Encryption for Data=False;" _
- , "Tag with column collation when possible=False")
- .RefreshOnFileOpen = False
- .SavePassword = False
- .SourceConnectionFile = ""
- .SourceDataFile = ""
- .ServerCredentialsMethod = xlCredentialsMethodIntegrated
- End With
- With ActiveWorkbook.Connections( _
- "192.168.101.203 DtradeSimpleGarment01 TxProjMatStyCons")
- .Name = "192.168.101.203 DtradeSimpleGarment01 TxProjMatStyCons"
- .Description = ""
- End With
- ActiveWorkbook.Connections( _
- "192.168.101.203 DtradeSimpleGarment01 TxProjMatStyCons").Refresh
- Selection.QueryTable.Refresh BackgroundQuery:=False
- Call c_new
- End Sub
½Æ»s¥N½X |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 33
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 62
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- xp
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-17
- ³Ì«áµn¿ý
- 2020-11-2
|
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|