Тёмный

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

SimpleExcelVBA
Подписаться 2,4 тыс.
Просмотров 6 тыс.
50% 1

Опубликовано:

 

2 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 35   
2 года назад
Bro, I was looking for this for hours. Thank you so much. Got subscribed.🙋‍♂
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
So happy to see that! Thank You!
@dalboz
@dalboz Год назад
Thanks, seems a clever workaround!
@SimpleExcelVBA
@SimpleExcelVBA Год назад
Thank You!
@M4KE4W1SH
@M4KE4W1SH 2 года назад
Thank you again for your help on this! :)
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
You're welcome! I'm open for your suggestions! :)
@nburaq
@nburaq 2 года назад
Great! So valuable thanks for sharing
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
Happy to hear that!
@chemagarcia1168
@chemagarcia1168 2 года назад
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
@SimpleExcelVBA 2 года назад
I'll try to fix that :)
@DMF1966
@DMF1966 3 месяца назад
Excellent solution! I've been searching for this for a long time! New subscriber!
@SimpleExcelVBA
@SimpleExcelVBA 3 месяца назад
Thank You! :)
@NiteshMittalbadboy
@NiteshMittalbadboy 2 года назад
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
@SimpleExcelVBA 2 года назад
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
@mgodek7092 2 года назад
thanks for sharing
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
You're welcome :)
@مريومالعشوان
@مريومالعشوان Год назад
Hi , what about if I want preventing the excel from open after extracting it?
@SimpleExcelVBA
@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
@SimpleExcelVBA Год назад
@@مريومالعشوان I think it is not possible
@osmanfaruker6894
@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
@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.
@ssabyasachi25
@ssabyasachi25 2 года назад
May be i am missing something...but this is not working every time... sometimes it is able to detect and sometimes not🥴
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
It was working everytime for me, can You tell the transaction where it is not always working?
@ridanaeem1012
@ridanaeem1012 Год назад
Hi, thank you for this video. I don't understand the working but the solution works and solves my issue
@SimpleExcelVBA
@SimpleExcelVBA Год назад
Happy to help! :)
@ridanaeem1012
@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
@SimpleExcelVBA Год назад
@@ridanaeem1012 Hi, I need more details, please post them somewhere :)
@marcosogasawara3008
@marcosogasawara3008 2 года назад
Thanks to share this solution! This helped me a lot. 👍
@SimpleExcelVBA
@SimpleExcelVBA 2 года назад
Glad I could help :)
@sapisoftware1942
@sapisoftware1942 Год назад
Genius!! thanks a lot!
@SimpleExcelVBA
@SimpleExcelVBA Год назад
You're welcome!
@chemagarcia1168
@chemagarcia1168 2 года назад
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
@SimpleExcelVBA 2 года назад
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! :)
Далее
У КОТЕНКА ПРОБЛЕМА?#cat
00:18
Просмотров 633 тыс.
Taking SAP screenshots with GUI Scripting
34:52
Просмотров 19 тыс.
Shell Function in VBA || Open PDF file using VBA
9:12
How to deal with SAP tables - PART 1
18:06
Просмотров 3,4 тыс.
This is how I ACTUALLY analyze data using Excel
24:05
Просмотров 229 тыс.
The Value of Source Code
17:46
Просмотров 49 тыс.