Re: $$Excel-Macros$$ Remove Duplicates

2014-07-14 Thread Shaik Waheed
Its working, Thank you Ashish for your help :) Thanks, Waheed On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Waheed, PFA sheet and its code is working on Column D only. Regards Ashish On 11 July 2014 20:58, Shaik Waheed waheedb...@gmail.com wrote:

Re: $$Excel-Macros$$ Add Control On button click on Page

2014-07-14 Thread Rupesh Patil
Hello Expert, Please help On Sun, Jul 13, 2014 at 3:44 PM, Rupesh Patil patil.rupesh1...@gmail.com wrote: Any suggestions Experts On 12-Jul-2014 11:33 AM, Rupesh Patil patil.rupesh1...@gmail.com wrote: ​Hello Expert, I need a help from you. I want ​to add textbox on page when each

Re: $$Excel-Macros$$ Filter but exlude bad results script help!

2014-07-14 Thread Anoop K Sharma
Here you go.. On Fri, Jul 11, 2014 at 10:04 PM, Matt Painter mattr11...@gmail.com wrote: I pull data from a site called NDRIN.com its nd's land data base that i work off. Now i have a script that filters the results when i searchwhich is great.. but these admins dont enter the stuff

Re: $$Excel-Macros$$ Remove Duplicates

2014-07-14 Thread Ashish Kumar
Hi Waheed, Welocme. Regards Ashish On 14 July 2014 14:08, Shaik Waheed waheedb...@gmail.com wrote: Its working, Thank you Ashish for your help :) Thanks, Waheed On Fri, Jul 11, 2014 at 9:51 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi Waheed, PFA sheet and its code is

$$Excel-Macros$$ Re: Multiple Web Page Extraction

2014-07-14 Thread Bill Q
A great first effort Pramod. I called it up a few times. I always get the same 3 first lines returned - then I get the following error from your code and it stops: wk.Cells(i, x).Value = TDelement.innertext Perhaps it has something to do with the amount of time that the site needs to load.

Re: $$Excel-Macros$$ Add Control On button click on Page

2014-07-14 Thread Paul Schreiner
I'm sorry, there just doesn't seem to be enough information to figure out what it is you want to do!   Are you saying you wish to add information to the worksheet when you hit the button? or are you wanting to create another set of text boxes on the userform?   If you're wanting to create new 

$$Excel-Macros$$ How to direct multiple hyperlink ?

2014-07-14 Thread Nitya
Dear Aii experts, Please help in my query!! Please find the attachment explained clearly. How to direct multiple hyperlink ? There are web hyperlink in left side: All the link contain table in website The table from website should pull down and copy and paste in MainCollectionSheet as shown

Re: $$Excel-Macros$$ How to direct multiple hyperlink ?

2014-07-14 Thread Victor Momoh
Hi Nitya, I have added a FOR-LOOP and tweaked the macro a little which allows you loop through all the table-hyperlinks in your link sheet and then performs the import Of course the macro can be tweaked.fine tuned but see if this works for you Maybe test with about 5 links first before going to

$$Excel-Macros$$ Urgent required Java/ Integration Architect - Seattle, WA

2014-07-14 Thread Gary .
*Please respond to gurjant.si...@damcosoft.com gurjant.si...@damcosoft.com* *Position: Java/ Integration ArchitectLocation: Seattle, WADuration: 6-12 Months, long term* Requirements/Skills: * Total 10+ yrs experience telecom billing domain knowledge * Deep functional

$$Excel-Macros$$ How to learn VBA or MACORS myself at home???

2014-07-14 Thread 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS
Dear All, Good day to you I am here with a small request, is there any way to learn basics of VBA , since am not good in VBA or MACROS Is there any books available to learn VBA myself at home ?? like how to use it ?? or what is formulas or syntax using for a conditions ?? please help me i

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

2014-07-14 Thread 'David Lanne' via MS EXCEL AND VBA MACROS
Slaying Excel Dragons by Mike Girvin is a good book. I still can't figure out all the language stuff. But what helped me was recording marcos doing simple stuff, (ex renaming sheets, sorting data, etc) then stepping into the marco and I could see what its doing, which helped down the line when

Re: $$Excel-Macros$$ How to learn VBA or MACORS myself at home???

2014-07-14 Thread XLS S
Dear Delin, Please try below link. http://www.excel-pratique.com/en/vba.php Its a very useful and simple . Enjoy Team XLS On Mon, Jul 14, 2014 at 10:56 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Dear All, Good day to you

$$Excel-Macros$$ Re: How to direct multiple hyperlink ?

2014-07-14 Thread Nitya
Dear Experts, Any update on this. Thanks. From: Nitya nityanandadole...@gmail.com Date: Mon, Jul 14, 2014 at 5:17 PM Subject: How to direct multiple hyperlink ? To: excel-macros@googlegroups.com Dear Aii experts, Please help in my query!! Please find the attachment explained clearly. How to

Re: $$Excel-Macros$$ Re: How to direct multiple hyperlink ?

2014-07-14 Thread Pramod Singh
Hi Nitya, Please find the Attached file. As per your requirement.. Hope This will fine for you. Warm Regards Pramod Bisht On Tue, Jul 15, 2014 at 9:23 AM, Nitya nityanandadole...@gmail.com wrote: Dear Experts, Any update on this. Thanks. From: Nitya nityanandadole...@gmail.com Date: