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

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...
Top