Forum

Hi Bill, Please start your own topic rather than adding to an existing topic that is not related to your problem. You can follow these instruction...

Hi Jacek, If there's more data to work with then you need to supply it please. And provide detailed examples of the expected results for this da...

Hi Mohith, The attached file will do what you want. I've modified the message body as it didn't need the time in the string, I'm picking that ...

Hi Jacek, If that is all the data you will be working with you can just use an IF. There are only 2 possible outcomes "Linux" or "Windows" and the...

Hi Josia, Please post a workbook when you ask a question so we don't have to recreate your workbook. It also makes it harder for me to visualize e...

no worries 🙂

Hi Scott, It's always best to supply your workbook so we don't have to recreate it. Times and dates are stored as serial numbers in Excel ...

Hi Praveen, Looking at the website in my browser, I can see that it periodically sends new information to the browser. I suspect what is happening...

Thanks Miguel, Just a note. If you turn off error handling On Error Resume Next you should turn it back on after the expected error has occu...

Hi Steve, When the timer reaches zero, the value in B1 is zero. If you close the workbook in that condition, you are calling Stoptimer from Workbo...

Hi Steve, You said you found the reason for the debug but it's not clear what that was. You already are calling Starttimer in Workbook_Open and ...

Hi Praveen, The URL in your query responds with HTML not JSON so I get the error in PQ DataSource.Error: The downloaded data is HTML, which isn'...

Hi Bunmi, You can split the column by delimiter (space) from the right, then do it again let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[C...

Hi Tina, It should work fine. Did my formula work for you in the file I attached to my last post? Maybe you need to attach your file where it...