SAP系统VBA宏下载提取失败求助:触发‘Invalid GUI input data: FOCUS DATA’错误
求助:VBA宏下载SAP提取文件时触发"Invalid GUI input data: FOCUS DATA"错误
我最近碰到个头疼的问题,想请各位帮忙分析下:我写的VBA宏在从SAP系统下载提取文件时,一到下载环节就突然停住,弹出错误提示 Invalid GUI input data: FOCUS DATA。但奇怪的是,手动执行完全相同的操作步骤却毫无异常。我已经联系IT部门排查过,还尝试安装了新版本的SAP客户端,可这个问题依然没解决。
SAP系统手动操作步骤
- 输入事务码
ZFIS,选择路径:Finance New GL >> Line Item Reports >> Cognos Download - 输入所需参数后执行查询
- 将查询结果保存为txt格式到指定文件夹
附上我的VBA代码片段
Sub CognosUpload() Dim SAPApplication Dim SAPConnection Dim SAPSession Dim SAPGuiAuto Dim StoringPath As Variant Dim fso As Scripting.FileSystemObject Dim ts As Scripting.TextStream Application.ScreenUpdating = False Application.EnableEvents = False Application.DisplayAlerts = False CurYear = Format(DateSerial(Year(Date), Month(Date) - 1, 1), "YYYY") Period = Format(DateSerial(Year(Date), Month(Date) - 1, 1), "MM") MsgBox ("Please select a folder to save all the SAP Extracts.") Set FldrPicker = Application.FileDialog(msoFileDialogFolderPicker) With FldrPicker .Title = "Select A Target Folder" ' 原代码后续内容省略 End With End Sub
有没有大佬能帮忙梳理下这个错误的可能原因,或者给点解决思路?多谢大家了!
内容的提问来源于stack exchange,提问作者raj kumar
相关产品推荐
相关产品推荐

