Forum

create EXCEL VBA to...
 
Notifications
Clear all

create EXCEL VBA to get file from SAP

2 Posts
2 Users
0 Reactions
192 Views
(@carzur)
Posts: 9
Active Member
Topic starter
 

Wondering if I could get some assistance with SAP+VBA excel. I am a novice with SAP. I want to create in excel a VBA to download/save invoices from SAP HANA. I know how create and get a script in SAP HANA and copy paste in excel but it would not work. So my excel file would be simple:

  • Column A: list of the invoices to download

So I want the VBA to loop until the last invoice on the list

 
Posted : 27/06/2021 3:28 pm
(@catalinb)
Posts: 1937
Member Admin
 

Why vba?
It's much easier for you in Power Query, all you need to do is to enter your credentials and select the table you need to bring into excel.

(Get Data>From Database>From SAP HANA Database)

 
Posted : 29/06/2021 2:43 pm
Share: