vba lessons

-X127.0.0.1:80 test.com/admin///prompt 401 user request12.9 Nginx Domain Redirectionvim/usr/local/nginx/conf/vhost/test.com.conf//Modify to the following content----------------------------------------------------------------Server{Listen 80;server_name test.com test1.com test2.com;Index index.html index.htm index.php;root/data/wwwroot/test.com;if ($host! = ' test.com ') {Rewrite ^/(. *) $ http://test.com/$1 permanent;}Location ~ admin.php{auth_basic "auth";AUTH_BASIC_USER_FILE/USR/LOCAL/NGINX/C

10.32/10.33 rsync via service syncShut down the firewall, #systemctl stop FIREWALLDView iptables rules, #iptables-NVLTest whether the remote host 873 port is turned on, #telnet 192.168.133.130 873If rsync is changed to a different port, such as 8730, the command is #rsync-avlp--port 8730 192.168.133.130::test//tmp/test/10.34 Linux system logsLogrotate Cutting log files,Last view normal log in log;LASTB View login failure log;Security log/var/log/secure;10.35 Screen ToolVirtual Screen Screens-S c

Tags: Linux notesEight weeks two sessions (March 27)10.28 Rsync Tools Introduction10.29/10.30 rsync Common Options10.31 rsync sync via sshThe native a directory to B directory at a small time just added a file. Either find the file, or cover the B, and read and write a waste of time. You can synchronize the updated file with Rsync. A machine to B machine can also be synchronized.This machine rsyncA machine to B machine10.29 rsync Common Options--DELETE:A Machine 123 Synchronization B machine 123

Ping does not pass 192.168.100.1 and 192.168.100.100To view the gateway, run the following command.No gatewaysSet the gateway and run the following command.Can ping throughSet up DNS. 119.29.29.29 is a public DNS.Can ping the DNS, you can ping the outside network.Only 1 IPCannot ping pass.A machine equivalent to a router, B machine equivalent to a router phone, computer, can now be networked.10.18 iptables NAT Table ApplicationWindows cannot ping through 192.168.100.100Each operation needs to b

command. Clear the rules, save no use.Restart the service and load it back.Zeroing the calculatorI wrote a monitoring script and found that IP had a field that dropped the IP. Review the rules if the number of packets does not exceed 100. can be solved by sealing off. The number through the first column. Recalculate after 30 minutes.After the data came, said not to say, directly kicked off.After the data came, say, can't come in.The usage of-I. -I is inserted, metaphorically queued, inserted to

8sdafasdf ' ++echo8sdafasdf++sed ' s/[0-9]//g ' +n1=sdafasdf+ ' [' -n sdafasdf '] ' +echo ' Pleaseinputanumber. ' Pleaseinputanumber.+exit1[[email protected]shell]#sh-xcase.sh+read-p ' Pleaseinputa number: ' nPleaseinputanumber:123 # #输入一个大于100的数字 + ' [' -z123 ' ++echo123++sed ' s/[0-9]//g ' +n1=+ ' [' -n ' ' ' + ' [' 123-lt60 '] ' + ' [' 123-ge60 '] ' + ' [ ' 123-lt80 ' ' + ' [' 123-ge80 '] ' + ' [' 123-lt 90 ' + ' [' 123-ge90 '] ' + ' [' 123-le100 '] ' + tag=0+case $tag in+echo ' thenumberra

exitingVariable PS1 definition prompt, modified under/ETC/BASHRC[[email protected] ~]# echo $PS 1[\[email protected]\h \w]\$ # #如果将W换成w, then the path will become an absolute path [[email protected] ~]#PS1 = ' [\[email protected]\h \w]\$ ' [[email protected] ~] #cd/tmp/d6z/[[email protected]/tmp/d6z] #PS1 = ' [\[email Protected]\h \w]\$ ' [[email protected] d6z]#can be set with color displayps1= ' \[\033[01;32m\]\[email protected]\h\[\033[00m\]:\[\033[01;36m\]\w\[\033[00m\]\$ '2018-1-11 5 weeks

10.6 Monitoring IO PerformanceIostat and SAR belong to the same installation package; view disk usage;Iotop command, install #yum install-y iotop10.7 Free CommandFree to view memory usage10.8 PS CommandPS static view process status, top is the dynamic display process status;PS aux and ps-elf view process effect is similar;10.9 Viewing network status-l,listen monitoring;LNUTP, view only TCP and UDP;Established the number of concurrent connections, generally less than 1000, more than two thousand

