Forum

Hi Larry, What formula are you using? I've seen errors reported on High Sierra OS, so HYPERLINK function might fail on that system. Path structure mig...

Hi Robert, Data looks good as it is for pivot tables, data does not have to be in the same structure of the pivot tables, that's what a pivot does....

Hi Duncan, The function is adjusted for this topic, John's test files have the headers AFTER the first row. You have to remove the line in GetCSV func...

@Duncan: If you tried to open the function, you actually invoke the function and that indeed asks for a file path. The file is supposed to be us...

Using the File attached, any csv files can be combined, no matter how different their headers are. Of course, like Duncan said, first row is irrele...

It's a function, all you have to do is to paste it in any standard module, then call the function from your code to clean the text: CleanedString=C...

Hi Marsil, Here is a function that can clean the text and keep it under 30 chars: Note that () are not illegal chars in a sheet name. Functi...

You can also try this query, might be faster: let Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content], WordList = List.Buffer(Excel.CurrentWo...

Hi John, Try this solution:

Here is the code I tested in ThisWorkbook VBA module: Private Sub Workbook_Open() Call startClock Call runspeech End Sub The code for run...

Hi Bandi, One way to make it hard to break is to convert excel to exe, here is a free tool:It still needs excel to be installed, it does not become...

Try this code: Sub Search_Range_For_Text() 'loop through a range of cells to test if the cells contain some text: Dim cell As Range For E...

Hi Alice, See this topic, there is a RangeToHTML function that you can use.

Hi Steve, That function does not exist in PQ, you have to recreate it. There is an example here:

You're welcome 🙂 Offset can start from any range size, you have also optional arguments to resize the output range width and height if needed.