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...
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

This Week's Hot Topics

  • link pictures from Sharepoint to Excel macro
    Hi, I need your help to fix this issue. I have a code and this is work on my computer. But now I try to link the picture from the SharePoint to...
  • lookup match return closest to x date
    Hi all, Happy New Year, this is my first post in 2022. I have two worksheets I'm working with. worksheet one is titled KPI Data - MY22 ONLY It...
  • Average hours per week
    I'm trying to find a simpler/quicker way to obtain the average number of hours per week for employees. My spreadsheet contains columns for Date...
  • Google Sheets IMAGE Function
    Is there any way to replicate the IMAGE function from Google Sheets in Excel? Maybe a VBA code? From what I can tell, the function in Google...
  • Identify equipment used -No of consecutive days
    Hello, I appreciate your time and effort. I would like to have formula for column O and P. Column A : lots of Asset Column C: date If one Asset...
  • Filling in data from source
    Hi All, I'm not quite sure what to call the following type of data manipulation so I don't quite know how to phrase my question. Below is an...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top