鱼C论坛

 找回密码
 立即注册
分享 CAD export each drawing to form separate dwg file
Victory_6226 2016-8-18 14:09
'testing export each drawing from the cubicle drawing as separate file. Sub inttest() Dim entry As AcadEntity Dim BlockObj As AcadBlock Dim ssetObj As AcadSelectionSet Dim moSpace As AcadModelSpace Set moSpace = ThisDrawing.ModelSpace Dim minExt As Variant Dim maxExt As Variant Dim m ...
个人分类: Study Script|549 次阅读|0 个评论
分享 【Wincc7.0】解析generate sources后的DB块,自动生成DB变量及地址,供导入到Wincc使 ...
Victory_6226 2015-5-11 23:25
1. DB块打开后,选择generate sources功能,完成后会在S7资源管理器sources下看到生成的source文件 2. 打开source文件,复制到excel里面做处理,trim前面的空格,下面VBA脚本即为针对纯struct块的处理过程 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sub CreateTag() Dim a As Variant Dim b As Variant Dim szGroup, szTagname ...
个人分类: Study Script|581 次阅读|0 个评论
分享 【VBA】word表格中table内容提取后存入到excel
Victory_6226 2015-4-8 13:18
Sub extractFATtestingcase() ' ' extractFATtestingcase 宏 ' ' Dim objDoc As Document Dim objTable, objLastTable As Table Dim objCell As Cell Dim intCount As Integer Dim strText As String ...
个人分类: Study Script|781 次阅读|0 个评论
分享 【待测试】PING命令脚本一行输出
Victory_6226 2014-10-29 12:13
NND,用了一上午,水平太菜了 @echo off setlocal enabledelayedexpansion for /f "delims=" %%i in (WKT.txt)do (set ipaddr= %%i for /f "delims=" %%m in ('ping -n 1 !ipaddr!^|find "TTL" ^ping.txt ^^ echo ping ! ipaddr! 1 ^|^| echo ping !ipaddr! 0')do ( set str_ping=!date!!time! %%m) ...
个人分类: Study Script|327 次阅读|0 个评论
分享 网关地址
Victory_6226 2014-10-27 17:56
Function addsheets(station) Worksheets.Add after:=Sheets(Sheets.Count) '在所有表最右边插入一表 ActiveSheet.Name = station '表名 End Function Sub gateway() Dim station, column1, column2, column3, column4 As String column1 = 10 column4 = 1 Dim row_station_start, row_st ...
个人分类: Study Script|326 次阅读|0 个评论

小黑屋|手机版|Archiver|鱼C工作室 ( 粤ICP备18085999号-1 | 粤公网安备 44051102000585号)

GMT+8, 2024-5-6 09:16

Powered by Discuz! X3.4

© 2001-2023 Discuz! Team.

返回顶部