Forum

Hi Chris, you say you have 24 queries to load the 24 tables from 24 sheets. These are all from the same workbook, or different workbooks? You s...

Hi David, Did you try changing the email account name in the VBA as I asked? I also asked you to let me know the name of that account. And th...

Hi Jacek, The final table is on a new sheet 'Final Query'. Regards Phil

Hi David, Yes you can. Have you changed the Email Account Name in the VBA to look at the folders for the account you are referring to? To help ...

Hi Alistair, Yes you can stop the animation. I've added a stop button and a new sub that stops it. To move the chart, select it, cut, paste to ...

Hi Guys, Try the attached file. I've rewritten it to use late binding so you don't need to set a reference to the Outlook library. Cheers Ph...

Hi David, What does that error say? Have you created the reference to the Outlook library in the VBA editor? Phil

Hi Julien, Pleas see attached file. Note that the last step in the query is to filter the text string "null" from the merged column. This is be...

Hi Deepak, Please refer to this Please supply a clear explanation of your problem and include a workbook and some examples of the expected result...

Hi Sally, As Purfleet says, sounds like you have the data in a table. When you change a formula in a cell this change is copied down the column. ...

Hi Marsil, You need to set a reference to the Microsoft Outlook 16.0 Object Library in the VBA editor. Sorry I thought you'd already done this as ...

Hi Chris, Can you supply the workbook so I can try to recreate the issue. Have you tried loading a table or creating a connection only just to s...

Hi Jacek, I'm not clear on what result you actually want. Is the result table in your image what you want? Or is this what you end up with when t...

Hi Chris, The topic title says 'when updating Power Query' - but the link is talking about connecting a query to the data model. So how exactly ...

Hi Corrie, no file attached. regards Phil