Dim strMsg As String
strMsg = "Preperation completed. SAP Logon will open in 5 seconds! Please follow the instructions below to retrieve the ART file from SAP" & vbNewLine & vbNewLine
strMsg = strMsg & "1. Log into SAP using your Username and ID" & vbNewLine & vbNewLine
strMsg = strMsg & "2. Launch the 'ZMM_ART' Report" & vbNewLine & vbNewLine
strMsg = strMsg & "3. Insert the data from the 'DATA FOR SAP' Sheet to the relevent fields" & vbNewLine & vbNewLine
strMsg = strMsg & "4. Insert '0001' as the Location ID" & vbNewLine & vbNewLine
strMsg = strMsg & "5. Run the Report" & vbNewLine & vbNewLine
strMsg = strMsg & "6. Save the report as 'ART.xls' to the 'REQUIRED FILES' Folder in your Desktop" & vbNewLine & vbNewLine
strMsg = strMsg & "7. Click OK and close this message box" & vbNewLine & vbNewLine
MsgBox strMsg, vbInformation + vbSystemModal, "Instructions"
我需要在宏的某个位置显示上面的消息框 . 但我需要用户能够在excel表上工作，同时将所述消息框放在最上面 . （即：复制上述'DATA FOR SAP'表格中的数据并将其粘贴到SAP中）您如何建议我应该这样做？
PS：有人想知道为什么，我没有RFC授权，所以这就是我所贬低的 .
谢谢！
1 回答
你不能这样做 .