When we use alteryx and when use vba in automation?

RichardAlt

Hi guys,

I'm a bit curious in alteryx and vba , we all know that two can use in automation.

But when we use alteryx in automation? and when we use the vba in automation?

For ex. if there is a formula in excel and need to automate. What should I use? Because both can automate. Something like that.

Thank you.

FYI, I'm quite new using alteryx. Need help to understand when we use alteryx in automation. Thank you!

Garrett

For me personally, Alteryx is the choice hands down when working with multiple, disparate data sources (databases + flat files + lookups + files broken out by time period + etc.).

I typically only ever use VBA if I'm working on a single Excel file or perhaps multiple Excel files, but they are all still Excel files. My most common use case for VBA these days seems to be formatting Excel files (typically after they've been produced using Alteryx).