QQ is always the "high light" of my week (even if its on a Saturday)!  

My weeks been great.  I've spent the last few days deep diving into Excel's Power Query language (M code) with my "partner in crime" Grok!  I've been using m code to pull data from a couple of finance sites.  The m code also checks for missing data (i.e. markets closed) and "forward flows" from previous data to fill in the blanks.  The only real issue was that Grok keep wanting to think that a particular date was a "Thursday" when it was actually a "Friday".  I had to remind it several times.  LOL!!!

Last week was a reality check, coming back from three weeks overseas.
Between jet lag and catching up on e-mails and contacts: it was almost overwhelming.

The good news is that our team of developers has increased by seven new developers in the last few weeks.

I'm working on either fixing or cleaning up code I've either worked on or put into quick fix projects that may come in handy in the future.

Kinda putting together a proof-of-concept only type database that once something works well, I can just grab for future projects, and what doesn't work, it's a simple location to find and hash out when I have time.

So far I've pretty well cleaned up my first one with list boxes (drag-to-size column widths). Still working on getting some other projects working reliably.

Simple stuff mostly for more experienced folks I'm sure, but I've been happy with results for only working with VBA for only a year or so.

Sam I've been meaning to look into that M code myself. I don't do a lot with Power Query because obviously I do most of my work in Access, but I've read some good things about it. Let me know what you end up figuring out.

Sami It's good to have you back. I know how bad it is traveling to Europe, and the jet lag is a real thing, but glad you made it home safe. And wow, seven new developers is huge, congrats! That's awesome news.

Donald That's a great approach, honestly. Having a "proof-of-concept" database you can pull working chunks from later is exactly how you build your own personal toolkit. And if you've only been working with VBA for about a year, you're doing really well, especially tackling stuff like listbox behavior and reusable utilities. Keep it up!

Richard My "journey down the M code river" started because I watched your videos on getting data from web pages.  I didn't want to write VBA to parse through the text, so I started wondering if Excel had some functions that would do it for me.  I asked Grok about it and it said that Excel's data queries and connections could be set up to pull data from tables on the web page.  From there I asked more questions about how to set it up.  That led to M code and the advanced editor.  Several iterations of M code later, I had a working sample that takes start/end dates from the spreadsheet and pulls data for a stock symbol/ticker for those dates.  If the market was closed one or more of those dates, the code uses the data from the last "open market" date.  I can drop the "test" code into the chat if anyone is interested.  LLAP!