Excel and SAP

[Pmuel]

So I have made scripts in the past that interact successfully with SAP (navigate to a section grab information and paste it into the excel file)

I am trying to get a code to work from Excel. I recorded a script in SAP that takes me to a page where I can see jobs that my company has ran in manufacturing and it will show me the volume of each raw material used to complete that order. I want to grab that information and the best way I can grab that information is to get SAP to show that information in an excel spreadsheet inside SAP. I record this script from SAP and I have that file. When I click on the .vbs file it works great. When I modify the code like how I am familiar with to run inside of excel, it runs and completes the code but the spreadsheet is now blank.

Is anyone here familiar with SAP and why this might be happening?

I can post the code but I don't think it would be useful for anyone. Let me know though.

Thanks.

[Keebellah]

Hi, I'm no SAP person but I did it once at work (long time ago)
A quick search with Google gave me some hits that might help
https://towardsdatascience.com/autom...a-9c63a28ff566
https://blogs.sap.com/2012/08/22/sap...with-ms-excel/
https://stackoverflow.com/questions/...ata-out-of-sap

Hope one of these can put you on the right track
You vbs script is translated to vba correctly should do the job too, but with the SAP access it won't be much help here to help you

[scottiex]

Does that mean you are using 'excel in place' in SAP?

I would try exporting the data to a file which is saved wherever you want and then pulling the data from there for reporting by using vba to open that file and working with it.