1. S

    XmlHttp request to get a ticker from Morningstar

    Hi All, I'm trying to read the ticker (called F00000LWVH) used on Morningstar on a fund with this query based on an ISIN: Sub MstarTicker() Dim Url As String, XmlHttp As New MSXML2.XmlHttp, PayloadStr As String, RespVar As Variant Url =...
  2. S

    WinHttpRequest with POST times out

    Hello all, I'm trying to import some data for a fund listed on the Luxembourg SE. When I go to the site, I can insert the ISIN code, LU1883863935, in the search field and from there I can read the exchange symbol, 294814. As I'm trying to get the data into Excel, I can see when I use Inspect...
  3. M

    How do I pass the body for a POST HTTP request using YouTube API playlistitems.insert?

    I keep getting the wrong number of arguments or invalid property assignment error but I'm not sure what I'm doing wrong now. Here are some pictures:
  4. P

    Excel 2010 formula to look up duplicates so I can contra them off

    Hi, first of all thank you for looking at this post. I have started a new job and am wanting to improve the speedof the month end process. I have to download the information from Excel from thenominal ledger to review (approx. 3000 lines) some of the values are the same butare pluses and...
  5. S

    Autoexecute when Access is open or closed

    I have been looking for my original post or the post that I think I thought was mine but was someone else's. Anyway, we have an access tool that someone else built. Each day I press a "Run All" button and 20 mins later I finishes and I continue. We are trying to have this run automatically a...
  6. T

    Posting Screen Prints to Questions

    I have a basic question that I haven't figured out. How do I post (paste) a screen print to a message I am posting? I see the Insert Image icon in the ribbon, but when selected it prompts for a URL. How do I post a picture stored locally on my computer to the question I am posting? Thank you...
  7. I

    excel survey calcustion, pre and post session.

    A colleague has asked to see if there a way of creating a formula to calculate the progression that a group of young people have made through a survey folllowing a short course. The table below shows 9 young people and where they gauged their level of understanding before and after the session...
  8. J

    Histogram graph

    Hello We use a product that generates an histogram on a PDF I would like to generate a mirror image of the report but I also need help to generate an histogram graph. How can I show you how the reports looks as I can't post images
  9. L

    design mode

    Hi I want to understand Developer-->Design mode and what is used for. I read this post and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
  10. H

    Copy to next blank column - almost there

    Hi All, I want to post to the first blank cell in Row 'L' after L3, but it is pasting to B3. Any correction pls?
  11. Dan Wilson

    Forum privileges

    Good day. After writing a rather lengthy question, I found out that I am not allowed to attach documents to my post. What privilege do I need to be able to do that? Thank you, Dan Wilson...
  12. J

    Question About Posting Questions Posted on Other Forums

    Hi everyone, can i post a thread present in another forum? jc
  13. P

    VBA - How to call a new tab with variable name

    Hi, I've written some code in VBA which creates a new tab based on a cell value. As you can imagine this cell value can change. After creating this tab i wanted to paste some information into it. However, I cannot call the tab; i'm getting error 9 subscript out of range. Or Object required...
  14. D

    why am I not allowed to post attachments? Can I include a picture or image in my post?

    What up?
  15. DataBlake

    [vba] Checking if sheet exists inside array

    Hello, I have this sub from jmacleary found on this post but i thought i would be best to start a new post as the problem has shifted So the sub will grab sheets from an array and put the first column of each sheet into one sheet titled "Unknown" My problem is that the sheets are now generated...
  16. G

    Vlookup based on contents of a cell

    I've gotten a list of post codes and their counties. This is how the data is presented: <thead> #EAECF0[/URL] , align: center"]Postcode area #EAECF0[/URL] , align: center"]Postcode districts #EAECF0[/URL] , align: center"]Post town #EAECF0[/URL] , align: center"]Former postal county...
  17. D

    How long does it take a moderator to approve a post

    Hi all, new to this forum. I tried to make a post about 4 hours ago but it will not show up in the Excel Questions forum. How long does it usually take for a moderator to approve it. I made myself look stupid by trying to post it twice more thinking I did something wrong the first two times.
  18. H

    How to attach file on newpost

    Hi everyone! I'm new mem :) How to attach file on the new topic Thanks you so much!
  19. B

    Count consecutive occurrences when sum of two consecutive numbers below 3

    Hello, I have a column of numbers : 3 0 4 2 1 0 5 0 3 2 0 2 I am trying to get the number of times the sum of two consecutive rows is below 3. In this example 4 (i.e. 2+1,1+0,2+0 and 0+2). I tried a way around with this formula : =SUMPRODUCT(--(FREQUENCY(IF(C5:C16<2, ROW(C5:C16))...
  20. K

    Distance between addresses

    Hi, I am looking for a way to find the closest destination based on a post code entered by an user. As below, when an user inputs "Post code A", I would like the macro to use maps:) and bring back the closest location to post code A which for e.g may be Post code Y Post code entered : Post...

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
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 "".
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