date:20101112

$$Excel-Macros$$ Excel Utilities

2010-11-12 Thread Nikhil Shah

Deal All Members,

http://www.powerutilsnet.com/default.htm

Pl go to above mentioned  web site and download Powerful utilities for excel
..it is Totally FREE..

Thanks
Nikhil Shah..

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Requesting help to generate progress reports in Excel ...

2010-11-12 Thread Srinivasan Ethirajalu

sample data pks

On Sat, Nov 13, 2010 at 2:08 AM, Greg  wrote:

> Hi,
>
> I am a newbie to Excel and think I have a simple request but do not
> know how to get started. I would like to request help in generating
> progress reports for team mates on my "in house league" 8-ball pool
> team. I have been keeping a tally for the past 9 weeks of each persons
> wins and losses.
>
> I want a pie chart to illustrate their contribution to the team for
> the past 9 weeks. For example, I would like to see a percentage based
> on the total number of wins for each person. This percentage is
> displayed as percent/piece of the pie.
>
> Next, I would like to show a bar graph or line chart (like the stock
> market charts) for each individual illustrating their win/loss records
> from week 1 up through week 9.
>
> BTW, please include instructions on how best to enter my data in the
> Excel spreadsheet. I'm told this may need a pivot table but I know
> nothing about how to create them.
>
> Thanks in advance for any assistance you can provide.
>
> Kind regards,
> Greg
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Srinivasan Ethirajalu,
+919840544295

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Auto Number Template

2010-11-12 Thread enquirer

I have now created a working Returns Order Template and an add in that
that creates a new order when I press ctrl.r, which auto numbers and
auto dates. What I would now like to achieve now, is 1) create a
shortcut from Windows Desktop that opens Excel and ctrl.r.
automatically and 2) create a button on the template that can be
clicked, to print the completed form asking if 1 or 2 copies required,
and at the same time, auto saving the form to a specific location,
with a filename the same as the autonumber in cell G5.
Many thanks for any replies.
Regards enquirer.

On Nov 11, 10:22 pm, enquirer  wrote:
> I wish to create an auto number Returns Order template.
> I've never used VBA or MACROS in Excel before although I did do some
> basic stuff with MS Basic back in the DOS days.
> I wish to create a template consisting of 10 fields. I would like for
> each time the template is opened, an auto generated sequential number
> in cell B1.   I would like the auto generated number to start 21,
> and when the template has been filled, a print button that when
> clicked, will print 2 copies of the completed form, and auto save to a
> specific location, the filename same as auto generated number. I would
> also like the date to be automatically entered into cell B2.  If this
> saved file is opened edited etc in the future, I need the auto number
> and date to not change.
> I've copied vba examples which say they will do what I want, but I
> must be doing something wrong, because I can't get any to work.  I've
> created template and I've "view code" and selected "workbook" and
> pasted following code, but nothing happens!
>
> Private Sub Workbook_Open()
>         Const DEFAULTSTART As Integer = 1
>         Const MYAPPLICATION As String = "Excel"
>         Const MYSECTION As String = "myInvoice"
>         Const MYKEY As String = "myInvoiceKey"
>         Const MYLOCATION As String = "A1"
>         Dim regValue As Long
>
>         With ThisWorkbook.Sheets(1).Range(MYLOCATION)
>             If .Text <> "" Then Exit Sub
>             regValue = GetSetting(MYAPPLICATION, MYSECTION, _
>                     MYKEY, DEFAULTSTART)
>             .Value = Format(date,"YY") & "-" &
> format(regValue,"0")
>             SaveSetting MYAPPLICATION, MYSECTION, MYKEY, regValue + 1
>         End With
>     End Sub
>
> Am I pasting in the wrong place?
> Can anybody help.  I've seen commercial options to achieve what I
> require, but I want to learn how to do it myself, as I have many other
> projects I could use this experience for.
> Regards enquirer

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Requesting help to generate progress reports in Excel ...

2010-11-12 Thread Greg

Hi,

I am a newbie to Excel and think I have a simple request but do not
know how to get started. I would like to request help in generating
progress reports for team mates on my "in house league" 8-ball pool
team. I have been keeping a tally for the past 9 weeks of each persons
wins and losses.

I want a pie chart to illustrate their contribution to the team for
the past 9 weeks. For example, I would like to see a percentage based
on the total number of wins for each person. This percentage is
displayed as percent/piece of the pie.

Next, I would like to show a bar graph or line chart (like the stock
market charts) for each individual illustrating their win/loss records
from week 1 up through week 9.

