LeoLee
02-17-2011, 07:13 PM
Hi All,
I am currently doing a project that require my Excel 2007 to send a XML to a web services by doing it fully automatically with a click of a button. (My Excel 2007 can generate a XML with a click of a button as I have done the coding already.)
This mean that I need to call a SOAP web services in VBA. However, I don't know if using SSL is supported by excel/VBA. To my understand, I know that a basic requirement for SSL in this case is that you will need to load server root certificate into the client respectively. This is similar to the root certificates in our browser and I have the root certificate required.
I have had no experience or knowledge in web services integration with VBA prior to this new project tasks assigned to me. Hence, I am really lost and dont even know where should I research at this point onwards.
The only resource I know is from this web http://msdn.microsoft.com/en-us/magazine/cc163837.aspx which discuessed about Web Services toolkit. However, this is in Excel 2003 and I know that Excel 2007 no longer provide Web Services toolkit.
I would really appreciate if you guys can point me to a direction as I do not know where I should even proceed from here. :mkay Or maybe some resources for me to read to get me starting to do this project.
Thanks a million!
Best Regards,
Leo
I am currently doing a project that require my Excel 2007 to send a XML to a web services by doing it fully automatically with a click of a button. (My Excel 2007 can generate a XML with a click of a button as I have done the coding already.)
This mean that I need to call a SOAP web services in VBA. However, I don't know if using SSL is supported by excel/VBA. To my understand, I know that a basic requirement for SSL in this case is that you will need to load server root certificate into the client respectively. This is similar to the root certificates in our browser and I have the root certificate required.
I have had no experience or knowledge in web services integration with VBA prior to this new project tasks assigned to me. Hence, I am really lost and dont even know where should I research at this point onwards.
The only resource I know is from this web http://msdn.microsoft.com/en-us/magazine/cc163837.aspx which discuessed about Web Services toolkit. However, this is in Excel 2003 and I know that Excel 2007 no longer provide Web Services toolkit.
I would really appreciate if you guys can point me to a direction as I do not know where I should even proceed from here. :mkay Or maybe some resources for me to read to get me starting to do this project.
Thanks a million!
Best Regards,
Leo