Hi there,
Need macro for excel to do the following
Macro should look like that:
1. Macro runs on specific time AA:AA daily
2. Downloads file from link A and place in directory AA
3. Downloads file from link B and place in directory BB
4. Updates/refresh all workbook data (data values is set to vlookup for values in file A directory AA and file B directory BB)
5. Save
6. Save worksheet named C in directory CC as [login to view URL] file
7. Opens URL WW (in new window) and logs into a password protected site (Password: XA Username: XB)
8. Uploads/navigates file [login to view URL] (the one in directory CC) by clicking “Browse” file button
9. Ticks “Tick Box”
10. Press “Upload and Preview” button
11. Press “Import” button
12. Saves
Repeats the cycle again (see step 1)
Step 8-10 will provide more details (Print Screen ideally)
Thanks
Dear friend, I can do this job because I have a great deal of experience in this area. I know the insights. I hope to start this work as soon as possible. If you have any questions, do not hesitate to ask.