If you export data from VB to excel, there may be a lot of such code on the Internet, but you only need to install Excel. Today I share with you that you can export data without installing excel.Rem Author: Xie Yan Jin Creation Time: 2002-12-20 mail:
**************************************** ***************************
'Get the IP address
'*************************************** ****************************
Function userip ()
Dim getclientip
'If the client uses a proxy server, use the
1. generate random seriesMethod 1Code:Randomize' updates reverse dataFuncation rand (k, n)N = int (k-1) * RND + 1)Rand = NEnd funcationMethod 2Code:N = randomnumber. Value (1,255)2When a row in the table is run, all data in the table is
Serv-u6.0 Privilege Escalation
From: Anti-DDoS pro April Journal
Applicable environment: the server disables FSO, disables wscript. shelll, and has no execution permission.
Restriction: The administrator password is not changed or the password of
With the upgrade of the Oracle version, RMAN is also enhanced. RMAN in Oracle11g supports the use of different operating systems and different databases. For the compatibility of RMAN, refer:
Oracle RMAN compatibility and FAQs between different
REGEXP_LIKE (matching)REGEXP_INSTR (included)REGEXP_REPLACE (replace)REGEXP_SUBSTR (extract)
For example, the expression of the mobile phone number: ^ [1] {1} [35] {1} [[: digit:] {9} $You can query customer information tables (tKHXX) that contain
Characters corresponding to the ASCII code value and ascii characters
Chr (9) tab space chr (10) newline chr (13) carriage return Chr (13) & chr (10) carriage return newline chr (32) space character chr (34) double quotation marks chr (39) single
In-depth exploration of Windows Script Technology
ArticleAuthor: zzzevazzz
To enableCodeClean and use the PHP tag of the forum for processing. (No vbs label, code label is not easy to use, depressing)If you reprint this article, make
Url = "http: // 127.0.0.1/test/20021317173156951.swf" 'address for testing
If url = "" Then die ("URL cannot be blank.") 'dare to repeat me, empty URL can't'
T = faster Rev (URL, "/") 'Get the last "/" location'
If T = 0 or T = Len (URL) Then die
Inputbox functions and msgbox functions are frequently used in simple interaction with users.
I. inputbox Functions
1. Role
A text box is displayed, prompting you to enter text, numbers, or select a cell area in the text box. When you press
Here we use excel Data for the simplest test.
1) Save the excel data as a t.txt file. Note that the file suffix is. txt.
1 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
3 jhchen 11/07/2005 20:04:00 2005-11-
About a year ago, the VBS script virus went viral again. A large group of VBS viruses were prevalent on the Internet. At that time, almost all VBS used FSO and MAPI as a virus transmission engine. So I thought, can VBS access the network? If it can
The window. confirm method in javascript is very useful. A confirmation dialog box is displayed.
The reason why we bring up this dialog box may be that this operation is dangerous, so you need to confirm it. However, if "OK" is selected by default,
CreateHtml
Generate all articles with high resource usage
Method 1:
Copy codeThe Code is as follows: 'start HTML Generation Method
Set Rs = Server. Createobject ("Adodb. Recordset ")
SQL = "Select KQIQI_ID, KQIQI_Title, KQIQI_Pinyin, KQIQI_Explain,
How do I verify the IP address?
Sub chkIP (boardid)
Dim rsIP
Dim ipArr
Dim ignored
Dim I
Dim ip
Dim SQL
Ip = Request. ServerVariables ("REMOTE_ADDR ")
Ignored = false
If not isempty (boardid) then
SQL = "select ignoreip from board where boardid =" &
InputBox Function
A prompt is displayed in the dialog box. Wait for the user to enter the text or click the button, and return the text box content.
InputBox(prompt[,title][,default][,xpos][,ypos][,helpfile,context])Parameters
Prompt
String
Copy codeThe Code is as follows: '///************************************ ******************************
'Common public function library file name: PubFunction. asp
'*************************************** ***************************///
Const
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.