Search results

OK thanks all - i will investigate more on the SAP side now i know VBA is all good. Thanks very much

Thanks Arnelgp Perhaps the problem is the # at the beginning and end of the date rather than the format (#11/03/2024#)? Do you know if VBA will pass the date to SAP with the hash at the beginning and end or is it just how it shows it in VBA?

Hello Team Thanks for your responses and apologies for not providing details. Hopefully it's something really obvious and apologies in advance if it is! I've never tried connecting to SAP and calling BAPIs from Excel before although i do write ABAP code but my VBA is non-existent. Here is the...

Hello I know this is an old thread but it represents my problem in VBA code exactly. I have been trying to call a BAPI (BAPI_CATIMESHEETMGR_INSERT) from vba to insert some data into SAP. However, the date field in the function structure (setup using Set Functions = CreateObject("SAP.Functions")...