Search results

Take a look at FileSystemObject. https://analystcave.com/vba-filesystemobject-fso-in-excel/ Some of the methods you could use: https://analystcave.com/vba-filesystemobject-fso-in-excel/vba-buildpath/ https://analystcave.com/vba-filesystemobject-fso-in-excel/vba-copyfile/...

I believe it is a war crime and has been called out as such. But in simple terms, Two wrongs don't make a right. Regardless of what your opposition does you are still obligated to follow international laws and norms.

Pat, you are awfully violent. I was only responding to your comments to SachAccess. No need for you to put words in my mouth with what you think I think, nor make assertions that I'm anti-semetic. I asked A.I. if Israel targets civilians because you emphatically stated they don't. That was...

reports indicate that Israel has hit civilian targets, resulting in numerous civilian casualties. Key Points: Allegations of War Crimes: Various sources, including UN human rights bodies and organizations like Human Rights Watch and Amnesty International, have concluded that Israeli military...

That's because the bound column is 1 based, unlike the columns which are 0 based.

Just checked and it's still available through the Way Back Machine https://web.archive.org/

I must say I'm having a ball playing around with the controls collection. I re-wrote my Date picker class using the controls collection for the 42 command buttons for the dates. So much less code than before. It's also much easier to set the different properties and methods of the controls...

This example writes file paths to a table with no duplicates

I'm sure you meant "here"

I feel ya too Gasman. I've struggled with this since MajP's challenges a few years ago. Especially the pseudo controls one. It's finally sinking in though so don't give up hope.

In 1937 to 1977 G.E. dumped cancerous PCB's into the Housatonic river and polluted it from the middle of Massachusetts down to Pat's area in CT. The litigation to clean it up started 30 - 40 years ago and is still being litigated. I wouldn't say "easily handled"

https://jwcolby.blogspot.com/2025/05/the-book-event-driven-programming-in.html

The blog link takes me to an onboarding page.

Am I correct in thinking the latest versions are available at these links? If not, where?

john, I'm kicking myself in the ass for not looking through your database that has literally been sitting in the corner of my desktop for about a year and a half. For the longest time I've never been able to wrap my head around using collections of classes to do various things. Woke up this...

Figures it was the first time I used A.I. for code. Probably the last also.

You can blame A.I. for that. But it did work.

Just discovered that I have some of your stuff from a few years ago when you did a presentation for George. Never had the chance at the time to go through it and forgot about it.

Hi John, I'm a big fan of classes and I'm enjoying your work so far. One thing I noted was in the very beginning you have a timer class which uses an Api. I run 32 bit at home and 64 bit in the office. Had to change the dec's use it. #If VBA7 And Win64 Then ' Declare for 64-bit Office...

I just googled the QR code without the date portion and that's what came up.