Recent searches

No recent searches

Search options

Only available when logged in.
toad.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Mastodon server operated by David Troy, a tech pioneer and investigative journalist addressing threats to democracy. Thoughtful participation and discussion welcome.

Administered by:

Server stats:

274
active users

toad.social: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.1

#vba

0 posts0 participants0 posts today
Sheridan

Today in MS Access I built a form to create an invoice. It presents a list of individuals to select from and other fields.

A button runs a private subroutine that takes that info and sends it to a public subroutine which then loads a SQL append query and feeds the info into the query's parameters, and runs it.

I've never written much Access VBA before. I had to reread a lot of the Access Bible to figure this out. Bleh.

#MS_Access#access#sql
Profoundly Nerdy

Can someone suggest VBA and Python resources specifically for Excel?

I'm helping someone from the Windows world upskill. Her biggest technical skill is Excel, so we're staring with that.

I can point her towards a Byte of Python for starters, but it has nothing about Excel integration and I really want to cover that. Thanks, folks.

#Excel#VBA#Python
Chris Geoghooligan

…you really can’t pull a list of all table names in an #Excel workbook and reference it in a formula without using #VBA?

That’s… insane.

Yeah yeah, data models and #powerquery and such. These are better options when starting from the beginning, but we’re hundreds of workbooks in now and I need something (a formula) I can just drop in to be even remotely realistic in terms of feasibility.

Chris Geoghooligan

When your colleague messages you on Friday afternoon and casually mentions he’s been editing files in the directory you set up for standardizing files after QC… 😧🤯🤬

That… was meant to be a protected directory where files are moved and modified by scripts and automatons. Is that why my scripts aren’t working?!!?

#VBA#Excel#SharePoint
Chris Geoghooligan

On my 4th iteration of this process, having to overhaul it after discovering #Microsoft #PowerAutomate triggers for #SharePoint won’t fire on file movements w/in the same library 🙄. This doesn’t do exactly what I want but it’s close enough.

Now I just gotta build out all these #flows, #VBA #scripts, #PowerBI analyses, & the #PBI #dashboard.

Making more work for myself than is necessary, but I don’t want to be embarrassed by a sloppy, inconsistent product.

#ProcessMapping#QualityControl#QC
TrendingLive feeds
About