Closed

Excel Macro Update using Alteryx

Current scenario

1. Excel connects to a Financial system - Oracle Essbase/Hyperion

2. Manual Update is being done now to update excel file for latest data from Oracle Essbase/Hyperion

Goal

1. Write a Macro to refresh the data

2. Use Alteryx ETL tool (Run Command in Events section of ‘Workflow Configuration’ window) to Run this Macro and

3. Eliminate ever having to go to excel to update the data

Catches

While trying to connect to Oracle Essbase/Hyperion via excel, an authentication window pops up which needs a password to be passed. Figure out a way to pass the Password through Alteryx and fully automate the process

Skills: Excel, Alteryx, Oracle Hyperion

See more: compare tables using excel macro, macro update log files status excel sheet, combine text files using excel macro, macro update excel, excel macro data update, run excel macro using perl, showing data excel internet explorer using excel macro, using unicode excel macro, extract name worksheet using excel macro, excel macro update sql server, vba macro scripts using excel, export excel data project using macro, excel macro update message, excel macro update sql, excel macro update mssql, excel macro update existing tabs data main tab, excel macro update inventory prices

About the Employer:
( 0 reviews ) Jersey City, United States

Project ID: #29404519

3 freelancers are bidding on average $10/hour for this job

shimanshu851

Hi, I'm Himanshu from Chandigarh, I'm an Alteryx Core Certified designer and Alteryx mentor. I have more than 3 years of work experience. I am ready to work for you as requested. I would like to schedule a meeting More

$13 USD / hour
(1 Review)
2.4
raoibrahim857

Greetings.. i have read your work above mention. so i am available for complete this work in a very effective way. because i have already experience for this. so i have also worked from many years. First of all i am More

$9 USD / hour
(0 Reviews)
0.0
golamhider1111

I have been lot of experience for data entry. I am above 10 of years experience for data entry.

$8 USD / hour
(0 Reviews)
0.0