RE: $$Excel-Macros$$ Ie

2013-12-22 Thread Ravinder
Hi, For retrieving text form html tags you can use (innertext) and for getting html tag you can use innerhtml as highlighted below. set u_name = browser.document.getElementsByTagName("input") While a < u_name.Length If u_name(a).Type = "text" Then Shtml = u_name(a).innerhtml or Sh

$$Excel-Macros$$ Re: How to calculate interest in following scenario ?? plz help

2013-12-22 Thread khushal
Hie Experts.. The requirement is : If the amount is outstanding for 41 days then It should calculate interest for 1 day and not 41 days. Thanks for your concern. On Saturday, December 21, 2013 8:16:26 PM UTC+5:30, khushal wrote: > I need to calculate amount of interest receivable from ot

RE: $$Excel-Macros$$ Ie

2013-12-22 Thread B.N.Chethan Kumar
Hi. Please let me how to use HTML code in excel macro. I am trying to login into a tool and pull a report in PDF format. Regards Ck On Dec 21, 2013 12:46 AM, "B.N.Chethan Kumar" wrote: > Thanks. It worked. > On Dec 19, 2013 11:44 AM, "Ravinder" wrote: > >> Try this if looking for this.. actuall

Re: $$Excel-Macros$$ HOW DO I SAVE TABLE DESIGN DATA

2013-12-22 Thread xlstime
please elaborate . Enjoy Team XLS On Tue, Dec 17, 2013 at 3:23 PM, sridher sharma wrote: > how do I save a table? I have taken my data, created a table and then > tried to 'save as' but when I reopen it, it is back in the original > worksheet format. What am I missing?

Re: $$Excel-Macros$$ Chart Help

2013-12-22 Thread xlstime
i hope u need this . Enjoy Team XLS On Tue, Dec 17, 2013 at 4:02 PM, wrote: > Hi Team, > > I need your help to modify the attached chart in more attractive way. > Please help me to insert "Sewing Attrition % within the Blue box. and > simlar to other box also. > > P

Re: $$Excel-Macros$$ How to calculate interest in following scenario ?? plz help

2013-12-22 Thread xlstime
Hi Khushal, Need some clarity. it's day wise calculation or after 40days and also share the example with both condition due date archived and not archived . Enjoy Team XLS On Sat, Dec 21, 2013 at 8:16 PM, khushal wrote: > I need to calculate amount of interest rec

Re: $$Excel-Macros$$ Project ETA Calculation

2013-12-22 Thread xlstime
Hi Arul, Please share the example. so that we can easily execute the formula . Enjoy Team XLS On Sun, Dec 22, 2013 at 6:03 AM, Arulkumar wrote: > Hi All, > > Please help on below email. > > I need a formula or macro for ETA calculation. > > Regards, > Arul. > On Dec