How to navigate in Internet Explorer with a macro.

[kevin_1991]

Good day Guys,


Every day I gotta enter information in my work´s website (intranet), however I dont know that much about manipulate with VBA the Internet Explorer application, for example once I enter information in the website, I gotta enter an ID after that I gotta select the date, then I gotta give some clicks in some checkboxes, then I copy some information from excel and enter that information in the navigator, and finally click on save. The thing is that I do not have access to that website in my home so is impossible for me to provide you with the link... if someone can help me telling me what kind of codes do I need to do it, or where can I find a manual where I can learn to manipulate another application like the Internet explorer with VBA.


Thanks guys

 

[snipescc]

There is a program called iMacros that allows you to write macros in web browsers. It doesn't use the Visual Basic language, but the language it does use it pretty well documented. You can find it at Browser Scripting, Data Extraction and Web Testing by iMacros
I know this might not exactly answer your question, but it may well be helpful.

 

[kevin_1991]

Thank you so much Snipescc, it will help me a lot with another kind of tasks, I did not know that it exists and it will save me a lot of time in my work with another tasks, however the task that im trying to complete with a macro is different the thing is that I was unable to explain it very well, for example in Excel the sheet1 A1 = Employee ID, B1 = 1 C1 = 0 and D1 = Coments


Now as far as I now we can open the internet application with a macro in excel using this code
Sub navigate()
Dim ie As Object
Set ie = CreateObject("InternetExplorer.Application")
ie.Visible = True
ie.navigate "webpagelink"
End Sub


it will open the internet explorer window and all that, but my question is how do I tell to the macro that
using the internet explorer app go to the ID box and then copy the information in cells(1, 1) and paste it in the ID box from the IE apps, and after that press enter,
also how do I tell the macro that if cells(1, 2) = 1 then go the internet app and click in the first checkbox.

 

[snipescc]

iMacros is capable of entering variables that it pulls from csv. I only know how to do it if I have some documentation in front of me that I don't have at my office, but hopefully the help files can get you started. I used it to make multiple user accounts on a website, I did the process once, then replaced the parts that would be different for each person (name, e-mail, ect) with instructions to get the information from the csv. It may involve running a couple different macros in a couple different programs. There are ways to get one java to do both, but that's far beyond my programing skill.

 

[kevin_1991]

Good day snipescc,

Right now I am downloading de software and I will try it! I hope it coul help me to enter the information from excel into the website....