- 31
- 0
- 约1.31万字
- 约 14页
- 2022-03-04 发布于浙江
- 举报
变量定义
Dim s As String 〔字符串〕
Dim d As Double 〔双精度〕
Dim i As Integer 〔整数〕
Dim j As Long 〔长数据〕
也可以用字符来代替数据类型,分别对应如下:
Dim s As String
Dim s $
Dim d As Double
Dim d #
Dim i As Integer
Dim I %
Dim j As Long
Dim j
语言
StoreParameter〔“width〞,20〕%%更改参数
?MsgBox CStr〔d1〕%%数据类型转换。CStr〔〕用于将给定的参数转换为字符串数据类型〔Convert into StringCDbl〔〕。
Evaluate〔〕,将数据转换为双精度类型
Set word = CreateObject(Word.Application),Set ppt = CreateObject(PowerPoint.Application)脚本访问相应外部对象〔Word和PPT或者其他〕。
以下代码段显示了如何从使用VBA的外部程序启动和控制CST MICROWAVE STUDIO:
Sub Main()
????Dim studio As Object
????Set studio = CreateObject(CSTStudio.Application)
?
????Dim mws As Object
????Set mws = studio.NewMWS
?
????Dim brick As Object
????Set brick = mws.brick
????brick.Name brick
????brick.Xrange 0, 1
????brick.Yrange 0, 1
????brick.Zrange 0, 1
????brick.Create
?
????mws.SaveAs C:\temp\test.cst, False
????mws.Quit
?
????Set studio = Nothing
End Sub
通过使用With-End With
Sub Main()
????Dim studio As Object
????Set studio = CreateObject(CSTStudio.Application)
?
????With studio.NewMWS
?
????????With .Brick
???????????.Name brick
???????????.Xrange 0, 1
???????????.Yrange 0, 1
???????????.Zrange 0, 1
???????????.Create
????????End With
?
????????.SaveAs C:\temp\test.cst, False
????????.Quit
?
????End With
?
????Set studio = Nothing
End Sub
?
从VBA 这在下面的例子中显示:
Dim sline as String
?
Open mydata.txt For Input As #1
??????While Not EOF(1)
??????Line Input #1,sline
??????Debug.Print sline
Wend
Close #1
?
Open mydata.txt For Output As #2
???????Print #2, Test Output
Close #2
?
Open mydata.txt For Append As #3
???????Print #3, Test Output 2
Close #3
How to use the VBA Objects
从外部程序中调用CST
以下例如代码可以在外部应用程序〔如电子表格或字处理器〕的VBA解释器中输入。 它创立一个CST STUDIO SUITE应用程序对象,翻开一个工程并创立一个砖块:
Sub Main()
Dim studio As Object
?
Starts?CST STUDIO SUITE
Set studio = CreateObject(CSTStudio.Application)
?
Dim proj As Object
Set proj = studio.NewMWS
?
Dim brick As Object
Set brick = proj.brick
?
brick.Reset
brick.Name BrickOne
brick.Xrange 0, 1
brick.Yrange 0, 2
brick.Zrange
您可能关注的文档
最近下载
- 广东省2021年专升本考试《政治理论》真题及答案.pdf VIP
- 2026年运输公司年后复工安全培训课件.pptx VIP
- 2025年春人教PEP三年级英语下册教案:Unit 6 Numbers in life.docx VIP
- 驾照考试科目一试题.docx VIP
- 设施农业CAD绘图教程.pptx
- 2025年新疆高考理综真题试卷及答案.docx VIP
- 2026在京全国性宗教团体应届高校毕业生招聘16人备考题库及参考答案详解一套.docx VIP
- 2026在京全国性宗教团体应届高校毕业生招聘16人备考题库含答案详解(完整版).docx VIP
- TCL 滚筒洗衣机TG-V80BA使用说明书.pdf
- 云南省中考:2025年-2023年《语文》考试真题与参考答案.pdf
原创力文档

文档评论(0)