Exit(0) And Exit(1) Function in Application Engine

本文详细介绍了在应用引擎中使用 Exit(0) 和 Exit(1) 的区别,用于终止当前 PeopleCode 动作和步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Exit(0) – Terminates the current PeopleCode Action in application engine.

Exit(1) – Terminates the current Step in application engine.

优化以下VBA 代码:目前筛选数据的速度太慢了,要加快。Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim filePath As String Dim wb1 As Workbook, wb2 As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim keyword1 As Variant, keyword2 As Variant Dim lastRow As Long, visibleRows As Long If Target.Column = 3 And Target.Row > 1 Then Cancel = True keyword1 = Target.Value keyword2 = Cells(Target.Row, 1).Value If IsEmpty(keyword1) Or IsEmpty(keyword2) Then MsgBox "所选单元格内容不能为空!", vbExclamation Exit Sub End If ' path filePath = "C:\Users\Skyler.zheng\OneDrive - Taikoo Engine Services (Xiamen) Company Limited\Desktop\SO list-Brg.xlsm" On Error Resume Next Dim localPath As String localPath = GetLocalFilePath(filePath) If localPath = "" Then localPath = filePath End If On Error GoTo 0 ' 打开表格2 Application.ScreenUpdating = False Application.DisplayAlerts = False On Error GoTo ErrorHandler ' 尝试打开工作簿 Set wb2 = Workbooks.Open(localPath, ReadOnly:=True) Set ws2 = wb2.Sheets("ZEGST001") ' 清除现有筛选 If ws2.AutoFilterMode Then ws2.AutoFilterMode = False End If ' 获取表格2的最后一行 lastRow = ws2.Cells(ws2.Rows.Count, 1).End(xlUp).Row ' 设置筛选条件 ws2.Range("A1").AutoFilter ' 筛选B列(与表格1的F列匹配) ws2.Range("A1").AutoFilter Field:=2, Criteria1:=keyword1 ' 筛选D列(与表格1的A列匹配) ws2.Range("A1").AutoFilter Field:=4, Criteria1:=keyword2 ' 检查是否有匹配的记录 On Error Resume Next visibleRows = ws2.Range("B2:B" & lastRow).SpecialCells(xlCellTypeVisible).Cells.Count On Error GoTo ErrorHandler If visibleRows > 0 Then ' 找到匹配记录,跳转到表格2并选中第一条记录 Dim firstVisibleRow As Long For firstVisibleRow = 2 To lastRow If Not ws2.Rows(firstVisibleRow).Hidden Then ws2.Rows(firstVisibleRow).Select ws2.Activate Exit For End If Next firstVisibleRow Else ' 未找到匹配记录,关闭表格2并提示 wb2.Close SaveChanges:=False MsgBox "No data", vbInformation End If CleanUp: Application.DisplayAlerts = True Application.ScreenUpdating = True Exit Sub ErrorHandler: ' 错误处理:关闭已打开的工作簿并显示错误信息 If Not wb2 Is Nothing Then wb2.Close SaveChanges:=False End If MsgBox "处理过程中出现错误: " & Err.Description, vbCritical Resume CleanUp End If End Sub Function GetLocalFilePath(onedrivePath As String) As String ' 将OneDrive路径转换为本地路径 ' 注意:此函数可能无法处理所有情况,具体取决于OneDrive同步设置 On Error Resume Next ' 尝试解析URL获取文件名 Dim fileName As String Dim parts() As String parts = Split(onedrivePath, "/") fileName = parts(UBound(parts)) ' 获取OneDrive本地同步文件夹路径 Dim localOneDrivePath As String localOneDrivePath = Environ("USERPROFILE") & "\OneDrive\文档" ' 根据实际情况调整 ' 构建本地文件路径 GetLocalFilePath = localOneDrivePath & "\" & fileName ' 检查文件是否存在 If Dir(GetLocalFilePath) = "" Then GetLocalFilePath = "" ' 文件不存在,返回空字符串 End If On Error GoTo 0 End Function
08-15
Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim filePath As String Dim wb1 As Workbook, wb2 As Workbook Dim ws1 As Worksheet, ws2 As Worksheet Dim keyword1 As Variant, keyword2 As Variant Dim lastRow As Long, visibleRows As Long Dim localPath As String ' 只处理第3列、第2行开始的单元格 If Target.Column <> 3 Or Target.Row <= 1 Then Exit Sub Cancel = True Set ws1 = Me keyword1 = ws1.Cells(Target.Row, 3).Value keyword2 = ws1.Cells(Target.Row, 1).Value ' 检查关键词是否为空 If IsEmpty(keyword1) Or IsEmpty(keyword2) Then MsgBox "所选单元格内容不能为空!", vbExclamation Exit Sub End If ' 文件路径 filePath = "C:\Users\Skyler.zheng\OneDrive - Taikoo Engine Services (Xiamen) Company Limited\Excel Version\SO list-Brg.xlsm" ' 获取本地路径 localPath = GetLocalFilePath(filePath) If localPath = "" Then localPath = filePath ' 禁用屏幕刷新和提示 Application.ScreenUpdating = False Application.DisplayAlerts = False On Error GoTo ErrorHandler ' 打开目标工作簿 Set wb2 = Workbooks.Open(localPath, ReadOnly:=True) Set ws2 = wb2.Sheets("ZEGST001") ' 清除已有筛选 If ws2.AutoFilterMode Then ws2.AutoFilterMode = False ' 获取最后一行 lastRow = ws2.Cells(ws2.Rows.Count, 1).End(xlUp).Row ' 设置筛选条件(B列和D列) With ws2.Range("A1") .AutoFilter Field:=2, Criteria1:=keyword1 .AutoFilter Field:=4, Criteria1:=keyword2 End With ' 检查是否有匹配行 On Error Resume Next visibleRows = ws2.Range("B2:B" & lastRow).SpecialCells(xlCellTypeVisible).Count On Error GoTo ErrorHandler If visibleRows > 0 Then ' 找到匹配项,跳转到第一个可见行 Dim rngVisible As Range Set rngVisible = ws2.Range("B2:B" & lastRow).SpecialCells(xlCellTypeVisible) ws2.Activate rngVisible.Cells(1).EntireRow.Select Else ' 未找到匹配项,关闭工作簿并提示 wb2.Close SaveChanges:=False MsgBox "No data", vbInformation End If CleanUp: Application.DisplayAlerts = True Application.ScreenUpdating = True Exit Sub ErrorHandler: If Not wb2 Is Nothing Then wb2.Close SaveChanges:=False MsgBox "处理过程中出现错误: " & Err.Description, vbCritical Resume CleanUp End Sub Function GetLocalFilePath(onedrivePath As String) As String On Error Resume Next Dim fileName As String Dim parts() As String parts = Split(onedrivePath, "/") fileName = parts(UBound(parts)) Dim localOneDrivePath As String localOneDrivePath = Environ("USERPROFILE") & "\OneDrive\文档" ' 根据实际情况调整 GetLocalFilePath = localOneDrivePath & "\" & fileName If Dir(GetLocalFilePath) = "" Then GetLocalFilePath = "" On Error GoTo 0 End Function优化以上代码,双击后跳转并筛选出相应数据这步的等待时间缩短成1秒,目前运行时间还是太久了
07-25
内容概要:本文针对国内加密货币市场预测研究较少的现状,采用BP神经网络构建了CCi30指数预测模型。研究选取2018年3月1日至2019年3月26日共391天的数据作为样本,通过“试凑法”确定最优隐结点数目,建立三层BP神经网络模型对CCi30指数收盘价进行预测。论文详细介绍了数据预处理、模型构建、训练及评估过程,包括数据归一化、特征工程、模型架构设计(如输入层、隐藏层、输出层)、模型编译与训练、模型评估(如RMSE、MAE计算)以及结果可视化。研究表明,该模型在短期内能较准确地预测指数变化趋势。此外,文章还讨论了隐层节点数的优化方法及其对预测性能的影响,并提出了若干改进建议,如引入更多技术指标、优化模型架构、尝试其他时序模型等。 适合人群:对加密货币市场预测感兴趣的研究人员、投资者及具备一定编程基础的数据分析师。 使用场景及目标:①为加密货币市场投资者提供一种新的预测工具和方法;②帮助研究人员理解BP神经网络在时间序列预测中的应用;③为后续研究提供改进方向,如数据增强、模型优化、特征工程等。 其他说明:尽管该模型在短期内表现出良好的预测性能,但仍存在一定局限性,如样本量较小、未考虑外部因素影响等。因此,在实际应用中需谨慎对待模型预测结果,并结合其他分析工具共同决策。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值