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
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
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
Hi Satvik,
use the below formula .
=(today()-A1)/30.5
On Mon, Jan 2, 2012 at 9:32 PM, Satvik satvik...@gmail.com 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
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
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
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
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
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
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
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
Wish you many many Happy Returns of the Day Noorain:) Enjoy :)
On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
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
Hi,
Noorain Sir a very Very Happy Birht Day.
Thanks Regards
Anil Kumar
113784
On Mon, Jan 2, 2012 at 8:25 PM, Maries talk2mar...@gmail.com wrote:
Wish you many many Happy Returns of the Day Noorain:) Enjoy :)
On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
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
Happy Birthday Noorain.
On Jan 2, 2012 8:36 PM, Kris krishnak...@gmail.com 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,
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
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
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 this
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 rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date:
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
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
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, Code
Wish you many many Happy Returns of the Day.
Have a wonderful life ahead.
Regards,
Harish
On 2 January 2012 20:25, Maries talk2mar...@gmail.com wrote:
Wish you many many Happy Returns of the Day Noorain:) Enjoy :)
On Mon, Jan 2, 2012 at 6:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Many many happy returns of the day Mr.Noorain...
Have rocking year.
Sujit
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 2 Jan 2012 20:22:29
To: excel-macros@googlegroups.com
Reply-To:
Happy Birth day Noorain
On Mon, Jan 2, 2012 at 11:06 PM, suji...@gmail.com wrote:
Many many happy returns of the day Mr.Noorain...
Have rocking year.
Sujit
Sent on my BlackBerry® from Vodafone
--
*From: * Rajan_Verma rajanverma1...@gmail.com
*Sender: *
Dear Aamir,
Please see attached sheet...
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Mon, Jan 2, 2012 at 11:09 PM, Aamir Shahzad
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
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
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 dguille...@gmail.com wrote:
Would this be easier
=A1 10 - MOD(
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 timothy.ry...@gmail.com wrote:
I
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,
On Jan 2, 3:11 pm, Zeunasc timothy.ry...@gmail.com 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
Wish You very very Happy Birth day Noorain
On Mon, Jan 2, 2012 at 11:26 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Happy Birth day Noorain
On Mon, Jan 2, 2012 at 11:06 PM, suji...@gmail.com wrote:
Many many happy returns of the day Mr.Noorain...
Have rocking year.
Sujit
Sent on
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 haseeb.avarak...@gmail.com
wrote:
Hello Faisal Evey one,
This is what my understanding,
*If any code repeats after a dest, just before this code consider
Thanks Kris, it works fine
On Mon, Jan 2, 2012 at 7:09 AM, Kris krishnak...@gmail.com 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
35 matches
Mail list logo