BTW, please include instructions on how best to enter my data in the
Excel spreadsheet. I'm told this may need a pivot table but I know
nothing about how to create them.

Thanks in advance for any assistance you can provide.

Kind regards,
Greg

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread Srinivasan Ethirajalu

=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") &
IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") &
IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check
the date(s)")

this will supress if  year/month/day = 0  in the expansion. like

A1 => 12/20/2010  (in MM/DD/)
A2 => 11/12/2010
*Result===> 1 Month(s) , 8 Day(s) Left  *


On Fri, Nov 12, 2010 at 9:53 PM, Srinivasan Ethirajalu <
srinivasan.ethiraj...@gmail.com> wrote:

> =IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") &
> IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") &
> IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check
> the date(s)")
>
>
>
> On Fri, Nov 12, 2010 at 4:19 PM, Jai  wrote:
>
>> THANKS A LOST EXPERTS
>>
>>
>>
>> On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR <
>> sajidmansooral...@gmail.com> wrote:
>>
>>> Very simple! Good
>>>
>>>
>>> On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Jai...

 Please see attachment..

 =TEXT(D5-D6,"YY ")&"YEAR,  "&TEXT((D5-D6),"mm")&" MONTH,
 "&TEXT((D5-D6),"dd")&"  DAYS"
 Thanks,
 Noorain
   On Thu, Nov 11, 2010 at 9:47 PM, Jai  wrote:

>   Dear  Groups
>
> First Cell
>
>  20/12/2011
>
>  Secound Cell
>
> 12/11/2010
>
>   Required Results
>
> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>
> DEAR GROUP MEMBER PLEASE HELP ME,
>
> I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL
>
>  Required Results
>
> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>
>   --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @
> http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
>
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



 --
 Thanks & regards,
 Noorain Ansari

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Srinivasan Ethirajalu,
> +919840544295
>



-- 
Srinivas

Re: $$Excel-Macros$$ What is the code to lock & unlock a file have protect password

2010-11-12 Thread Ajay Varshney

Sub Protect_the_workbook()
ActiveWorkbook.Password = "password"
ActiveWorkbook.WritePassword = "password"
End Sub



Sub Unprotect_the_workbook()
ActiveWorkbook.Password = ""
ActiveWorkbook.WritePassword = ""
End Sub


On Fri, Nov 12, 2010 at 8:00 PM, Rajesh K R wrote:

> Hi Experts
>
> i have a doubt about using macro code for locking and unlocking a file
> with a password
> pls help me
>
> Regards
>
> Rajesh
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread Srinivasan Ethirajalu

