Forum

Hi Howard, It's much easier to do this kind of thing directly in the command line. Writing VBA to call FSO is just using the Windows Shell/Command...

No problem Bill. Where do you want to get the company website address from? Looking at the results I get when searching, for 3M the 1st search ...

Hi, Please attach your workbook. Have you tried using the code in this blog post Plotting Real Time Data Regards Phil

Hi Daria, When I tried to open your file Excel told me that the VBA project and macros were corrupted. Can you please attach another copy of the...

Hi Bill, Please start your own topic if you have a question, don't tag on to someone else's topic. Your code doesn't work because you're looking...

No worries Robb.

You're welcome.

Hi Patrick, Your formula in Col I was referencing itself - you should have been given warnings by Excel about 'circular references' when you opened...

Hi Nawaf, PC specs are only part of the story. Performance in PP and PQ will be affected by things like: A poorly designed data model Writin...

Hi Chris, You could nest them inside each other but that'd be very ugly! Try this = Table.SplitColumn(#"Trimmed Text", "String", Splitter.Sp...

Hi Dave, If you're getting this data from the web then you should try using Power Query to get it. But with the data supplied already in Excel, th...

Hi Gokhan, No file is attached to your reply. Did you try my file? Regards Phil

Hi, This can be done in a Power Pivot Pivot Table. Have you got PP? What version of Excel do you have? See attached for solution, and this post...

Nearly forgot to mention that you will need to make a change to the PQ Options otherwise every time the query runs PQ will ask you to give permission ...