A solution to last week's challenge can be found here!

Are you going to Inspire London?

So are we, and we couldn't be more excited!

Between two full days of Platform Training, a variety of breakout sessions, keynotes, and (our fave!) THE GRAND PRIX, we are ready to get.amplified!

Surely, all this activity will make us pretty thirsty.

In preparation for Inspire, complete this week's challenge to map out the nearest pubs to Tobacco Dock where we can grab a pint with fellow Alteryx aficionados.

Alteryx does a great job of simplifying our business processes, eliminating the need to maintain, document, and use Excel Macros. However, for that one workbook with 100’s (or even 1000’s) of lines of VBA code + months of development behind it, we have a simple way to integrate that Excel Macro within your workflow. This can greatly ease the transition from Excel to Alteryx and save you rework or buy you time to convert the process.

What we will use:

Alteryx’s Run Command tool

VB Script to call our Macro

An example can be found attached at the end of this post. Simply extract in Alteryx and Open.

To implement is very simple – place the Run Command tool where you need the Excel Macro to run in your workflow. This example shows the most basic workflow.

The command we will be executing is CScript, which can run Visual Basic Scripts. We will need to provide it a script; a simple one is shown below.

VBA_Example.vbs

Option Explicit

...

Hi all,

I have 330 identical files and I need to change their name based on the info in a certain cell (the location of the cell is always the same in all 330 files).

Attached you find a example excel where the yellow marked cell needs to be target for the filename changing.

I hope you can help me!

Kind regards,

Mikkel

Hey there, it’s the Product Team at Alteryx! Did you hear @russell_christopher, Senior Director of Product Management, talk about Server.Next at Inspire this year?

We’d love to know what excites you the MOST when it comes to Server.Next? Below is a small sample list of features (don’t worry if you don’t see something, this is just a sample). Which one will make the most impact if your team had Server.Next today?

Sites: A collection of users, groups, and assets that provides complete data segregation for an organization.

While a user may be a member of multiple sites, assets are never shared between sites.

Virtual File System: Able to save workflows and apps on in the system and also share those folders with groups or individuals

Custom Roles and Permissions: The ability to customize roles and permission for groups or individuals

Enhanced Search Capabilities: Easily search for assets, data, and apps across the site.

Share Workflows and Apps

Modern...