Forum

Hi Amien, You need to use Power Query to get the data into Excel from Sharepoint. That will fix your problem with dates in text format. To illus...

Hi Al, No file attached. You have to click on Start Upload to upload the file. Phil

You're welcome.

Hi Amien, No file(s) attached. You need to click on the Start Upload button. Without seeing your data I can't be certain but you my benefit for...

Hi Walid, What is it you are actually trying to do? Why are you copying data to a new sheet or workbook? Can you please supply your workbook(s)...

Hi Walid, I wrote a post on this Plot real time data in Excel and recently answered a question on the same topic How to plot live data in ...

Hi Marsil, Insert this snippet into your code after you've created objOutlookMsg Dim Account As Outlook.Account For Each Account In objOutloo...

Hi Dave, No files are attached. You need to click on the Start Upload button after selecting the files. Regards Phil

No worries 🙂

Hi Faha, PQ won't be able to get that data because the data is generated by JavaScript and isn't stored in a <table> element on the page. ...

Hi Leslie, In that sample file, the header name had a trailing space so it was actually 'DOW ' not just DOW. Remove that trailing space and it wor...

Hi Maarten, Did you mean to attach files? You need to click the Start Upload button after selecting the files. Phil

Hi, Can you give an explanation of what it is trying to do and what you want. It looks like it is trying to get some info about Groups on Yammer...

Hi Faeza, No file attached. Regards Phil

Hi Leslie, Please attach your query too. Phil