Tags: Linux notesSeven weeks two sessions (March 20)10.6 Monitoring IO Performance10.7 Free Command10.8 PS Command10.9 Viewing network status10.10 Linux under Grab BagExtended TCP three-time handshake four times wave http://www.doc88.com/p-9913773324388.htmlTshark several usages: http://www.aminglinux.com/bbs/thread-995-1-1.htmlInstalling the package Sysstat will install the Iostat. And SAR are the same package.%util is the percentage of waiting IO. The hard disk can affect the performance of th

10.11 Linux Network relatedIfconfig-a can display the disabled or down network card;Start the network card #ifup ens33; Disable the network card #ifdown Ens33;Nic configuration file/etc/sysconfig/network-script/ifcfg-ens33Copy Create virtual network adapter profile, #cd /etc/sysconfig/network-script/#cp Ifcfg-ens33 ifcfg-ens33\:0#vi!$10.12 Firewalld and NetFilterGetenforce View firewall status;10.13 NETFILTER5 Table 5 Chain IntroductionView NetFilter instructions, #man netfilter;10.14 iptables S

connect the MONGO from the library. (2) When deleting the MONGO table in hive, remove the jar package configuration in Hive-site.xml, and after disconnecting the Hive table from the MONGO, be careful! If you keep driving and drop directly, the table data in the MONGO will be drop. The most important thing is that your ops should do the right configuration of MongoDB in advance and give read-only permission to prevent misoperation. (3) in general, as long as the configuration is good, this plu

When Office users need to customize new features for a document, they can resort to VBA or two ways of VSTO. Office 2013 Rich Client, Microsoft provides a new model for developers on the Office platform---Office add-in model, which allows you to create an area in an Office application and show the Web pages interacting with the document in this area. Developers can integrate highly customized WEB apps or services into office, making them available on

One: VBA object' VBA objects ' objects in VBA are actually the ones we operate with methods, properties that support objects in Excel: ' 1, Workbook ' Workbooks represents a workbook collection, all workbooks, Workbooks (n), which indicates that the nth workbook ' Workbooks ("Workbook name") ' ActiveWorkbook is in the workbook ' 2, Workbook ' where th

MSDN-Visual Basic: http://msdn.microsoft.com/zh-cn/library/2x7h1hfk.aspx MSDN-VB statement: http://msdn.microsoft.com/zh-cn/library/865x40k4.aspx Http://blog.csdn.net/alexbnlee? Viewmode = contents Use Excel VBA to add a file in Multiple folders to the header and traverse the file) The hexadecimal index is quite regular) Python data type-sequence (string, list, tuples) Python data type-value type) ArcPy-Getting Started) Python-Basic tutorial

China localization Pack is a piece of chicken,But for some friends it is not true;Unfortunately, the exit of China's localization package has lagged behind,More than 1 years after the latest version of the software came out,Localization is not sure to come out,Even if it comes out,It can only be obtained by users who have purchased a fast Bo service.In the 2017 release of the localization pack,Contains some 2009 versions of the VBA source code,Althoug

Overview: It mainly describes the usage and disadvantages of VBA, and then explains how to set up the development environment of VBA and how to improve programming efficiency by using VBE. I. A Brief History of VBA A) macro introduction: The macro should be named macro. It is a set of commands that automatically execute certain operations. It contains two process

Recently, I was too busy to do some things with my mind. The progress of an Excel book was very slow. The reason was that I could not concentrate on doing things, except for the outside world. Today, a Web user sent a mail to discuss the VBA issue. I wonder if the platform after office 12 or later will continue to support VBA. I replied that it should continue or there is a better alternative. But in fact

position in the Excel object model is:Application ObjectWorkbook objectWorksheet ObjectRange ObjectKnowing where an object is located in the object model hierarchy, you can easily reference the object with VBA code, manipulate the object, and organize the objects in a specific way so that Excel can automate the task as you need it. Therefore, to master Excel VBA programming, you must understand the object

Failure Analysis: Excel VBA is in fact Everyone Code Editor program, some people are considered to be macros, but Excel VBA is included in the macro program. Let's take a look at what Excel VBA is. How do I open it? One, Excel VBA is what? VBA in Excel

Sometimes, when using Word for text editing, suddenly encountered power, or computer automatic shutdown, crash, and other failures, resulting in the work of hard to do out of all the results, is a lot of netizens are very crazy things. Today, I'm going to teach you. Use VBA code to automate backup so that Word can be automatically backed up every few minutes without affecting the file being edited. Let's get to know each other now! 1, open the Word F