Search results

If you use regular expressions you can easily cater for multilingual instances.

Whilst I sympathise the real question is are these files in a standard format? If so then manipulation in text is possibly long winded but only needs defining once. And it's the way it should be done! I agree with your final remark!! I personally would probably do it using regular...

Rule 1 - never process csv files in Excel. Rule 2 - repeat Rule 1. Always manipulate csv files as text!

Glad someone asked this before me. Discovered (eventually) that it is a hindi word, having found no trace of it in either theOED or Webster. I've learned something!:)

I only meant that the settings had been changed: not the other problems of my original query ( thank goodness). I was just expressing my annoyance.

Happened again yesterday - windows updated and the VPN settings put to on again!

I obviously didn't explain myself properly! The VBA IDE is common across all Office applications and it's the references dialog itself (which uses the underlying MSForms technology) that is causing the problem. The MSForms.dll is just the entry points for the technology and the dialog can't...

What I worked out years ago was although Access doesn't use MSForms directly there references to bits of it which it does use so as soon as you open any form those are in memory 'in use'.

I think I had this problem and solved it by removing the reference in code. I may even have done it by linking to the offending database from another. This is, however, dredging back in memory so I may be wrong.

One aside for this - I too use the MS Forms object - but , however, it does not work if the conrol you are copying from has data that has ever been encrypted. And no I don't know why!

Always used it, but spelled a one word -mollycoddled.

I have been following this thread with great interest as it seems to give a glance of where we may be going. However, I have three minor comments: 1. In the project life cycle coding is the simplest and most trivial of all the activates involved, so the saving may not be very much. We now...

Actually the character names is a myth. I got this, I might add, directly from John Ryan himself when he was signing my daughter's copy of 'Pugwash and the Buried Treasure'. He agreed that Master bates sounded bad the way Pugwash pronounced it but the Cabin boy was always Tom and there never...

Possibly youngsters don't have baths anymore! 😁

Oil is the problem with a lot of foods. Fish and chips was traditionally cooked in beef dripping which makes a far less greasy, crisper product. Have to find chippies that still use it though which are few and far between.

Very sensible since we can't agree. However, we will, of course, tell you when you are wrong.😂 Wrong here is defined as "I disagree with you" whatever the actual evidence.

Not disputing pizza is Italian but what is fun is the way every town down the Amalfi coast claims it is them who invented it! It also isn't necessarily unhealthy - just the sugar and fat laden commercial versions with the ultra processed toppings!!

Came across another difference today which surprised me. I got talking to two American tourists in my home city of Norwich. I used the expression "to throw the baby away with the bathwater", which they'd never heard before. Do our US members recognise this expression?

Can now ignore this problem as stated as I have run the cause to ground - the .ini file is on my NAS. For some reason best known to itself at random intervals the new Win 11 PC wants the drive's credentials verified. Seems to be about every 7 to 10 days, despite instructions to remember the...

Has anyone had experience of using GetPrivateProfileSection / string etc in Win 11. Can't find any relevant bits on internet but what works on Win 10 (and Win 7, 8.1 before it) just doesn't work on 11. *** I hate Windows 11!!