Re: $$Excel-Macros$$ To Extract a text with Conditions

Thanks Kris, it works fine On Mon, Jan 2, 2012 at 7:09 AM, Kris wrote: > In that case my UDF would be > > *Dim dic As Object > Function FINALDEST(ByRef v) As String > > Dim x, i As Long > > If TypeOf v Is Range Then v = v.Value2 > > x = Split(v, "-") > > If dic Is Nothing The

Re: $$Excel-Macros$$ To Extract a text with Conditions

Hi Haseeb, Great, I could not expect a solution by formula for this. awesome! On Mon, Jan 2, 2012 at 5:45 AM, Haseeb Avarakkan wrote: > Hello Faisal & Evey one, > > This is what my understanding, > > *If any code repeats after a dest, just before this code consider as > final dest.* > >

Re: $$Excel-Macros$$ Happy Birth Day

Wish You very very Happy Birth day Noorain On Mon, Jan 2, 2012 at 11:26 PM, Aamir Shahzad wrote: > Happy Birth day Noorain > > > On Mon, Jan 2, 2012 at 11:06 PM, wrote: > >> Many many happy returns of the day Mr.Noorain... >> >> Have rocking year. >> >> Sujit >> Sent on my BlackBerry® from Vodaf

$$Excel-Macros$$ Re: Text manipulation

On Jan 2, 3:11 pm, Zeunasc wrote: > I need to compare the object-groups between two firewalls for > differences.  The raw data from the firewalls looks like this: > > object-group network ABCDEF >  network-object 1.1.1.0 255.255.248.0 >  network-object 2.2.2.0 255.255.254.0 > object-group networ

$$Excel-Macros$$ Re: Happy Birth Day

Happy Birthday Noorain and thanks to Rajan for this info.. God bless both of you and whatever is your dream you achieve that. Thanks & Regards, BS -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urge

$$Excel-Macros$$ Re: Text manipulation

Text manipulation is kind of difficult in VBA. I can be done. If you have to do this in Excel. I would look at the regular expression module. I would use a scripting tool like Python to preprocess and put into csv or Excel. Bill On Jan 2, 3:11 pm, Zeunasc wrote: > I need to compare the objec

Re: $$Excel-Macros$$ GTIN Calculator in Excel Formula and Excel Macro

Thanks Guillett, Yes this is easier.. we just need to append "00" in starting to make it 14 digit. ="00" & A1 & 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) * {3,1,3,1,3,1,3,1,3,1,3}), 10) On Jan 2, 6:27 pm, "dguillett1" wrote: > Would this be easier > =A1 & 10 - MOD( SUMPRODUCT

$$Excel-Macros$$ Text manipulation

I need to compare the object-groups between two firewalls for differences. The raw data from the firewalls looks like this: object-group network ABCDEF network-object 1.1.1.0 255.255.248.0 network-object 2.2.2.0 255.255.254.0 object-group network GHIJKL network-object host 3.3.3.3 network-obj

Re: $$Excel-Macros$$ Query from URL

Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Alberto Sent: Monday, January 02, 2012 8:32 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Query from URL Hi, I use VBA to retrieve wheather data. This work: With ActiveSheet.QueryTables.Add(Conn

Re: $$Excel-Macros$$ Filter

Dear Aamir, Please see attached sheet... -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Mon, Jan 2, 2012 at 11:09 PM, Aamir Shahzad wrot

$$Excel-Macros$$ Re: Query from URL

Ok now it works. I dont why, but it works :-) -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be an

Re: $$Excel-Macros$$ Happy Birth Day

Happy Birth day Noorain On Mon, Jan 2, 2012 at 11:06 PM, wrote: > Many many happy returns of the day Mr.Noorain... > > Have rocking year. > > Sujit > Sent on my BlackBerry® from Vodafone > -- > *From: * "Rajan_Verma" > *Sender: * excel-macros@googlegroups.com > *Date

Re: $$Excel-Macros$$ Happy Birth Day

Many many happy returns of the day Mr.Noorain... Have rocking year. Sujit Sent on my BlackBerry® from Vodafone -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Mon, 2 Jan 2012 20:22:29 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macro

Re: $$Excel-Macros$$ Happy Birth Day

Wish you many many Happy Returns of the Day. Have a wonderful life ahead. Regards, Harish On 2 January 2012 20:25, Maries wrote: > Wish you many many Happy Returns of the Day Noorain:) Enjoy :) > > > On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma wrote: > >> Hello Group, >> >> Today we have b

$$Excel-Macros$$ Filter

How to use the auto filter for only "Text". How to use the auto filter for only "Numbers" -- Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Co

$$Excel-Macros$$ Query from URL

