God! I hate doing macro. VBA scares me

Welcome to... wait where are all these new folks coming from 🤨

Ok this is getting crazy, oh hi again, yeah vba is a painful but necessary evil if you work with excel.

@C0D4 they heard we had cake.

@broseph but the cake is a lie.
I'm still waiting for it.

I'm pretty sure we have cookies though.

@C0D4 I just found out that I’m type 1 diabetic a couple of weeks ago so I won’t get too excited anyway 😂 😂

@C0D4 I'm new, though I doubt my reason for coming here is the common one. For data purposes though, I was browsing the top of all time on /r/programmerhumor and found a devrant watermark (probably user made) in a meme.

@colboy welcome to devRant! We hate macros, too.

@-Minty- ah that guy. That watermark is generated when you save an image on mobile.

Thanks for the warm welcome. I would appreciate the cookies once im done weeping.

I do sometimes have to code some VBA occasionally. Yeah, it's one tragic language.
Specially when some non-techie made a macro that reads hard-code ranges and values to automate himself and you spend a good day to understand that damn thing!
Get out of vba world ASAP. It's known to be career crushing.

python+lib that outputs to excel.
maybe pandas.
Avoid vba like the plauge it is.

Ah, VBA. The only language I've ever encountered that uses BOTH 0 and 1 as starting indexes. *In the same library 0_o*

But no really is there a way to use python for macros?

@Techno-Wizard not for Microsoft suite as far as I know, but you can use python for Google docs

@Darkovernerd 🤨for real?

@C0D4 which part of my comment? 😂

@Darkovernerd the python part😂
I have a serious need to fully automate a painful process without using excel, it's already macro'd in excel but I want to migrate this task to a sever where the data is read from anyway once put together.

@C0D4 https://developers.google.com/sheet...

https://developers.google.com/sheet...

@Darkovernerd 😱Oh My Fooooking Gawd, 😍

There goes my week of work.

@C0D4 hahaha yeah. It's a very nice to use API, I think you have to use OpenId Connect or OAuth to access it. If that is the case the client credential flow is probably best for your use case.

@Darkovernerd Oath2, Which is no problem.

I'll have to spend some time digging through the docs to work out my use cases correctly but this looks overly promising.

@Techno-Wizard well, I've got really good results with xlwings (FOSS).
This is if you are strictly restricted to the Excel environment.

You'll need to add its plugin to excel, and then can use python to write your own UDF (user-defined functions) and call them in excel.

https://www.xlwings.org

Another commercial one is pyxll, but its pretty expensive.