Automate Bulk PDF Extraction with Excel VBA and SAP GUI Scripting

Подписаться 8 тыс.

Просмотров 8 тыс.

50% 1

Get instant access to the eBook "SAP GUI Scripting: Understanding the Basics" and discover how you can transform your SAP work processes, reduce errors, and boost productivity!
joelting.com/sap-ebook/
📚 RESOURCES IN THIS VIDEO:
PDF Export Automation:
drive.google.com/file/d/1OUXr...
Automate the extraction of sales order PDFs using SAP Scripting and Excel VBA! Learn step-by-step how to record the script, develop the solution in Excel, and save PDFs to a desired folder. Boost your productivity and efficiency with this tutorial.
Stay tuned for our upcoming comprehensive course on SAP Scripting and Excel VBA fundamentals. Join the waitlist now using the link above! Like, subscribe, and hit the bell icon for more SAP and Excel tutorials. Enhance your workflow today!
#SAPScripting #SAPGUIScripting #ScriptingTracker
DISCLAIMER:
SAP® and SAP GUI Scripting are registered trademarks of SAP AG.
I am NOT associated with SAP AG in Germany or any other country. I am NOT SAP Partners. I do NOT offer live SAP Training. I do NOT offer SAP Access. We do not recommend the use of SAP Access from any particular provider.
MY FAVOURITE TOOLS & GEAR:
📝 Notion - How I Manage My Day - affiliate.notion.so/hpemzmxen3jq
💻 My Personal Laptop - Legion 5 Pro - amzn.to/3nZrn1I
✈️ My Travel Companion - Macbook Air M1 - amzn.to/43jLLuE
📷 My Camera Gear - Sony ZV-E10 - amzn.to/40T7uIj
MY OTHER SOCIALS:
🌍 My website / blog - joelting.com/
🐦 Twitter - / joelting92
🏢 Linkedin - / joel-ting
🙎🏻‍♂️ WHO AM I:
I'm Joel, a Regional Finance Controller working in Singapore. I make videos about technology, automation and productivity.
📧 GET IN TOUCH:
If you'd like to talk, I would love to hear from you. Email me directly at joelting92@gmail.com would be the quickest way to get a response. I will try my best to reply to your email as soon as possible.
P.S. Just a heads up, I receive a kickback from some of the links in this description as they are affiliate links 😜

Наука

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

3 июл 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 57

@JoelTing Месяц назад

I just launched "SAP GUI Scripting: Understanding the Basics" ebook! If you are interested to learn more, check it out in the link below: joelting.com/sap-ebook/

@loveenasukhija3015 Месяц назад

Hi Joel, thank you for sharing your knowledge. It was really helpful 😊

@micuentaotakumats4083 Год назад

Que hombre tan pro, muchas gracias por compartir tu conocimiento ❤️

@Receivable Год назад

Great information. Thank you for sharing!

@user-hn1kb5hg6j 8 месяцев назад

This is insanely amazing thank you so much

@reng7777 Год назад

Awesome!!!

@s1ngularityxd64 Год назад

really helpful 🙂

@guan_meng Год назад

Microsoft Edge has replaced the defunct Microsoft Internet Explorer. Could you share about Excel VBA automation for SAP using Microsoft Edge? Thank you. 😊

@fakhrullnoor4102 Год назад

hi joel..how did u install sap in ur computer? can i download and using it from our personal computer?

@JoelTing Год назад

Hi there. You will need access to a SAP server. It is not free and usually they will be charging a monthly fee. You can try and google for "SAP Live Access". There's different providers for this service.

@user-mm7xn1fe8p 9 месяцев назад

@joel what happens when there is no attachement at all on the order? How would code look like if in a case a Sales Order no attachment, it populates next to SO in excel that "No attachment" then continues with the other orders????

@JoelTing 9 месяцев назад

Hi there, I assume the attachment is a table list in SAP? For the attachment table, you can check the number of rows available in the table to see if there's attachment. If there's more than 1 row (attachment available), then execute the remaining script, else, update Excel to label no attachment and proceed with the next iteration in the loop

@estebanrocco942 11 месяцев назад

Hi Joel, thanks for sharing your knowledge! I was wondering if something like this can be applied to download the PDFs of invoices in the T Code VF03. I know that bulk PDFs can be downloaded from T Code VF31, but I need input their respective names for each one.

