Skip to Content
0
Dec 08, 2022 at 06:59 PM

vba can not operate or control tables in the same sub at the same time?

23 Views

hello

How to solve the problem that vba can not automate sap export excel and operate or control tables in the same sub at the same time?

I found that when automating sap through vba, the program can drive sap to export excel tables, but it is impossible to perform subsequent operations on the exported excel tables in the same sub, such as writing data to cells. Sap export tables often wait until the vba program is fully run before sap export tables are opened.

It is impossible to use statements such as "application.wait" or "sleep 5000" in the program to clock in and identify and control the sap export table first. How to solve this problem, I need sap and vba experts to help.

Thanks for your help.