=IF(A1 > A2, IF(YEAR(A1)-YEAR(A2)>0,YEAR(A1)-YEAR(A2)&" Year(s), ","") &
IF(MONTH(A1) - MONTH(A2)>0,MONTH(A1) - MONTH(A2) & " Month(s) , ", "") &
IF(DAY(A1) - DAY(A2)>0,DAY(A1) - DAY(A2) & " Day(s) Left",""), "Please check
the date(s)")



On Fri, Nov 12, 2010 at 4:19 PM, Jai  wrote:

> THANKS A LOST EXPERTS
>
>
>
> On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR <
> sajidmansooral...@gmail.com> wrote:
>
>> Very simple! Good
>>
>>
>> On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Jai...
>>>
>>> Please see attachment..
>>>
>>> =TEXT(D5-D6,"YY ")&"YEAR,  "&TEXT((D5-D6),"mm")&" MONTH,
>>> "&TEXT((D5-D6),"dd")&"  DAYS"
>>> Thanks,
>>> Noorain
>>>   On Thu, Nov 11, 2010 at 9:47 PM, Jai  wrote:
>>>
   Dear  Groups

 First Cell

  20/12/2011

  Secound Cell

 12/11/2010

   Required Results

 1 YEAR ,1 MONTH ,8 DAYS LEFT

 DEAR GROUP MEMBER PLEASE HELP ME,

 I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL

  Required Results

 1 YEAR ,1 MONTH ,8 DAYS LEFT

   --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>>
>>>
>>> --
>>> Thanks & regards,
>>> Noorain Ansari
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Srinivasan Ethirajalu,
+919840544295

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843

$$Excel-Macros$$ What is the code to lock & unlock a file have protect password

2010-11-12 Thread Rajesh K R

Hi Experts

i have a doubt about using macro code for locking and unlocking a file
with a password
pls help me

Regards

Rajesh

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Thanks

2010-11-12 Thread ashish koul

check sheet 3 for macro solution
sheet 1 for text data

sheet 2 for numeric data



On Fri, Nov 12, 2010 at 9:38 AM, Manjunath C wrote:

> Thanks a lot Ashish koul,
>
> Is it possbile to get the answeres in vertical ones,
> 1.what will happen if lookup data is in alphabet ? (in this case all are
> numberic i.e 45,96,25)
> 2.can you explain me the formula, will be more usefull to apply in future
> 3.Do we have any macros to get like this kind of data? if yes, please
>
> Again, appreciate your help.
>
> Thanks
> Manjunath
>
> On Thu, Nov 11, 2010 at 8:29 PM, ashish koul wrote:
>
>> HI Manjunath
>>
>> check the attachment  next time when you will post any query  shoot a new
>> email...
>>
>>
>>
>>>   On Thu, Nov 11, 2010 at 6:34 PM, P.VIJAYKUMAR wrote:
>>>
  Dear All,

 Here are some of files which may be helpful to our friends.


 Regards,
 Vijaykumar


 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link

 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>>
>


-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


examples2.xlsm
Description: Binary data

Re: $$Excel-Macros$$ Required to Unprotect VBA password

2010-11-12 Thread amrahs k

Hi,

Thanks for your help.
Regards,
-Sharma
On Fri, Nov 12, 2010 at 1:45 PM, SUMIT VYAS  wrote:

> Dear
>
> See
>
> Regards
>
> Sumit
>
>
>
> On Fri, Nov 12, 2010 at 1:11 PM, amrahs k  wrote:
>
>> Hi,
>>
>> Kindly unprotect the attached workbook vba password. Since it is very
>> urgent.
>>
>> Thanks a ton,
>>
>> -Sharma
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread Jai

THANKS A LOST EXPERTS



On Fri, Nov 12, 2010 at 3:59 PM, SAJID MANSOOR
wrote:

> Very simple! Good
>
>
> On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI  > wrote:
>
>> Dear Jai...
>>
>> Please see attachment..
>>
>> =TEXT(D5-D6,"YY ")&"YEAR,  "&TEXT((D5-D6),"mm")&" MONTH,
>> "&TEXT((D5-D6),"dd")&"  DAYS"
>> Thanks,
>> Noorain
>>   On Thu, Nov 11, 2010 at 9:47 PM, Jai  wrote:
>>
>>>   Dear  Groups
>>>
>>> First Cell
>>>
>>>  20/12/2011
>>>
>>>  Secound Cell
>>>
>>> 12/11/2010
>>>
>>>   Required Results
>>>
>>> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>>>
>>> DEAR GROUP MEMBER PLEASE HELP ME,
>>>
>>> I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL
>>>
>>>  Required Results
>>>
>>> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>>>
>>>   --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>>
>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>>
>>
>>
>>
>> --
>> Thanks & regards,
>> Noorain Ansari
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Please help regard this question

2010-11-12 Thread SAJID MANSOOR

Very simple! Good

On Fri, Nov 12, 2010 at 11:49 AM, NOORAIN ANSARI
wrote:

> Dear Jai...
>
> Please see attachment..
>
> =TEXT(D5-D6,"YY ")&"YEAR,  "&TEXT((D5-D6),"mm")&" MONTH,
> "&TEXT((D5-D6),"dd")&"  DAYS"
> Thanks,
> Noorain
> On Thu, Nov 11, 2010 at 9:47 PM, Jai  wrote:
>
>>   Dear  Groups
>>
>> First Cell
>>
>>  20/12/2011
>>
>>  Secound Cell
>>
>> 12/11/2010
>>
>>   Required Results
>>
>> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>>
>> DEAR GROUP MEMBER PLEASE HELP ME,
>>
>> I WANT TO NEED THAT WHEN WE LESS FIRST CELL TO SECOUND CELL
>>
>>  Required Results
>>
>> 1 YEAR ,1 MONTH ,8 DAYS LEFT
>>
>>   --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ how to know the content of a text box of user form

2010-11-12 Thread Hiren Sheth

Thanks for the update. This what I also think. But I am not able to know its 
value. I have a userform1 which has a textbox1 where user enter some value. I 
would like to know what is the value. Below are the code.

Private Sub CommandButton1_Click()
Dim WSheet As Worksheet

For Each WSheet In Worksheets

If WSheet.ProtectContents = True Then
WSheet.Unprotect Password:=TextBox1.Text
Else
'WSheet.Protect Password:=TextBox1.Text, DrawingObjects:=True, 
Contents:=True, Scenarios:=True
WSheet.Cells.Locked = True
WSheet.Protect Password:=TextBox1.Text
End If
Next WSheet
Unload Me
End Sub

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On 
Behalf Of Deepak Rai
Sent: Thursday, November 11, 2010 10:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ how to know the content of a text box of user form

Hi Hiren,

Suppose I have a veriable called Fname now I have to get this variable's value 
from a Texbox in a user control. Lets take this Text Box name as Textbox1 now I 
will use
Fname = Textbox1.value to populate my Fname variable with the value present in 
the Text Box. Textbox1.value is the answer of your question. :)
Hope this example will help you.

