In Progress

Excel Automation - scheduling report generation automatically

Make a scheduler in excel to trigger automatic generation of report at regular intervals.

Code should automatically identify the latest raw data file from a predefined folder based on timestamp and pick it for further processing.

Pick up the excel file and add additional business logic to entire set of data

Save the excel file as csv format in predefined network folder

Keep a log of the files processed with date/time of processing.

Code should automatically keep checking for newer files every 10 minutes (time should be custom and can be changed)

Skills: Data Scraping, Excel, Excel Macros, Excel VBA, Web Scraping

See more: report automation in excel, how to generate report in excel using vba, generate reports from excel data, how to generate reports in excel using macros, automation of report generation, how to automate excel reports using macros, report automation tools, automated report generation software, microsoft word automation report generation, report generation dashboard using excel, vba excel report generation, excel report generation sql server, excel report generation, report generation excel vba, report generation excel charts text

About the Employer:
( 8 reviews ) Macedonia, United States

Project ID: #15605436

Awarded to:

jaylancer43

Expert Excel Programmer on [url removed, login to view] and have been featured by the freelancer community [url removed, login to view]) Relevant Skills and Experience I am an En More

$700 USD in 4 days
(513 Reviews)
8.0

7 freelancers are bidding on average $736 for this job

$777 USD in 10 days
(8 Reviews)
4.2
$700 USD in 3 days
(5 Reviews)
2.3
kkc1985612

Hi., I have been working as developer for 6 years.I am proficient in mobile phone,HTML5, CSS, PHP, Wordpress.I can begin to work your project now.I am waiting for your [url removed, login to view] thanks! Stay tuned, I'm still working More

$777 USD in 10 days
(1 Review)
0.0
$700 USD in 2 days
(0 Reviews)
0.0
sumi12021

• Proficient in installation and administration of workstations i.e. Windows 2003, Windows 2008, Windows 2008 R2, Windows 2012, Windows 2012 R2 etc. • Proficient in database • Proficient in linux. Stay tuned, I'm st More

$777 USD in 10 days
(0 Reviews)
0.0
$722 USD in 10 days
(0 Reviews)
0.0