soap

  1. A

    Help Calculating Average Cost using a Vlookup?

    Hi, I am hoping someone can help! I am trying to set up a spreadsheet for an online business that updates the 'cost of purchase' depending on which stock order has been sold. For example, if I order 10 units of soap at $10 then the cost is $10. If I make a second order of 10 soaps at $12...
  2. T

    How to send cell value as SOAP request?

    Hi folks, hope someone can guide me please. I have a spreadsheet with 900+ rows of data which is concatenated to a point where I have a fully-formed SOAP request in column W for each row. Is there a way that I can either send all of these SOAP requests in one go (which would be great for the...
  3. C

    Soap Query and dump in excel

    Hi All Sorry if this has been requested, i went through the previous posts, but i cant find the answer im looking for Can anyone please help me with the following: I want to make a soap database query using VBA, and then dump the report in excel readable sheet This is my soap scrip form...
  4. S

    Does WEBSERVICE(url) work for SOAP based Web services?

    Hello, I am new to web services, and I am trying to connect to DHL timetable WS. https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx The WSDL can be found here: https://www.dhltoolbox.se/DHLTimeTableWS/TimeTable.asmx?wsdl When I connect through SoapUI 5.4.0, I can send requests and recieve...
  5. S

    Store Billing Data Analysis

    Hello Everyone! I'm about to join a company that sells retail products through its stores. Hence, they should have data available on their customers shopping quite easily. For Example: The billing data shows that a customer buys soap, shampoo and potatoes; another buys shampoo, soap and...
  6. krishnaoptif

    VBA code to upload Excel file into SharePoint custom list item using SOAP

    Hi Experts, I am trying to upload excel file into SharePoint 2013 custom list's item. I am using SOAP in VBA. I am unable to identify, how to convert my excel file into base64Binary format file using VBA code so that it can upload into SharePoint custom list. Below is the code which I am...
  7. krishnaoptif

    Excel VBA to create of Excel file.

    Hi Experts, I am trying to upload excel file into SharePoint 2013 custom list's item. I am using SOAP in VBA. I am unable to identify, how to convert my excel file into base64Binary format file using VBA code so that it can upload into SharePoint custom list. Below is the code which I am...
  8. S

    Get SharePoint List data.

    Hello, I'm struggling with combining SP and Excel. I've got a document lib. on SP with metadata FileName/Checked Out To/Modified by in normal view. My macro is going to open one of these files stored on SP. What I need to do is to verify if file, which I'd like to open, is Checked Out and, if...
  9. S

    Handling of VBA XML response

    I have created the below code.. Sub VATCHECK() Dim sURL As String Dim sEnv As String Dim xmlhttp As New MSXML2.xmlhttp Dim xmlDoc As New MSXML2.DOMDocument 'DOMDocument sURL = "http://ec.europa.eu/taxation_customs/vies/services/checkVatService" sEnv = "<?xml...
  10. N

    Run a SOAP statement using a VBA macro to import data

    Hi All, I want to implement a macro, that can run a SOAP statement (present in the file itself), and send the values present in the excel file to a particular system. Let me break it down for you: 1) there is an excel file with data on something...say Sales Calls made by a Sales Rep 2) there...
  11. O

    SOAP, REST API and password protect macro

    Hi, I'm gonna try to pull data into MsExcel using an API. I have the choice between REST or SOAP, what's best? Any code example somewhere? Although, to call the API I will need to provide my password in clear. Is there a way to protect (password?) the part of the code running the API? Thank you
  12. I

    Soapmapper Error

    Hi, I'm trying to connect to a web service using excel. I have currently no issues logging into the web service and also fetching data using one of the methods. But the two other methods, I get the error that states that it had run into an error restoring data. There are 4 main method...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top