Regards,
Deepak
On Thu, Nov 11, 2010 at 8:52 PM, Hiren Sheth 
mailto:hiren.sh...@viteos.com>> wrote:
Hi,

Please let me know how to obtain the content of a text box of user form?

Thanks
Hiren
This message is for the named person's use only. It may contain confidential, 
proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mis-transmission. If you 
receive this message in error, please immediately
delete it and all copies of it from your system, destroy any hard copies of it 
and notify the sender. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this message 
if you are not the intended recipient.
Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve the 
right to monitor all e-mail communications through
its networks. Any views expressed in this message are those of the individual 
sender, except where the message states otherwise and
the sender is authorized to state them to be the views of any such entity
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at 
http://www.excel-macros.blogspot.com
4. Learn VBA Macros at 
http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at 
http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts



--
Regards,
Deepak Rai

--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
This message is for the named person's use only. It may contain confidential, 
proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any mis-transmission. If you 
receive this message in error, please immediately
delete it and all copies of it from your system, destroy any hard copies of it 
and notify the sender. You must not, directly or
indirectly, use, disclose, distribute, print, or copy any part of this message 
if you are not the intended recipient.
Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve the 
right to monitor all e-mail communications through
its networks. Any views expressed in this message are those of the individual 
sender, except where the message states otherwise and
the sender is authorized to state them to be the views of any such entity

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldail

$$Excel-Macros$$ Re: Convert PDF files to RTF File.

2010-11-12 Thread RKM

Hi Friends,

Is there any one has any idea about to resolve the below request
through VBA or any other...

By R. K. Maariappan

On Nov 3, 5:20 pm, RKM  wrote:
> Hi Experts,
>
> Usually I will get some files for process in PDF format. But I could
> not do the regular process in the same format. So I must convert the
> PDF file toRTFfile. Please find the steps I do for this task.
>
> 1. Open the PDF File.
> 2. Copy the contents using Cntl+A key
> 3. Open a blank Document (Word doc).
> 4. Paste the copied contents.
> 5. Use the save as the document inRTFformat.
>
> This has to be done for each and every File I got. This will be easy
> if i got 5 - 10 files. But I may get N number of Incoming per day.
>
> The Help Required:
>
> Now I wish to know is there any code to execute the task via Macros.
> If so please let me know the code or any alternate for this task.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ VBA Code Required

2010-11-12 Thread harish chandru

Hi All,

Can anyone help me providing the code for sending an excel attachment to be
automatically updated in the Lotus notes in a Text format(Not as
a Pictorial image or bit map.

Thanks,
Harish

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ seqence no using vba macro

2010-11-12 Thread ashish koul

try this...


Sub numbering()

Dim c As Range
Dim j As Long
j = 1

For Each c In Selection
c.Value = j
j = j + 1
Next c
End Sub




On Fri, Nov 12, 2010 at 9:59 AM, renuka chari  wrote:

> hi experts good morning,
> thanks in advance
> i want to print in excel sheet cells to 1,2,3,4,5,6,.in the
> selected rang, can u help me any one vba code for that macro.
> thanking you for kind attention.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Excel Utilities

Re: $$Excel-Macros$$ Requesting help to generate progress reports in Excel ...

$$Excel-Macros$$ Re: Auto Number Template

$$Excel-Macros$$ Requesting help to generate progress reports in Excel ...

Re: $$Excel-Macros$$ Please help regard this question

Re: $$Excel-Macros$$ What is the code to lock & unlock a file have protect password

Re: $$Excel-Macros$$ Please help regard this question

$$Excel-Macros$$ What is the code to lock & unlock a file have protect password

$$Excel-Macros$$ Re: Thanks

Re: $$Excel-Macros$$ Required to Unprotect VBA password

Re: $$Excel-Macros$$ Please help regard this question

Re: $$Excel-Macros$$ Please help regard this question

RE: $$Excel-Macros$$ how to know the content of a text box of user form

$$Excel-Macros$$ Re: Convert PDF files to RTF File.

Re: $$Excel-Macros$$ VBA Code Required

Re: $$Excel-Macros$$ seqence no using vba macro

16 matches

Site Navigation

Mail list logo

Footer information