Probably. All you need to do is learn the SAP object model.
Facetiousness aside, this is much more a SAP question than an Excel one.
However it's done using other systems, it's likely to be very similar with
VBA. Do you have any example code from these other systems?