In Progress

Automate Internet Explorer object from VBA -- 2

The following is what I want to achieve using VBA macro:

1. Current VBA have login form with just one button called Login

2. When user click on Login, the following two actions takes places:

a. Login code form opens, this form accepts login code

b. Internet explorer browser window opens

3. Internet Explorer window navigates to a URL. This is currently hard coded for development purposes but otherwise it will be a dynamic URL.

4. Internet Explorer will CONDITIONALLY show login page.

5. User will enter login details in IE.

6. After successful validation, IE will download a file called [login to view URL]

Work expected from this project:

10. I expect that in IE, the only task user should perform is to login .

11. Once user successfully logs in , the automation should take over next activities and do following:

a. Read the content of [login to view URL] file

b. Put content of file in form that opened in point 2.a above.

12. There will be situation that when IE opens the login page it wont ask for login as previous session is already active. In such case the file will automatically start downloading.

13. After putting content of the file in excel form, close IE window. Also close IE if user closes form that was opened in step 2.a.

14. Put enough debug message so that it becomes easier for you to debug any issue

Project milestones:

Milestone 1: £30

Delevop VBA that works with sample URL and sample login details. This is something you will be able to test yourself on your local PC.

Milestone 2: £20

I have other URL using which I will test your code. I want you to debug any issues with me on WebEx. FYI: I won't be able to provide you with login details.

I will share sample file on chat with interested candidates.

Skills: Excel, Excel Macros, Visual Basic, Visual Basic for Apps

See more: google map internet explorer object expected, internet explorer object doesnt support property, internet explorer object doesnt support, internet explorer object php, internet explorer object doesnt, error internet explorer object doesn, internet explorer object doesnot support property object, copy internet explorer page vba, internet explorer object doesnt suport action, erro internet explorer object, internet explorer activex vba, internet explorer object properties, javascript internet explorer object doesnt support property method

About the Employer:
( 31 reviews ) Uxbridge, United Kingdom

Project ID: #21179646

Awarded to:

The24CarrotsInc

Greetings!! We have ample experience working on this. We ensure 100% quality with on-time delivery. Please allow us to take this opportunity. Thanks & Regards, Team@The24CarrotsInc

£50 GBP in 2 days
(70 Reviews)
5.8

6 freelancers are bidding on average £86 for this job

sunshine7677

Dear Client, I can do this Project and ready to start the work right away. I have 5+ Years of Experience in EXCEL (VBA and MACROS), Web Scrapping (Python, Octoparse, Parsehub,Selenium and Beautifulsoup), Data Entry, P More

£50 GBP in 2 days
(12 Reviews)
3.2
anshsparkle

HI I am experienced in Visual Basic Excel Visual Basic for Apps etc I can start right now but i have few doubts and questions lets have a quick chat and get it started waiting for your reply

£135 GBP in 7 days
(1 Review)
3.0
ravim211071

hi there I am an expert in excel vba. and web scraping using excel. so I know what you are asking and I am confident enough that I can complete it. waiting for your response.

£44 GBP in 2 days
(3 Reviews)
1.5
popov4sa

hello ! I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. Awaiting an affirmative response from More

£135 GBP in 7 days
(0 Reviews)
0.0
jiangjiabao

Hello. ⭐⭐⭐⭐⭐"High Quality, Speed, Honesty"⭐⭐⭐⭐⭐ I read your project very carefully and I am ready to start working on it. I am an expert with all the skills which you mentioned in your project description. If you w More

£100 GBP in 2 days
(0 Reviews)
0.0