Elari35

Hi again, To the followup of the last question due to the new and changing nature of the website I managed to gain contact with the webmaster and provided some ideas how it could be done. Hopefully the website will undergo a update soon. I have managed to get my macros working well but few small details that perhaps you could iron out. 1) Excel 2007 windows activate. I have a Excel file open but no matter what I write or do it doesn't work if there are more than 1 window of Excel open. For example I have my file and another excel file open in different windows. No matter if I set it to exact match and set the exact name it still won't open the correct Excel. Is there a solution for this or the only advise is to keep one Excel window open constantly? 2) Internet Explorer 8. I have a webpage where I need to navigate to a button to activate it. Sadly the problem is that if I navigate there with the tab key then I have no means of activating it. Clicking enter makes the webpage click on another button at the page that means "next page" rather than the link I need to open. Mouse locator seems to like to act up sometimes making it slightly miss the coordinates. No idea exactly what is causing it. In the end I though that perhaps if I opened the buttons URL then it works but sadly I don't seem to find a way to activate a URL through MEPro without causing it to open a new window. I clicked the settings in the internet options but nothing. Any advise how this could be done would be greatly appreciated. Thanks again for taking the time to answer, Elari

Hi again guys, Thanks for the additional tips and samples of code. I'll try to learn something from them. I mostly have everything in the bag except for one thing, dropdown menu. Lets say my excel cell A2 has a value 6.4.2 and I need to transfer that to the dropdown menu. For x.x value I could just copy it, set to string and then to integer and just text type that into dropdown list. This works when I manually do it but haven't added it to the macro script yet. My question is that can the dropdown menu be used somehow to quickly get to the right line or do I have to write a large script so if the value is 6.4.2 then you need to click the down arrow for x times? The problem is that I have a lot of codes and the dropdown menu can change depending on the presettings before I get to it. If the down arrow way is really the only way then can you give me any tips how to write it the best or if it even possible to somehow make a txt or some file where it is all written down so I don't need to write that many lines for each value? Hopefully you understood my point and thanks Elari

Hi again, JohnS, thank you for the great tips and nicely written out guide. It worked for me and I managed to solve my problem! Thanks a lot! Elari

Hi, I was just wondering what were the exact steps for the following procedure: I have a value in excel cell D6. The value can range from 1-10. The website where I need to transfer that info has a dropdown list. I saved the pictures of the dropdown list in the attachment. What would be the fastest and simplest of ways to do it? Each of the cell number corresponds to the number in the dropdown list. The goal would be to select the correct number in the list. Thank you