上一页 1 2 3 4 5 6 ··· 11 下一页
摘要: uname = "$env:USERPROFILE" $uname=$uname.Substring($uname.length -8) $checkpath = test-path \\xx.xx.xxx.xxx\xx\xx\*.lnk if($checkpath -eq "True"){ cop 阅读全文
posted @ 2024-02-23 14:13 tec2019 阅读(19) 评论(0) 推荐(0) 编辑
摘要: 应用工具引用:Microsoft Outlook 16.0 Object Library ‘根据outlook版本选择 或 Set Mail = CreateObject("Outlook.Application") Sub SendEmail() Dim Mail As Outlook.Appli 阅读全文
posted @ 2023-10-10 11:10 tec2019 阅读(262) 评论(0) 推荐(0) 编辑
摘要: Sub createFolder() Dim wks As Worksheet On Error Resume Next Set wks = ThisWorkbook.Worksheets(1) basepath = ThisWorkbook.Path & "\" Max = wks.Range(" 阅读全文
posted @ 2023-09-11 16:08 tec2019 阅读(108) 评论(0) 推荐(0) 编辑
摘要: Private Sub CommandButton2_Click() Dim c For Each c In UserForm2.Controls If TypeName(c) = "TextBox" Then c.Text = "" Next End Sub 资料来源https://zhidao. 阅读全文
posted @ 2023-08-18 14:41 tec2019 阅读(144) 评论(0) 推荐(0) 编辑
摘要: Option Explicit Private Declare Function GetSystemDefaultLCID Lib "kernel32" () As Long Private Sub Form_Load() Dim LocaleID As Long LocaleID = GetSys 阅读全文
posted @ 2023-08-09 10:40 tec2019 阅读(90) 评论(0) 推荐(0) 编辑
摘要: 窗体 ' '->Forms ' Module ' ClassModules ' Option Explicit Private Declare Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As Str 阅读全文
posted @ 2023-08-01 13:27 tec2019 阅读(1112) 评论(1) 推荐(0) 编辑
摘要: 模版表名Template sheet25 数据列表名sheet1 打印程序 Sub PrintLabel() With ThisWorkbook.Sheets("Sheet1") limitmax = .Range("B10000").End(xlUp).Row For i = 2 To limit 阅读全文
posted @ 2023-02-06 16:12 tec2019 阅读(65) 评论(0) 推荐(0) 编辑
摘要: import pandas as pd import pyodbc import time # 文件路径及文件名 mdb_file = r"X:\xxx.accdb" driver = '{Microsoft Access Driver (*.mdb, *.accdb)}' cnxn = pyodb 阅读全文
posted @ 2022-11-01 11:11 tec2019 阅读(152) 评论(0) 推荐(0) 编辑
摘要: Server: import socket # 创建socket tcp_server_socket = socket.socket(socket.AF_INET, socket.SOCK_STREAM) # 本地信息 address = ('服务器ip', 3000) # 绑定 tcp_serve 阅读全文
posted @ 2022-09-23 15:15 tec2019 阅读(272) 评论(0) 推荐(0) 编辑
摘要: Sub GetSheetName() Dim Path As String Dim File As String Dim WB As Workbook Dim sht As Worksheet Dim arr() As String Dim narr() As String Application. 阅读全文
posted @ 2022-06-28 14:02 tec2019 阅读(234) 评论(0) 推荐(0) 编辑
上一页 1 2 3 4 5 6 ··· 11 下一页