https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088674#M732600 <HTML><HEAD></HEAD><BODY><P>Greetings. My name is Hong. I'm had some experience in VBA but am entirely new to SAP. Recently I was asked to work with a colleague to fix an Excel macro that uploads data from Excel to SAP. </P><P></P><P>Here is our problem. After the user does explicit logon to SAP from Excel, the upload function would work only once. When the macro button is clicked for a 2nd time, it prompts "System Failure". </P><P></P><P>Is this the way it works? </P><P></P><P>Should I post our code here?</P><P></P><P>Thank you very much in advance.</P></BODY></HTML> Tue, 27 Nov 2007 18:00:57 GMT Former Member 2007-11-27T18:00:57Z https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088674#M732600 <HTML><HEAD></HEAD><BODY><P>Greetings. My name is Hong. I'm had some experience in VBA but am entirely new to SAP. Recently I was asked to work with a colleague to fix an Excel macro that uploads data from Excel to SAP. </P><P></P><P>Here is our problem. After the user does explicit logon to SAP from Excel, the upload function would work only once. When the macro button is clicked for a 2nd time, it prompts "System Failure". </P><P></P><P>Is this the way it works? </P><P></P><P>Should I post our code here?</P><P></P><P>Thank you very much in advance.</P></BODY></HTML> Tue, 27 Nov 2007 18:00:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088674#M732600 Former Member 2007-11-27T18:00:57Z https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088675#M732601 <HTML><HEAD></HEAD><BODY><P>What you are looking for is a custom automated solution that would pick the required <STRONG>Excel</STRONG> spreadsheet and load the relevant data <STRONG>into SAP</STRONG>. We were having the same problem and we ordered a custom solution of [Excel SAP Loader|http://www.excelsap.com/] for our Sales Orders data entry.</P></BODY></HTML> Thu, 14 Jul 2011 17:22:09 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088675#M732601 Former Member 2011-07-14T17:22:09Z https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088676#M732602 <HTML><HEAD></HEAD><BODY><P>I would recommend you post this under "ABAP General" rather than "Data Transfers".</P></BODY></HTML> Tue, 19 Jul 2011 08:44:58 GMT https://community.sap.com/t5/application-development-and-automation-discussions/excel-to-sap/m-p/3088676#M732602 former_member201275 2011-07-19T08:44:58Z