Hi Excel Experts,

I have an excel form that contains the data of people with their orders. I would like to export the relevant information into Siebel. Any idea how to do that using a macro which I would then link to a button. The excel will then export the data, create a new record in Siebel database and send the email to the customer.

I have searched online for this and found some info on how to login to Siebel (TheApplication = CreateObject("SiebelDataServer.ApplicationObject")) but it is still raw and I also do not really understand the approach to writing the logic of inputting the data in.

Any help is appreciated. Thank you.