Tool63 excel / vba / sheet 목록 가져오기 Sub 목록추출() '함수명 Dim SheetNames() SheetCount = ActiveWorkbook.Sheets.Count ReDim SheetNames(1 To SheetCount) 'Sheets("목록").Select ' "목록" 이라는 sheet에 sheet목록 만들기 Range("A2").Select 'A2 cell부터 시트명입력 For i = 1 To SheetCount SheetNames(i) = ActiveWorkbook.Sheets(i).Name ActiveCell = ActiveWorkbook.Sheets(i).Name ActiveCell.Offset(1, 0).Select Next i End Sub 2020. 4. 16. nginx default.conf 1. vi /etc/nginx/nginx.conf # # The default server # server { listen 80; server_name test1.test.com; root /opt/www/test1; location / { try_files $uri $uri/ =404; } } ############################################# server { listen 80; server_name test2.test.com; root /opt/www/test2; location / { try_files $uri $uri/ =404; } } ############################################ server { listen 80; server_n.. 2019. 4. 10. centos / nginx / install nginx on centos 7 yum -y install epel-release yum -y install nginx systemctl start nginx sudo firewall-cmd --permanent --zone=public --add-service=http sudo firewall-cmd --permanent --zone=public --add-service=https sudo firewall-cmd --reload systemctl enable nginx systemctl restart nginx vi /etc/nginx/nginx.conf ... http { ################################ server { listen 80; server_name xxxxxxx.test.com; locatio.. 2019. 4. 10. 이전 1 ··· 13 14 15 16 다음 반응형