
语言-VBA
Visual Basic for Applications ,Excel ,Soldworks、word
少莫千华
这个作者很懒,什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
【SolidWorks宏】读取文件的第一行数据
Rem "读取文件的第一行数据"Public Function ReadFirstLineDataFromFile(fileName) As String '声明 Dim filePath As String Dim fs As Object Dim otf As Object '执行过程 filePath = fileName ...原创 2018-05-11 22:39:35 · 1730 阅读 · 0 评论 -
【SolidWorks宏】VBA 获取数组的长度
REM "获取数组长度"Public Function ArrayLength(ByVal ary) As Integer ArrayLength = UBound(ary) - LBound(ary) + 1End FunctionREM "调用示例"Sub SplitSample() '声明 Dim temp() As String Dim EgStr...原创 2018-05-11 22:20:18 · 29314 阅读 · 0 评论 -
【SolidWorks宏】将文件数据一行一行添加到ListBox
Rem 将文件数据一行一行添加到ListBoxPublic Sub LoadFileToListBox(filePath As String, lb As ListBox) '声明 Rem Dim filePath As String Dim fs As Object Dim otf As Object Dim localylp As Double ...原创 2018-05-11 23:24:41 · 1037 阅读 · 0 评论 -
【SolidWorks宏】VBA操作SolidWorks程序对象
Rem 获取SolidWorks的标题并解析Private Sub SldWorks_GetTitle() Dim SwApp As Object Dim TitleStr As String Dim PartStr() As String Dim Part1 As String Dim Part2 As String Dim Swmodel As...原创 2018-05-12 00:15:29 · 11470 阅读 · 0 评论 -
【SolidWorks宏】向指定的文件写入一行数据
Rem 向指定的文件写入一行数据Public Sub WriteFirstLineDataToFile(filePath As String, content As String) '声明 Dim fs As Object Dim ctf As Object '执行过程 Set fs = CreateObject("Scripting.FileS...原创 2018-05-11 22:47:29 · 828 阅读 · 0 评论 -
【SolidWorks宏】选择文件夹
Rem 选择文件夹Public Sub SG_BrowseForFolder() '** 使用Shell.Application对象来选择文件夹 Dim objShell Dim objFolder Dim strPath As String Set objShell = CreateObj...转载 2018-05-16 20:54:51 · 3641 阅读 · 0 评论 -
【SolidWorks宏】VBA 选择文件
Rem 选择文件-从注册表中获取Function SG_BrowseForFileFromReg() Dim shell: Set shell = CreateObject("WScript.Shell") Dim fso: Set fso = CreateObject("Scripting.FileSystemObject") Dim tempFolder: Set t...转载 2018-05-16 20:53:15 · 4007 阅读 · 0 评论