topic Re: How to upload data from excel in SAP using Excel functionality in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838975#M1590741 <HTML><HEAD></HEAD><BODY><P>I need to update is using any button on excel and writing code in macro...</P><P>so i am trying using VBA active x control but when i click on the button i am getting logon pad but after connection i am getting RFC error...can anybody plz guide me.</P><P></P><P>Sachin</P><P></P><P>Edited by: Sachin Bidkar on May 16, 2011 5:43 AM</P></BODY></HTML> Thu, 05 May 2011 06:28:59 GMT Former Member 2011-05-05T06:28:59Z How to upload data from excel in SAP using Excel functionality https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838972#M1590738 <HTML><HEAD></HEAD><BODY><P>Dear Experts,</P><P></P><P>My requirement is user will open the spreadsheet and enter the data as per template and then without saving, he will use some functionality(like any button or IMPORT?EXPORT from EXCEL) and then the data should get updated in SAP..</P><P></P><P>Is it possible? If any solution...please let me know....how to do this</P><P></P><P>Regards,</P><P>Sachin</P></BODY></HTML> Tue, 03 May 2011 06:38:24 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838972#M1590738 Former Member 2011-05-03T06:38:24Z Re: How to upload data from excel in SAP using Excel functionality https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838973#M1590739 <HTML><HEAD></HEAD><BODY><P>Hi Sachin, </P><P></P><P>Such requirement of yours will need a mixture of VBA (from Excel) and Function Module/BAPIs to send data from Excel to SAP..</P><P></P><P>I "google" some links and found this :</P><P>[http://it.toolbox.com/wiki/index.php/How_can_I_upload_data_to_SAP_and_download_data_to_Excel%3F]</P><P></P><P>Good Luck...</P><P></P><P>Will Wilstroth</P></BODY></HTML> Tue, 03 May 2011 06:57:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838973#M1590739 Wil_Wilstroth 2011-05-03T06:57:47Z Re: How to upload data from excel in SAP using Excel functionality https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838974#M1590740 <HTML><HEAD></HEAD><BODY><P>Please guide me more</P></BODY></HTML> Thu, 05 May 2011 05:35:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838974#M1590740 Former Member 2011-05-05T05:35:56Z Re: How to upload data from excel in SAP using Excel functionality https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838975#M1590741 <HTML><HEAD></HEAD><BODY><P>I need to update is using any button on excel and writing code in macro...</P><P>so i am trying using VBA active x control but when i click on the button i am getting logon pad but after connection i am getting RFC error...can anybody plz guide me.</P><P></P><P>Sachin</P><P></P><P>Edited by: Sachin Bidkar on May 16, 2011 5:43 AM</P></BODY></HTML> Thu, 05 May 2011 06:28:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-upload-data-from-excel-in-sap-using-excel-functionality/m-p/7838975#M1590741 Former Member 2011-05-05T06:28:59Z