Search results

Welcome back, In my case the URL changed. And I managed to use the .LocationURL I am almost there but I am running into problems And I believe they are VBA rather than site related. If I send the code in a zip file , do you have the time to look into it. You spent so much time already....AND...

Here where I stand: 1. Navigated to page1 (LOG ON) 2. Navigated to page 2 ( UserName/Password) 3. Successfully opened the main page where I can download it for further analysis. Now, If I use : With ActiveSheet.QueryTables.Add(Connection:= ...... I am stuck with WHAT URL I use ??? It is the...

Very good question.....Answer is Security..... If you do that (use the second link directly) there is script to prevent you from doing it. It has to do of clearing cache... I will try it and send you the exact message. Have a very relaxing long week end. And we will see then

Hi, SirJB7 You are absolutely right in your comments. After all the support you gave me, and solely my fault, I am still trying to solve this very common situation, from your side , and First for me. The reason for changing gear was the advice I got here to avoid using RE if I can. And I did...

Thank you for taking the time to help me. No, but I am sure you got my remark about dealing with complicated web pages. Now if you look at the source code of the SECOND page (The log in page) at <div class="cr2tooltip"> <input id="_58_login" name="_58_login" type="text" value=""...

It is two stages 1. https://ebanking.cibeg.com/web/guest/home When you click the "LOG ON" LINK, you get the main login page where I need to automate Actually I need to automate both steps starting with URL in 1

Your last snippet shows that you can answer my "simple" question: If I have a log in page that has two input boxes and a submit button. WITHOUT digging into the source code, can I debug.print the variable name that I have to set by VBA (later) for both username/password. In my HTML example...

Thanks Narayan.... One quick question: Is there an easy way to retrieve the element name that I am interested in. An Example: In the HTML page I am interested in there are input box for user name. In order for me to fill it with my user name using VBA, I need to know the variable name so I...

Narayan... Can you please fix these links for me http://chandoo.org/forums/topic/macros-web-query-huge-headache-can-anyone-help-me http://chandoo.org/forums/topic/get-reg-nos-from-a-website http://chandoo.org/forums/topic/specific-data-and-html-beyond-excels-capabilities These three links...

Thank you for the links...These will be "tomorrow"'s project !!! My issue today is to go over the hurdle of logging in to secure Web page The log in page has two boxes Username and Password And a submit button the html code behind them ( only the relevant parts) <div class="cr2tooltip">...

I checked the link , and this will be my today's project to modify it to get what I want. One issue which I need help with , the site I am getting data from is User/Password protected. I have two questions: 1. How to use VBA to pass that login page to the page I am interesting in ( actually...

Of course it helped me ......moving away from RE. How do I parse this string or "1000 USD" and "62785 INR" Simple pointers will let me head in the right direction.

The string text is Huge (HTML web page). The string starts with unique ID and end with </span) Here is an example <div id=currency_converter_result>1000 USD = <span class=bld>62785 INR</span> I need to build a function with 3 parameters ( str , start, end) start="...

Thanks....Clear and to the point....

All I have to do is Rows("19:23").Delete In trying to answer Debrai..... I am copying FORMATED cells from another sheet. These cells had background color When I tried to clear the CONTENT, the BG color REMAINED in the cells !!! So, I used delete Rows to get rid of the BG color Rows. Stepping...

Rows("19:23").Select Selection.Delete Shift:=xlUp Selection.Clear By not working I mean the rows 19-23 are Still selected !!! If I add Range("A1").select The selection goes away. i.e. cleared

I love you Guys and Gals...Having you around make it really fun to work with this highly created tool.:)

I am getting the "main course" ...... Thank you for taking the time to help..:)

Given Reference Date rDate Given Now Date nDate TODAY() Given Number of days nDays IF(AND(rDate>=nDate , rDate<=nDate + nDays , rDate<>"")),"GREEN","RED") I get GREEN Only when rDate is between Now and (Now + nDays) IF rDate is Blank I get RED. Can I eat the soup ????? :oops:

I need to BG a cell based on it's value IF A,B or C it is green IF D,E,F it is Blue etc So, once I past a value in a cell I need to call a function to evaluate it then give it the proper BG color.

Selection.value = "=TODAY()" Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues There must be a better way to "freeze" TODAY().......

Here what I did so far.....(one Macro included)

I have x number of worksheets, representing x number of projects. each project has a number of tasks ( same tasks for all projects). For each project each task has a planned number of days per task. The "Planned dates" can be easily calculated for each project. A project starts when User Input...

This is comforting, you are arguing, hence I am not an idiot. But I am when it comes to using slicer...Never used it ....Can you give a hand

The table consists of Date/amount/type I have a hidden column in the table that does calculated field ( I do not want the user to see it). Now I want create a pivot table Row Date Columns Type. Good so far. I need to filter based on the hidden column !!!!! This is my first question. Can I...