post

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

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

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:

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

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

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

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

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

Hi I want to understand Developer-->Design mode and what is used for. I read this post https://www.mrexcel.com/forum/excel-questions/32669-design-mode-vba.html and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...

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?

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

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

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

What up?

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

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

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.

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

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

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