In Progress

Excel macro needed (runs on Windows)

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

Skills: Data Processing, Excel

See more: site manager needed, password protected excel, looking for windows 8, excel for windows 8, Vlookup, save to excel, macro to upload, excel vlookup, excel to wordpress, excel password, wordpress print preview, wordpress excel import, runs, net excel import, window excel 2013, excel macro csv, url import data, import data macro excel, net import excel, window print preview, workbook csv, save file directory, excel 2013 macro, excel save pdf macro, excel refresh

About the Employer:
( 7 reviews ) London, United Kingdom

Project ID: #4736428

Awarded to:

omaralieissa

Hi, i can do this in C#, thanks.

$60 USD in 3 days
(7 Reviews)
3.7

14 freelancers are bidding on average $84 for this job

mrbrave

Macro expert with great experience here..

$64 USD in 3 days
(85 Reviews)
5.5
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$49 USD in 4 days
(23 Reviews)
5.3
expertatwork

Experts team here !

$45 USD in 3 days
(18 Reviews)
3.7
vikashgadia

excel macro expert...............

$61 USD in 3 days
(15 Reviews)
3.6
vickkey7

Hi, I am ready to start this project...

$64 USD in 2 days
(9 Reviews)
3.5
flashsaiful

i can do this

$55 USD in 3 days
(16 Reviews)
3.1
rbbahia

Hi, I have large experience Excel and VBA macros. I can do this for you. Wait for your contact.

$50 USD in 3 days
(4 Reviews)
2.5
anamaria1979

I want to work on this project “ Excellent work, quick and high qualdelightity

$55 USD in 1 day
(2 Reviews)
2.1
kami7644

ready to start work

$55 USD in 3 days
(5 Reviews)
1.6
mrazon2

Hi, I can provide you the specified macro. If you're interested, just let me know. Regards, Ondrej

$50 USD in 2 days
(0 Reviews)
0.0
nargisrahman

Hello Sir!!! I am very much eager to have my first job with You. I am confirming you that if I get the project I will deliver my highest dedication possible. Waiting for your kind consideration.

$45 USD in 5 days
(0 Reviews)
0.0
andreyel

Programmer C++, VB, VBA. I would love to help you with this solution.

$40 USD in 2 days
(0 Reviews)
0.0
pavellint

Hi! That can't be done with one Excel macro only. Excel cannot login to Wordpress site and do stuff there. It should be either a macro + some uploading application or a single windows desktop application with all that More

$477 USD in 12 days
(0 Reviews)
0.0