@JoelTing 11 месяцев назад

I see. I am not too familiar with VF31 and VF03. As long as you are using PDF! transaction to export your PDF and your company allow scripting in production environment, usually it's not an issue.

@loliloucrew 10 месяцев назад

Hi Estaban, Thanks to Joel's scripting, I was able to adapt to VF03 tcode to download the invoices and it works perfectly by using the "editing".

@saikatdasgupta5433 6 месяцев назад

Thnks for the knowledge sharing. I don't have access the c drive.So while running your code file not save.please suggest the alternative code to save the pdf. Thanks in advance.

@user-yj4tz5wx4m 4 месяца назад

DOUBT PLS EXPIIN ME

@fechedenes522 11 месяцев назад

I wondering can we make Error ANALYZER automation in SAP?

@JoelTing 11 месяцев назад

Hi, may I clarify, what do you meant by Error ANALYZER automation?

@user-zf2fk8mw6n 4 месяца назад

how if my file is in pdf form while I cant execute the "pdf!" function, how can I track the file location in order to save them?

@JoelTing 4 месяца назад

Hi there. Usually how is the PDF file being displayed for you without the "pdf!" function? Is it like what I have shown in the video?

@user-zo8qi5zp3t 4 месяца назад

genial! puedes por favor hacer un video para grabar e imprimir ordenes de compra en base a una me53n a una me21n

@JoelTing 4 месяца назад

Hi there! I'm not too familiar with the purchasing cycle processes. As a start, try to understand the starting point. See where you can 1st get the information you need (could be a SAP label or range of Excel cells), then think about how you can pass it into the script until it reaches its final outcome.

@prakashsparrow3842 9 месяцев назад

Is that any other way to find the element id in sap?

@JoelTing 9 месяцев назад

Another way to find the element ID is just to interact with the item (can be clicks) so that it is being recorded. When you are looking at the recorded script, you will be able to see the ID being recorded with its method.

@sarfarazalam459 11 месяцев назад

Is it same for T CODE -FBL3N?

@JoelTing 11 месяцев назад

FBL3N is just GL Account Line Item Display right? So there's no PDF? unless you are referring to attachment of individual documents

@subramaniyamm7200 11 месяцев назад

How to attach email backup file in sap with help of vba?

@JoelTing 11 месяцев назад

Hi, this can be done. Once you have the file path, you can use the outlook method - .Attachments.Add to attach the PDF into the email

@subramaniyamm7200 11 месяцев назад

@@JoelTing but am getting error msg, if possible pls share with your video link, i will refer the video. Thanks

@Cjvllmr 11 месяцев назад

Hello, i cannot save the pdf to the destination file path. I followed your coding. What to do?

@JoelTing 11 месяцев назад

Hi there, what error are you encountering? At which steps does it fail? Are you using the PDF! command? You can always use the watch window in the VBA editor to check what went wrong and how it went wrong.

@Cjvllmr 11 месяцев назад

