asp

  1. M

    Price/volume effects by customer groups

    Hello I need to calculate price / volume / mix effects between year N and N+1, but by customer groups. So by customer it is very easy to have each effect: Price = (Price N+1 - Price N) * Volume N Volume = (Volume N+1 - Volume N) * Price N Mix = (Price N+1 - Price N) * (Volume N+1 - Volume N)...
  2. T

    VBA: List Row in Separate Sheet if multiple criteria's are met and more! Need help!

    Hello! Any guidance and help will be GREATLY appreciated! I have written out what I need (with examples) to give you a clear picture on what I'm trying to accomplish. I hope it helps. Scenario I have a "revenue forecast" sheet that shows Customer, Item, Quantity and Average Selling Price...
  3. M

    xmlHttp Post in VBA from ASP Query?

    Good Afternoon, I have been trying to no avail to get a VBA script to tunnel to my corporate reports viewer which is ASP I believe, choose a drop down choice, enter in a SKU and run the query. I have been able to successfully do it when I have VBA launch and IE window for me, but that process...
  4. M

    Solution to auto-populate data from Excel to website

    Hi I am looking for a solution to auto-populate a web form on https://www.gov.uk/calculate-state-pension from a list in Excel. Start will be clicked by default. Next, State Pension Age will be selected by default Next, Gender will be selected per Excel Next, DOB populated from Excel (dropdowns...
  5. D

    Extract Data from aspx web form (asp.net) to excel using VBA

    Ok, this is what I would like to do. I need to access an aspx website that I log into with my own personal login. There is a specific collection data I would like to then navigate to and that is a web form that houses data for my clients. I want to aggregate this form data into an excel sheet. I...
  6. M

    Cannot import data from Excel 2013 into ASP file

    I am using Excel 2013, and I am following the example here: VBScript Scripting Techniques: Read Excel files without using Excel that reads in Excel data as an ADO record set to a classic ASP file using VBScript. I am not able to import all the Excel data successfully, and I need to know what I'm...
  7. L

    XMLHTTP problems

    I'm trying to extract data from some webpages. I'm pulling in the html with an XMLHTTP object and extracting the desired information with Regex. The following code works fine for vanilla ".html" pages: Dim pageHTML As String Dim oXMLHTTP As Object Set oXMLHTTP =...

Watch MrExcel Video

This Week's Hot Topics

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