Forum

Hi Monika, You can use the following formula in cell P3 in your file and then copy it down and across: =IFERROR(INDEX($B3:$M3,MATCH(EOMONTH(P$...

Hi Velouria, I've managed to get a solution working using your code. As long as the main workbook is saved on the SharePoint site this will allow t...

Thanks for the reply Velouria ...... that works to a point but what I am really trying to work out is a way for the user to navigate to their SharePoi...

Hi - I am just trying to get the path ......

Hi Salim, Anders formula works but has a typo. It should be: =VLOOKUP(E10,D3:F6,3,TRUE) Cheers Graham

Hi Mynda, I'm not sure if I'm misreading your comment above when you say "you cannot get data from an open Excel workbook". Just to confirm, I can ...

Hi Mynda, I did already test for artifacts in the worksheet using CTRL+END and that didn't show any anomalies. Using Code 2 only: My run time di...

Hi Mynda, So I've found out a little bit more. Password protected workbooks appear to be imported differently. If I look at the Power Query Editor...

Hi Mynda, Thank you for the reply. Now you've enlightened me on that I can see it makes complete sense from reading the code 🙂 However, I thin...

I had a thought on this ...... could it be that Code 1 is for importing from a closed workboook and Code 2 is for importing from an open workbook??? ...

Hi Punith, Try this: Sub OpenMultipleURLs() Dim vURL Dim ie As InternetExplorer Dim iCount As Integer Set ie = CreateObject("InternetExp...

That's brilliant Fluff ...... works perfectly ..... thank you 🙂