How to Save As & Open Excel spreadsheet during SAP scripting?

[@DMF1966]

Excellent solution! I've been searching for this for a long time! New subscriber!

[@SimpleExcelVBA]

Thank You! :)

Bro, I was looking for this for hours. Thank you so much. Got subscribed.🙋‍♂

[@SimpleExcelVBA]

So happy to see that! Thank You!

[@مريومالعشوان]

Hi , what about if I want preventing the excel from open after extracting it?

[@SimpleExcelVBA]

Just don't use solution from this video :)

[@مريومالعشوان]

@@SimpleExcelVBAActually the file will be open by default !! ,this why l asked if l can prevent it

[@SimpleExcelVBA]

@@مريومالعشوان I think it is not possible

[@marcosogasawara3008]

Thanks to share this solution! This helped me a lot. 👍

[@SimpleExcelVBA]

Glad I could help :)

[@ridanaeem1012]

Hi, thank you for this video. I don't understand the working but the solution works and solves my issue

[@SimpleExcelVBA]

Happy to help! :)

[@ridanaeem1012]

Hey, one other issue. Some SAP transactions take time e.g. if we are checking all the inventory. I am using macro for this and My macro crashes (giving me pop ups to wait or to cancel it) while waiting for sap to execute the command

[@SimpleExcelVBA]

@@ridanaeem1012 Hi, I need more details, please post them somewhere :)

[@dalboz]

Thanks, seems a clever workaround!

[@SimpleExcelVBA]

Thank You!

[@osmanfaruker6894]

Hello, when getting report on SAP by VBA the report automaticly openning always. this is problem for me how can ı solve? I only want save function.

[@SimpleExcelVBA]

Hello, haven't found the way yet to only save the file. That's why I figured out to deal with that in such way.

[@M4KE4W1SH]

Thank you again for your help on this! :)

[@SimpleExcelVBA]

You're welcome! I'm open for your suggestions! :)

[@sapisoftware1942]

Genius!! thanks a lot!

[@SimpleExcelVBA]

You're welcome!

[@nburaq]

Great! So valuable thanks for sharing

[@SimpleExcelVBA]

Happy to hear that!

[@chemagarcia1168]

Thanks for your videos. Very interesting.
Can you use your screen of VBA in colour blank? In black it’s more difficult to read the code.

[@SimpleExcelVBA]

I'll try to fix that :)

[@NiteshMittalbadboy]

Can you please create a video to automate F-03 (Clear GL Account Manually) based on Document Numbers and multiple company codes through excel.

[@SimpleExcelVBA]

Hello! I would love to help You with that, but unfortunately I don't think I have access to that transaction. Have You tried with SAP Script recorder? What is the issue You struggling with?

[@mgodek7092]

thanks for sharing

[@SimpleExcelVBA]

You're welcome :)

[@chemagarcia1168]

Hi, Other way to solve this topic is to split the macro in two :
Sub Macro_1()
….
session.FindById("wnd[1]/usr/ctxtDY_PATH").Text = “\\ …”
session.FindById("wnd[1]/usr/ctxtDY_FILENAME").Text = “File …”
session.FindById("wnd[1]/tbar[0]/btn[11]").Press
session.FindById("wnd[0]/tbar[0]/btn[3]").Press
session.FindById("wnd[0]/tbar[0]/btn[3]").Press
Application.OnTime Now + TimeValue("00:00:15"), "Macro_2"
End Sub
Sub Macro_2()
ActiveWorkbook.Close False
End Sub

[@SimpleExcelVBA]

Hello! Thank You for sharing. I was there and it was not working for me + didn't want to use ActiveWorkbook object. But appreciate your input! :)

[@ssabyasachi25]

May be i am missing something...but this is not working every time... sometimes it is able to detect and sometimes not🥴

[@SimpleExcelVBA]

It was working everytime for me, can You tell the transaction where it is not always working?