Hi Varga, 1st Many thx for video. Very usefull. I manage to get my extract properly done. Nevertheless do you have any tips / code to add in order to select a variant by name? So I can create my variant and get my data as expected each time. Many thanks!
@hay47110815
9 ай бұрын
Thanks a lot for providing this video. One question: do you have a solution to add attachments in these services for objects in SAP? If you want to add an attachment, you have to "Drag and Drop" a file, or an explorer window opens and you have to select a file there. Until now, I did not find a way to control this explorer window, to select the correct path and file to upload it. Additional to that, I was not able to use the Drag and Drop” functionality using a VBA script. I would be very pleased to receive an answer!
@csongorvarga
9 ай бұрын
I have a video where I could upload attachments, but I was only able to do it when SAP provides a screen to specify the full path of the file. I never tried drag and drop before, but I assume that function cannot be scripted.
@hay47110815
8 ай бұрын
@@csongorvarga Hi, thanks for your answer. Are your able to provide me the Link to the Video, you mentioned? Thanks a lot, Harald
@csongorvarga
8 ай бұрын
@@hay47110815 Sorry, not upload, but download. I have two attachment download examples: kzitem.info/news/bejne/qnxu2XepqYOrom0 and kzitem.info/news/bejne/t3lj2oOGcZ58nqQ
@M4KE4W1SH
2 жыл бұрын
Awesome video! Do you intentionally export as a text file? I export as an excel file and what I think happens is, it opens excel as a new instance, which causes my code to error out. More details below about the issue. Any thoughts? When exporting out of SAP, the excel file will automatically open after it exports. I need my script to wait for the export to open, and then to close the newly opened export file. If I try to activate the export file immediately following the command to export the file in SAP GUI, I get a "subscript out of range" error. I thought maybe I could loop the activate command until it stops erroring (while the export.xlsx file is opening) but that causes excel to crash. I also tried using a delay, using application.wait but the download hangs no matter what time I input into the delay; 5 seconds, 15 seconds, it doesn’t matter. Manually, when exporting, it opens in about 3 seconds. Having said that, when the error pops up, it triggers the export to immediately open. Seems like when scripting, SAP doesn’t have the ability to recognize the export. When I step through the code manually, I don’t have any issues activating the export after it downloads and automatically opens. I’m not sure what to do here, any suggestions?
@csongorvarga
2 жыл бұрын
Back in the past I had issues with the Excel export. I think it used to work much worse and Excel was not able to open it properly. And I think it also depends on what your local settings are. Like if you have a different list separator in Windows Locale Settings, Excel will open the document as a text file. So for these reasons I started using unconverted format for many years now. Old habits. Maybe you can google for some VBA code how to check for Excel processes. Maybe that will help you to determine if Excel has started or not. But that is the only suggestion I have.
@vantomlol
6 жыл бұрын
Thanks a lot really helped
@alejandrasaenz4397
3 жыл бұрын
Thanks!!!
@annyeongmimi
6 жыл бұрын
Hi, i have a failed export. and on the sap gui screen, error "function code cannot be selected."
@Snake_Mundo_Animal
5 жыл бұрын
Olá você pode tirar uma dúvida minha.? Script
@annyeongmimi
6 жыл бұрын
Hi ! is there any way to remove the extra step to extract and recombine into excel ?
@csongorvarga
6 жыл бұрын
I am not sure what you mean. You can ignore the steps of combining the separate files if you extract is not huge. I have a separate video if you only need a "single" SE16 extract.
@tabletlemos2956
6 жыл бұрын
Hi why don't you use power query to work the text file?
@csongorvarga
6 жыл бұрын
These are the tools I know. I am sure there are dozens of different methods to do the same.
Пікірлер: 15