Last seen: Aug 27, 2025
Hi Kenneth, Can you please attach your actual workbook otherwise any code we write will need to be modified to suit your real workbook environment....
Hi Bruno, The way you have implemented the function isn't the way I did it in the example file I provided. Rather than Add Column -> Invoke C...
Hi Bill, When your data is ready click on Close & Load in the top left of the query editor. NOTE click on the text Close & Load, not the ic...
Hi Uma, I've never done this with VBA, or even know if it can be done. But you could implement it with with Power Query although it isn't a trivia...
Hi Al, Implementing Step 4 isn't too difficult but I'm not sure who the emails should be sent to. For example, if the PT filter on Consolidate T...
Hi Nathan, You said you were open to alternative approaches so how about this. Rather than using checkboxes, I'm using Worksheet_SelectionChange e...
Hi Ammar, The order of the parameters for #date are year, month, day. You've got day, month, year. This is the correct format = Table.Ad...
It certainly does.
Hi Ammar, I presume that you are using dd/mm/yyyy? After splitting the text into 3 columns, recombine it with / as the separator. You can then ...
Hi Vinay, No workbook attached. You need to click on Start Upload. Phil
It was 20+ years ago. I don't have them any more
No worries David. I remember reading a manual on the DOS Prompt from cover to cover. I used to write a lot of batch files for things like remote ins...
Hi Bruno, How long it it taking? I've run this query against 100,000 rows and it takes a few seconds. And all you need to do is click on Refresh ...
Hi Hans, It appears to have something to do with the length of the string. If you split the string into 2, both halves encode without issue. I ...