@@JoelTing Thank you for the response, the error fall on the FileCopy sourceFilePath, DestinationFilePath (RUN TIME ERROR '53' , when i try to run the codes it always stopped there and the error pop up. what do i need to do to correct the code and run it smoothly, your help will be so much appreciated, It will help me with my project. THank you and keep safe! Godbless

@JoelTing 11 месяцев назад

@@Cjvllmr This error seems to be saying that it isn't not able to locate the file. Can you check what is the sourceFilePath variable value at the point of error?

@Cjvllmr 11 месяцев назад

@@JoelTing the sourcefilepath is saving on the hidden folder, i do not know if i can change it since its our companys laptop, can i change the sourcefilepath where the pdf is saving? Is there any work around to make this work?

@JoelTing 11 месяцев назад

@@Cjvllmr the sourceFilePath is the hidden folder where the PDF is stored. The file copy function is basically taking the PDF generated in that hidden folder and copy it over to your destination file path. The sourceFilePath should not be changed. It is generated from the previous steps

@786VIMAL 10 месяцев назад

Hi Joel, Great Video for fetching bulk pdf files. I have one question in this regard. How to find element ID "wnd[1]/usr/cntlHTML/shellcont/shell" without using scripting tracker as I need for Tcode ME23N to download Purchase Order.

@loliloucrew 10 месяцев назад

HI, I have same question as you have. I searched on line but was not able to figure it out ...

@786VIMAL 10 месяцев назад

@@loliloucrew I also search online but unable to find any solution for it let's wait for Joel reply.

@JoelTing 9 месяцев назад

Hi there, sorry, I missed your comment. The quickest way to get the element ID is using the scripting tracker. Without the scripting tracker, it's possible but it's tedious. You can try to use Excel watch window to do that. Once you are at the Print Screen page, add "Session.findById("wnd[0]/usr")" to your watch list. Expand the "Children" property and you should see "Item 1", "Item 2" etc.... Expand further "Item 1" or "Item 2" and look for the subtype "HTMLViewer". If you are not able to find, continue to expand the Items until you find the subtype "HTMLViewer". This is the subtype containing the "BrowserHandle" property, which is the PDF viewer that you are looking for.

@786VIMAL 9 месяцев назад

@@JoelTing Thank you for sharing your knowledge on this I will try as suggested.

@loveenasukhija3015 Месяц назад

@@JoelTinghi I am trying to find the element Id through this way however I am unable to get it. Can you do a short video on this as well

@JP-br7eh 12 дней назад

destinationFilePath = empty

@JP-br7eh 12 дней назад

how to solve ?

@JoelTing 12 дней назад

Hey there. I'm not able to understand what happened there with so little context. It could be the Browser Handle not returning the file name or it could be some other reason that breaks the assignment of that variable.

@monke8478 Год назад

Hi Joel. I wanted to ask if its possible to extract data from SAP and transport it to an existing excel tracker / spreadsheet? Is there a way to automate this so that I don't have to log on to SAP everyday and manually extract the data from SAP to my excel tracker

@JoelTing Год назад

Hi there. If scripting is enabled, it is possible to extract data and copy it over to an existing spreadsheet. The log on step can be a bit challenging. If your company uses Single Sign On, it may not be possible to automate the process based on my understanding. Even if you are able to develop that automation, as log on requires user id and password information, we will need to think of a way to store that information securely.

@user-yj4tz5wx4m 4 месяца назад

HII BRO SMALL DOUBT PLS EXPLAIN ME

@user-ym7fo5we1d 5 месяцев назад

Hi Joel, thank you for your video. Great help! Although, I encountered some problems along the way. I can download some Sales Order smoothly without errors, but there are some that shows "the control could not be found by id" in this Set container = Session.FindById("wnd[1]/usr/cntlHTML/shellcont/shell"). can you help how to debug this?

@JoelTing 5 месяцев назад

Hi there. Are you able to tell the difference when the error happen and when it runs smoothly? This seems like the HTML container is not loaded yet, or it is using an entirely different element to load the PDF.

@user-ym7fo5we1d 5 месяцев назад

@@JoelTing figured out the solution to this. I had to tell my colleague who is testing my code to use internet explorer instead. However, I’m encountering several problems when I had my colleagues test out the code. It works perfectly well on my laptop but when they test it out, problem occurs like the naming and saving of files in specific folder. Do you have a work around on this?

@JoelTing 5 месяцев назад

When you mentioned naming and saving of files, is it because you are putting the destination file path as a static folder in the code itself which they dont have? If that's the case. what you could do is to check if the folder directory exist. If it does not, then create the directory before you proceed to move the file to that folder.

@user-ym7fo5we1d 5 месяцев назад

@@JoelTing I think the issue why it is not proceeding to download is because of the security pop-up of SAP "do you want to save this file". I think SAP scripting cannot record it. Do you happen to know the code? Unfortunately, I cannot disable security in my colleague's app.

@JoelTing 5 месяцев назад

I did some searching online. It seems like an issue with the Adobe Reader where it is not opening the file in SAP. They are not able to preview the PDF file within SAP GUI in the first place, and that basically breaks your code. Maybe you can try the following on their laptop: 1) Check if they have Adobe Reader installed 2) Check the Adobe Reader "Preferences" -> "Internet" and make sure everything is checked 3) In Internet Explorer, "Tools" > "Manage Add-ons" > "Toolbars and Extensions", make sure "Adobe PDF Reader" is enabled I found this in SAP community. community.sap.com/t5/technology-q-a/unable-to-view-pdf-files-in-infoview/qaq-p/4631345