Hi, I use VBA to retrieve wheather data. This work: With ActiveSheet.QueryTables.Add(Connection:= _ "URL;http://www.osmer.fvg.it/~www/IT/SYN/ TabellaStazioniUltimOra.php", _ But with the address below it retrieves nothing ( and no error message too). The same with http://weather.uwyo.ed

RE: $$Excel-Macros$$ JOB

Hi Satvik. Group is only sharing a Job.. You need to send your resume to the concern as mentioned in job details Thanks Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satvik Sent: Jan/Tue/2012 07:36 To: excel-macros@googlegroups.com Subject:

Re: $$Excel-Macros$$ Happy Birth Day

Hi Noorain, Many many happy returns of the day... God bless you & have a Rocking Day, Month and year. Regards, Kiran Sent on my BlackBerry® from Vodafone Thanks & Regards. Kiran -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Mon, 2 Jan 2012 20:22:29

RE: $$Excel-Macros$$ JOB

Hi Noorain, Please find attached my updated resume for your easy reference. Regards Santosh santoshkumar.subu...@gmail.com Date: Mon, 2 Jan 2012 15:47:13 +0530 Subject: $$Excel-Macros$$ JOB From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com The sender of this email is registered

$$Excel-Macros$$ How to export data from Excel to Access 2003

Hi team, I want a Small excel tool which should have option of export & improt data in Access & also has a sheet which contains a form with option of finding data from access database also if i want to edit that entry so i can edit it easily & so i can update the database correctly.. I want thi

$$Excel-Macros$$ Re: How to extract data from website to excel

The second one for XL 2003 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't p

$$Excel-Macros$$ Re: How to extract data from website to excel

Hi I can't give much help on this. But have a look Data > From Web (XL 2007). Data > Import External Data > New web query. Kris -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Happy Birth Day

Happy Birthday Noorain. On Jan 2, 2012 8:36 PM, "Kris" wrote: > Happy B'day Noorain ! > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Adv

Re: $$Excel-Macros$$ Happy Birth Day

Happy B'day Noorain ! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a

Re: $$Excel-Macros$$ Happy Birth Day

Hi, Noorain Sir a very Very Happy Birht Day. Thanks & Regards Anil Kumar 113784 On Mon, Jan 2, 2012 at 8:25 PM, Maries wrote: > Wish you many many Happy Returns of the Day Noorain:) Enjoy :) > > > On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma wrote: > >> Hello Group, >> >> Today we ha

Re: $$Excel-Macros$$ Happy Birth Day

Wish you many many Happy Returns of the Day Noorain:) Enjoy :) On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma wrote: > Hello Group, > > Today we have birthday of One of our Excel Champ, He has been recognised > Most Helpful member on this group many times. *Noorain *has a sound > knowledge of Ex

$$Excel-Macros$$ Happy Birth Day

Hello Group, Today we have birthday of One of our Excel Champ, He has been recognised Most Helpful member on this group many times. Noorain has a sound knowledge of Excel and happy to help other peoples . So after New year we have another party on 2nd January J. Lets Wish Noorain a very Very Happ

$$Excel-Macros$$ How to extract data from website to excel

Hi Team, Happy New Year I want a macro code or tool which can provide me the solution for my below problem In my Office I have in house web based server which is based on SQL... Now to login to that website we have to use usename & password ( i can not able to provide you the website name

Re: $$Excel-Macros$$ GTIN Calculator in Excel Formula and Excel Macro

Would this be easier =A1 & 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) * {3,1,3,1,3,1,3,1,3,1,3}), 10) Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Vishwamitra Mishra Sent: Monday, January 02, 2012 2:03 AM To: MS EXCEL AND VBA MACROS Subj

RE: $$Excel-Macros$$ Pulling data from Web

Hi This site is required Access Code , Can you provide ? Regards Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sunil Shastri Sent: Jan/Mon/2012 02:12 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Pulling data from Web Hell

RE: $$Excel-Macros$$ Please help...!!

Hi.. Please attach sample file with output what you want by Formula.. Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Satvik Sent: Jan/Mon/2012 09:33 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Please help..

RE: $$Excel-Macros$$ Number Stored text i need convert to number

Select the Data and Run this Code Sub Convert() selection.value=selection.value End sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Jan/Mon/2012 11:03 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Number Stor

RE: $$Excel-Macros$$ Number Stored text i need convert to number

You can use smart tag option to convert into date also,.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Jan/Mon/2012 09:39 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Number Stored text i need conver

Re: $$Excel-Macros$$ Please help...!!

Hi Satvik, use the below formula . =(today()-A1)/30.5 On Mon, Jan 2, 2012 at 9:32 PM, Satvik wrote: > Dear Excel Members, > > Please help me how to calculate the Tenurity of a agent. > > Regards, > Satvik > Sent from BlackBerry® on Airtel > > -- > FORUM RULES (934+ members already BANNED for v

$$Excel-Macros$$ Please help...!!

Dear Excel Members, Please help me how to calculate the Tenurity of a agent. Regards, Satvik Sent from BlackBerry® on Airtel -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

$$Excel-Macros$$ Pulling data from Web

Hello to all, and wish you all a happy new year 2012! I am new to this forum, I need help to extract data from webiste: https://cbec.nsdl.com/EST/AssesseeVerification.do I tried Web query but it not worked. *.iqy file:* WEB 1 https://cbec.nsdl.com/EST/AssesseeVerification.do?=q["ST Regn Number

$$Excel-Macros$$ GTIN Calculator in Excel Formula and Excel Macro

I have written a Formula and Macro to calculate all types of GTIN. If you want that workbook, kindly let me know. For more detail about the Formula and Macro kindly visit this link: http://www.learnexcelmacro.com/2011/11/gtin-calculator-in-excel/ -- FORUM RULES (934+ members already BANNED for v