Completed

Excel macro needed (runs on Windows)

This project was successfully completed by omaralieissa for $60 USD in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Skills Required
Project Budget
$40 - $60 USD
Completed In
3 days
Total Bids
14
Project Description

Excel macro needed (runs on Windows)
Macro need to do the following
1. Macro runs on specific time AA:AA daily on excel workbook [url removed, login to view]
2. Downloads file (file A) [url removed, login to view] and place in directory AA
3. Downloads file (file B) [url removed, login to view] and place in directory BB
4. Updates/refresh all “[url removed, login to view]” workbook data with new values (by looking for data values in file A and file B). “[url removed, login to view]” workbook is already configured to vlookup values in these .xls files
5. “[url removed, login to view]” workbook will have sheets named “DailyUpdate” and “Manager” that need to be saved:
Worksheet “DailyUpdate” we save as [url removed, login to view] (save to directory CC (will specify myself later))
Worksheet “Manager” for statistics/my checks we save as [url removed, login to view] (save to directory CD (will specify myself later))
6. Opens URL WWW (in new window) and logs into a password protected site (Password: XA Username: XB). WordPress site
7. Uploads/navigates file [url removed, login to view] (the one in directory CC) by clicking “Browse” file button
8. Ticks “Tick Box”
9. Then press “Upload and Preview” button
10. Then press “Import” button
11. And Saves it self
12. Repeats the cycle again (see step 1)

Step 7-10 will provide more details (Print Screen ideally)

Thanks

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online