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

I received from You so many questions about this, so I decided to investigate the issue. In this video I’m going to show You how to save as and open Excel spreadsheet during execution of SAP scripting code.

WATCH NEXT:

TIME STAMPS:
0:00 Intro
0:25 Save as & Open transaction example
1:10 Recorded example code
1:29 Coding & trials
3:15 Final solution
4:23 Hit that like & subs button!

MY EQUIPMENT:

FREE TubeBuddy 30-DAYS TRIAL:

SITE & SOCIALS:

CONTACT:

Don't forget to leave like and subscribe to my channel, it means a lot to me :)

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to create and provide more content for You!

[DMF]

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

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

[ridanaeem]

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

[marcosogasawara]

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

[MKEWSH]

Thank you again for your help on this! :)

[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.

[chemagarcia]

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.

[chemagarcia]

Hi, Other way to solve this topic is to split the macro in two :

Sub Macro_1()
….
= “\\ …”
= “File …”



Application.OnTime Now + TimeValue("00:00:15"), "Macro_2"
End Sub

Sub Macro_2()
ActiveWorkbook.Close False
End Sub

[demcjqq]

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

[osmanfaruker]

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.

[ssabyasachi]

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