Forum

Hi David, This actually creates a 2 dimensional array- the quirks of VBA! To access the contents you need Debug.Print ArrayMortality(i, 1) ...

Hi David, I just ran it on my W10 Office 64 bit PC?? So, you still haven't said what problem you are experiencing. When you try to run the macr...

Hi Hannu, When the search returned nothing, a pop-up was created in the Chrome browser - didn't you see this? Because your code was looking for ...

Hi Martin, I'm not sure there is an equivalent in PQ to a Global Temp Table, and I'm not sure how you intend to make use of one. If you create a...

no worries 🙂

Hi Omar, So you want to send each sheet to a different email address? You can't reliably set up Excel to auto-send at specific periods. For a s...

Hi David, You need to be specific about what the problem actually is. When you say 'can not be used any more' - why? Are you getting an error? ...

Hi Nati, Can you please explain what it is you are actually trying to do. Why are you exporting data from Excel to Word? There might be a better ...

Hi Agal, I presume you want a scatter chart? Enter your data and create the chart, then select an axis and right-click -> Format Axis. The...

Hi Jacek, Are we talking about tables in Excel workbooks? As Anders said, you should use Get files from folder in Power Query. What's the goa...

Hi Martin, You can write a query to create a "temp table" in PQ, but if you are doing this in Excel, the query will load the data from SQL every ti...

Hi Hannu, Please post your most up to date code, so I can see where you are up to. regards Phil

Hi Jospeh, The "table table-striped table-sortable roster" is the CSS class for the table and isn't guaranteed to be unique. The ID of an element ...

Hi Jacek, Yes, just double click the name on the left hand side of the PQ editor and type in the new name. Or, click the query name on the left ...