Re: $$Excel-Macros$$ Numer To Text

[Ankit Agrawal]

Thank you sir for deteil knowledge but again same problem *how we can use
add-in? plz tell me *

**
Thnanks & Regards

Ankit


On Tue, Oct 5, 2010 at 8:30 AM, P.VIJAYKUMAR  wrote:

> Dear Ankit,
>
> There is no Direct formula to convert numbers into text.But there are some
> add-ins available in the websites. just google for text to numbers converter
> in excel add-in.
> Once you download the add-in to install the add-in  to excel go to the
> excel ribbon Button, the from there open excel options ,then select add-in
> from the avialble options. Excel will then display the add-ins which are
> already installed . It will also have a go button in the bottom for
> installing others in that it will show some available not installed
> add-ins,you can also install them along with our add-in..After clicking go
> button  then click the browse button then select the file which you
> downloaded to any disk or any place in your computer.Then click OK.Your
> add-in is installed.Once installed the file which is selected for
> installation should not be moved from the place it is downloaded.To many
> movements make the add-in not working.So when downloading only make sure
> that the file is saved in a place in which is is not disturbed further.Once
> installed you add-in shall work in every workbook. Make sure that an addin
> button is added to the Menu Bar.Hope this clarified your problem
>
>
> 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

Re: $$Excel-Macros$$ Numer To Text

[SUMIT VYAS]

Dear Vijay

Very Good explain by you


Thanks



On 10/5/10, P.VIJAYKUMAR  wrote:
>
> Dear Ankit,
>
>
> There is no Direct formula to convert numbers into text.But there are some
> add-ins available in the websites. just google for text to numbers converter
> in excel add-in.
> Once you download the add-in to install the add-in  to excel go to the
> excel ribbon Button, the from there open excel options ,then select add-in
> from the avialble options. Excel will then display the add-ins which are
> already installed . It will also have a go button in the bottom for
> installing others in that it will show some available not installed
> add-ins,you can also install them along with our add-in..After clicking go
> button  then click the browse button then select the file which you
> downloaded to any disk or any place in your computer.Then click OK.Your
> add-in is installed.Once installed the file which is selected for
> installation should not be moved from the place it is downloaded.To many
> movements make the add-in not working.So when downloading only make sure
> that the file is saved in a place in which is is not disturbed further.Once
> installed you add-in shall work in every workbook. Make sure that an addin
> button is added to the Menu Bar.Hope this clarified your problem
>
>
>
>
> 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

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[SUMIT VYAS]

Dear Mr. Ayush Jain

One Word Name You : - *Matrix  EXCEL *

Congratulations Ayush Jain. Really Very proud of you man.


Regards

Sumit Vyas


On 10/5/10, Aindril De  wrote:
>
> Hey Ayush!! You haven't responded to Neil's email
>
>
> Where is the Treat Man!!!?  [?][?]
>
>
> Cheers,
> Andy
>
>
> On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina 
> wrote:
>
>> Congratulations Ayush Jain. Really Very proud of you man.
>>
>> On 10/4/10, rajasekhar praharaju  wrote:
>> > hearty congratulations ayush, you really deserve it
>> >
>> > Infact you are good encyclopedia for us.
>> >
>> > Have a flamboyant future and delightful moments for ur future endeavors.
>> >
>> > Regards,
>> > Raj
>> >
>> > On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:
>> >
>> >> Dear Group,
>> >>
>> >> I am proud to announce that I am awarded Microsoft Most Valuable
>> >> Professional MVP on October 01, 2010 for providing technical expertise
>> >> in Excel technical communities for past one year.
>> >>
>> >>
>> >>
>> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>> >>
>> >> This is a prestigious award from Microsoft given every Quarter to the
>> >> people who share their deep knowledge, real-world experience, and
>> >> impartial, objective feedback to help people enhance the way they use
>> >> technology.
>> >>
>> >> My deep thanks to each group member for all your support and
>> >> contribution to this group.
>> >>
>> >> Best regards,
>> >> Ayush Jain
>> >> Microsoft MVP
>> >>
>> >> --
>> >>
>> >>
>> --
>> >> 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
>>
>>
>
> --
>
> --
> 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 htt

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[seema mba]

Hi Ayush!

You really deserve that title...

Regards,

Seema

On Tue, Oct 5, 2010 at 9:26 AM, Aindril De  wrote:

> Hey Ayush!! You haven't responded to Neil's email
>
> Where is the Treat Man!!!?  [?][?]
>
> Cheers,
> Andy
>
>
> On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina 
> wrote:
>
>> Congratulations Ayush Jain. Really Very proud of you man.
>>
>> On 10/4/10, rajasekhar praharaju  wrote:
>> > hearty congratulations ayush, you really deserve it
>> >
>> > Infact you are good encyclopedia for us.
>> >
>> > Have a flamboyant future and delightful moments for ur future endeavors.
>> >
>> > Regards,
>> > Raj
>> >
>> > On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:
>> >
>> >> Dear Group,
>> >>
>> >> I am proud to announce that I am awarded Microsoft Most Valuable
>> >> Professional MVP on October 01, 2010 for providing technical expertise
>> >> in Excel technical communities for past one year.
>> >>
>> >>
>> >>
>> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>> >>
>> >> This is a prestigious award from Microsoft given every Quarter to the
>> >> people who share their deep knowledge, real-world experience, and
>> >> impartial, objective feedback to help people enhance the way they use
>> >> technology.
>> >>
>> >> My deep thanks to each group member for all your support and
>> >> contribution to this group.
>> >>
>> >> Best regards,
>> >> Ayush Jain
>> >> Microsoft MVP
>> >>
>> >> --
>> >>
>> >>
>> --
>> >> 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
>>
>
>  --
>
> --
> 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://exceld

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[Aindril De]

Hey Ayush!! You haven't responded to Neil's email

Where is the Treat Man!!!?  [?][?]

Cheers,
Andy

On Mon, Oct 4, 2010 at 9:17 PM, krishna mummina wrote:

> Congratulations Ayush Jain. Really Very proud of you man.
>
> On 10/4/10, rajasekhar praharaju  wrote:
> > hearty congratulations ayush, you really deserve it
> >
> > Infact you are good encyclopedia for us.
> >
> > Have a flamboyant future and delightful moments for ur future endeavors.
> >
> > Regards,
> > Raj
> >
> > On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:
> >
> >> Dear Group,
> >>
> >> I am proud to announce that I am awarded Microsoft Most Valuable
> >> Professional MVP on October 01, 2010 for providing technical expertise
> >> in Excel technical communities for past one year.
> >>
> >>
> >>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
> >>
> >> This is a prestigious award from Microsoft given every Quarter to the
> >> people who share their deep knowledge, real-world experience, and
> >> impartial, objective feedback to help people enhance the way they use
> >> technology.
> >>
> >> My deep thanks to each group member for all your support and
> >> contribution to this group.
> >>
> >> Best regards,
> >> Ayush Jain
> >> Microsoft MVP
> >>
> >> --
> >>
> >>
> --
> >> 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
>

-- 
--
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
<<982.gif>>

Re: $$Excel-Macros$$ Numer To Text

[P.VIJAYKUMAR]

Dear Ankit,

There is no Direct formula to convert numbers into text.But there are some
add-ins available in the websites. just google for text to numbers converter
in excel add-in.
Once you download the add-in to install the add-in  to excel go to the excel
ribbon Button, the from there open excel options ,then select add-in from
the avialble options. Excel will then display the add-ins which are already
installed . It will also have a go button in the bottom for installing
others in that it will show some available not installed add-ins,you can
also install them along with our add-in..After clicking go button  then
click the browse button then select the file which you downloaded to any
disk or any place in your computer.Then click OK.Your add-in is
installed.Once installed the file which is selected for installation should
not be moved from the place it is downloaded.To many movements make the
add-in not working.So when downloading only make sure that the file is saved
in a place in which is is not disturbed further.Once installed you add-in
shall work in every workbook. Make sure that an addin button is added to the
Menu Bar.Hope this clarified your problem


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

Re: $$Excel-Macros$$ Help in sending the salary slip

[Ankit Agrawal]

But how

Thanks & regards

Ankit

On Mon, Oct 4, 2010 at 9:15 PM, krishna mummina wrote:

> You may use of macro.
> I am not sure about Password for the file, but You can send
> automatically to the Concerned person.
>
> --
>
> --
> 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$$ Importing data into excel

[Peter Konijn]

Hi,

It works, thanks a lot for your support.

I am still curious for the macro of Deepak Rai.



Regards Peter

2010/10/3 P.VIJAYKUMAR 

> Dear Peter,
>
> You can Import Data From Data Menu.In DATA Menu Go to Get External Data,
> then select Existing Connections,then you will get a dialog box,in that
> select browse for more then select the file you need to import, then press
> ok. Then you will get a query about what sheets of the workbook you need to
> import and where you need to import .Once you specify your requirements you
> can have your data imported according to your needs.I am Attaching the file
> in which i have impoterd the data of Data One sheet to Import_and_Calc.xlsx.
>
>
>
>
>
>
> 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

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

[Paul Schreiner]

The macros that I posted will have an issue because you cannot 
remove the "ThisWorkbook" module and import a new one.

What you MAY have to do is to put the macro into a "temporary" .xlsb or .xlsm 
file.
then, when the .xlsx file is opened, copy the sheet to the temporary file
and close the .xlsx file.
If you planned to save and overwrite the file, you can always include a saveas 
statement.


Paul

>
>From: sudheer lolla 
>To: excel-macros@googlegroups.com
>Sent: Mon, October 4, 2010 12:26:16 PM
>Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
>
>HI PAUL 
>
>
>IF I KEEP A PIECE OF CODE IN "This Workbook" SAY I KEEP IN "WORKBOOK_CHANGE" 
>THEN WHENEVER SHEET CHANGES THIS WILL BE INVOKED
>
>
>FOR THIS TO HAPPEN I NEED TO COPY A MODULE FROM .XLSB INTO THAT 
>WORKBOOK.THATS THE REQUIREMENT
>
>
>THIS .XLSX IS OPENED ON THE FLY...DONT KNOW WHICH XLSX USER WILL SELECT..SO 
>IAM 
>KEEPING A MASTER .XLSB IN "XLSTART" FOLDER IN MICROSOFT-->EXCEL-->XLSTART
>
>
>THIS MASTER .XLSB HAS A CODE THAT GENERATES A CUSTOM BUTTON.(THE CODE FOR THIS 
>IS KEPT IN "WORKBOOK_OPEN" EVENT IN .XLSB FILE)
>
>
>UPON CLICK OF THIS BUTTON..SOME VALIDATION ARE DONE ON THE SHEET(THE VBA CODE 
>FOR THESE VALIDATIONS ARE WRITTEN IN .XLSB FILE) AND ALSO CODE IN "THIS 
>WORKBOOK" MODULE OF .XLSB IS COPIED INTO "THIS WORKBOOK" OF .XLSX FILE. AND 
>ALL 
>MODULES IN .XLSB FILE ARE COPIED INTO .XLSX.
>
>
>FOR THIS WHOLE THING TO HAPPEN .
>
>
>1) .XLSB IS LOCKED
>2)WORKBOOK_OPEN OF .XLSB IS CREATING CUSTOM BUTTTON EVEN WHEN ITS LOCKD
>3)VALIDATIONS ARE DONE ACCORDINGLY
>4)BUT BUT THE MODULES ARE NOT GETTING COPIED INTO DESTINATION .XLSX FILE
>
>
>IF I REMOVE PROTECTION THIS WHOLE THING IS WORKING FINE
>BUT WITH PROTECTION AM HANGING AT POINT 4)...THAT IS MODULES NOT GETTING 
>COPIED..
>
>
>REGARDS
>SUDHEER
>
>
>===
>
>
>On Mon, Oct 4, 2010 at 9:20 PM, Paul Schreiner  wrote:
>
>Why do you want to copy the macros?
>>
>>I have one application that has over 37,000 lines of code (macros)
>>all in one protected workbook (both the workbook and VBA project are password 
>>protected)
>>I run the macros which open 15 other files and operate on each one.
>>At no time do I copy modules into these files.
>>
>>what is the requirement that makes it necessary to have the macro 
>>reside in the xlsx file?
>>
>>Paul
>>
>>
>>>
>>>From: sudheer lolla  
>>>
>>>To: MS EXCEL AND VBA MACROS 
>>>Sent: Mon, October 4, 2010 11:19:15 AM
>>>Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
>>>
>>>
>>>HI PAUL 
>>>
>>>
>>>THANKS FOR YOUR QUICK REPLY
>>>
>>>
>>>I DON'T WANT THE FILE TO BE SAVED (THATS NOT WITHIN SCOPE WHETHER USER SAVES 
>>>IT 
>>>OR NOT)WITH MACROS
>>>
>>>
>>>IN ORDER FOR THE EVENTS IN THE .XLSX TO BE RUN,IAM KEEPING THE MACROS IN 
>>>"This 
>>>Workbook" OF THE .XLSX FILE
>>>
>>>
>>>MACROS WONT GET COPIED WHEN PROTECTION IS ON (.XLSB IS PASSWORD PROTECTED).I 
>>>NEED TO UNLOCK THE XLSB COPY MACROS INTO .XLSX AND AGAIN LOCK THE .XLSB
>>>
>>>
>>>AND ONE MORE THING THIS OPERATION OF COPYING IS TO BE DONE FROM THE LOCKED 
>>XLSB.
>>>
>>>
>>>AM KEEPING THE CODE IN Workbook_Open AND UPON CLICK OF THE USER COPYING HAS 
>>>TO 
>>>BE DONE.
>>>
>>>
>>>
>>>
>>>BUT HOW CAN I COPY FROM LOCKED XLSB FILE INTO XLSX FILE
>>>=
>>>
>>>On Mon, Oct 4, 2010 at 3:10 PM, sudheer  wrote:
>>>
>>>Hi

IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS
PROBLEM
THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO
DO IT??

1..Running a particular code from .XLSB file
2..This .XLSB file is locked and i know the password also.
3..Code which is in this locked .XLSB file runs satisfactorily.
4.. When it comes to copying some modules from this locked .XLSB to
opened XLSX file.IT     FAILS

my understainding

Since some code is running from locked .XLSB file, this copying code
also needs to be run
BUT THIS IS NOT HAPPENING WHY??

I TRIED ALL THESE



Dim argPWD As String
argPWD = "tcs"
Dim VBP As VBProject
Set VBP = ActiveWorkbook.VBProject
MsgBox CStr(VBP.Protection)
If VBP.Protection <> vbext_pp_locked Then
Exit Sub
Else
Application.ScreenUpdating = True
SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True
End If


---


    With Application.VBE.ActiveVBProject

         .SendKeys "lolla"
          .SendKeys "{ENTER}" '


          .VBE.CommandBars("Menu Bar").Controls("Tools") _
                      .Controls("VBAProject Properties...").Execute
          .SendKeys "^{TAB}"
          .SendKeys "{TAB}" & "loll

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

[sudheer lolla]

HI PAUL

IF I KEEP A PIECE OF CODE IN "This Workbook" SAY I KEEP IN "WORKBOOK_CHANGE"
THEN WHENEVER SHEET CHANGES THIS WILL BE INVOKED

FOR THIS TO HAPPEN I NEED TO COPY A MODULE FROM .XLSB INTO THAT
WORKBOOK.THATS THE REQUIREMENT

THIS .XLSX IS OPENED ON THE FLY...DONT KNOW WHICH XLSX USER WILL SELECT..SO
IAM KEEPING A MASTER .XLSB IN "XLSTART" FOLDER IN
MICROSOFT-->EXCEL-->XLSTART

THIS MASTER .XLSB HAS A CODE THAT GENERATES A CUSTOM BUTTON.(THE CODE FOR
THIS IS KEPT IN "WORKBOOK_OPEN" EVENT IN .XLSB FILE)

UPON CLICK OF THIS BUTTON..SOME VALIDATION ARE DONE ON THE SHEET(THE VBA
CODE FOR THESE VALIDATIONS ARE WRITTEN IN .XLSB FILE) AND ALSO CODE IN "THIS
WORKBOOK" MODULE OF .XLSB IS COPIED INTO "THIS WORKBOOK" OF .XLSX FILE. AND
ALL MODULES IN .XLSB FILE ARE COPIED INTO .XLSX.

FOR THIS WHOLE THING TO HAPPEN .

1) .XLSB IS LOCKED
2)WORKBOOK_OPEN OF .XLSB IS CREATING CUSTOM BUTTTON EVEN WHEN ITS LOCKD
3)VALIDATIONS ARE DONE ACCORDINGLY
4)BUT BUT THE MODULES ARE NOT GETTING COPIED INTO DESTINATION .XLSX FILE

IF I REMOVE PROTECTION THIS WHOLE THING IS WORKING FINE
BUT WITH PROTECTION AM HANGING AT POINT 4)...THAT IS MODULES NOT GETTING
COPIED..

REGARDS
SUDHEER

===

On Mon, Oct 4, 2010 at 9:20 PM, Paul Schreiner wrote:

> Why do you want to copy the macros?
>
> I have one application that has over 37,000 lines of code (macros)
> all in one protected workbook (both the workbook and VBA project are
> password protected)
> I run the macros which open 15 other files and operate on each one.
> At no time do I copy modules into these files.
>
> what is the requirement that makes it necessary to have the macro
> reside in the xlsx file?
>
> Paul
>
>
> *From:* sudheer lolla 
>
> *To:* MS EXCEL AND VBA MACROS 
> *Sent:* Mon, October 4, 2010 11:19:15 AM
> *Subject:* Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
>
> HI PAUL
>
> THANKS FOR YOUR QUICK REPLY
>
> I DON'T WANT THE FILE TO BE SAVED (THATS NOT WITHIN SCOPE WHETHER USER
> SAVES IT OR NOT)WITH MACROS
>
> IN ORDER FOR THE EVENTS IN THE .XLSX TO BE RUN,IAM KEEPING THE MACROS IN
> "This Workbook" OF THE .XLSX FILE
>
> MACROS WONT GET COPIED WHEN PROTECTION IS ON (.XLSB IS PASSWORD
> PROTECTED).I NEED TO UNLOCK THE XLSB COPY MACROS INTO .XLSX AND AGAIN LOCK
> THE .XLSB
>
> AND ONE MORE THING THIS OPERATION OF COPYING IS TO BE DONE FROM THE LOCKED
> XLSB.
>
> AM KEEPING THE CODE IN Workbook_Open AND UPON CLICK OF THE USER COPYING HAS
> TO BE DONE.
>
>
> BUT HOW CAN I COPY FROM LOCKED XLSB FILE INTO XLSX FILE
> =
> On Mon, Oct 4, 2010 at 3:10 PM, sudheer  wrote:
>
>> Hi
>>
>> IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS
>> PROBLEM
>> THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO
>> DO IT??
>>
>> 1..Running a particular code from .XLSB file
>> 2..This .XLSB file is locked and i know the password also.
>> 3..Code which is in this locked .XLSB file runs satisfactorily.
>> 4.. When it comes to copying some modules from this locked .XLSB to
>> opened XLSX file.IT  FAILS
>>
>> my understainding
>>
>> Since some code is running from locked .XLSB file, this copying code
>> also needs to be run
>> BUT THIS IS NOT HAPPENING WHY??
>>
>> I TRIED ALL THESE
>>
>> 
>>
>> Dim argPWD As String
>> argPWD = "tcs"
>> Dim VBP As VBProject
>> Set VBP = ActiveWorkbook.VBProject
>> MsgBox CStr(VBP.Protection)
>> If VBP.Protection <> vbext_pp_locked Then
>> Exit Sub
>> Else
>> Application.ScreenUpdating = True
>> SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True
>> End If
>>
>>
>>
>> ---
>>
>> With Application.VBE.ActiveVBProject
>>
>>  .SendKeys "lolla"
>>   .SendKeys "{ENTER}" '
>>
>>
>>   .VBE.CommandBars("Menu Bar").Controls("Tools") _
>>   .Controls("VBAProject Properties...").Execute
>>   .SendKeys "^{TAB}"
>>   .SendKeys "{TAB}" & "lolla"
>>   .SendKeys "{TAB}" & "lolla"
>>   .SendKeys "{TAB}"
>>   .SendKeys "{ENTER}"
>>
>> End With
>>
>>
>> 
>>
>> NONE OF THESE ARE WORKING
>>
>> PLEASE COMMUNITY MATES HELP ME
>>
>> --
>>
>> --
>> 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://exceld

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[krishna mummina]

Congratulations Ayush Jain. Really Very proud of you man.

On 10/4/10, rajasekhar praharaju  wrote:
> hearty congratulations ayush, you really deserve it
>
> Infact you are good encyclopedia for us.
>
> Have a flamboyant future and delightful moments for ur future endeavors.
>
> Regards,
> Raj
>
> On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:
>
>> Dear Group,
>>
>> I am proud to announce that I am awarded Microsoft Most Valuable
>> Professional MVP on October 01, 2010 for providing technical expertise
>> in Excel technical communities for past one year.
>>
>>
>> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>>
>> This is a prestigious award from Microsoft given every Quarter to the
>> people who share their deep knowledge, real-world experience, and
>> impartial, objective feedback to help people enhance the way they use
>> technology.
>>
>> My deep thanks to each group member for all your support and
>> contribution to this group.
>>
>> Best regards,
>> Ayush Jain
>> Microsoft MVP
>>
>> --
>>
>> --
>> 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$$ Help in sending the salary slip

[krishna mummina]

You may use of macro.
I am not sure about Password for the file, but You can send
automatically to the Concerned person.

-- 
--
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$$ COPY MODULES FORM LOCKED .XLSB FILE

[Paul Schreiner]

Why do you want to copy the macros?

I have one application that has over 37,000 lines of code (macros)
all in one protected workbook (both the workbook and VBA project are password 
protected)
I run the macros which open 15 other files and operate on each one.
At no time do I copy modules into these files.

what is the requirement that makes it necessary to have the macro 
reside in the xlsx file?

Paul


>
>From: sudheer lolla 
>To: MS EXCEL AND VBA MACROS 
>Sent: Mon, October 4, 2010 11:19:15 AM
>Subject: Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
>
>HI PAUL 
>
>
>THANKS FOR YOUR QUICK REPLY
>
>
>I DON'T WANT THE FILE TO BE SAVED (THATS NOT WITHIN SCOPE WHETHER USER SAVES 
>IT 
>OR NOT)WITH MACROS
>
>
>IN ORDER FOR THE EVENTS IN THE .XLSX TO BE RUN,IAM KEEPING THE MACROS IN "This 
>Workbook" OF THE .XLSX FILE
>
>
>MACROS WONT GET COPIED WHEN PROTECTION IS ON (.XLSB IS PASSWORD PROTECTED).I 
>NEED TO UNLOCK THE XLSB COPY MACROS INTO .XLSX AND AGAIN LOCK THE .XLSB
>
>
>AND ONE MORE THING THIS OPERATION OF COPYING IS TO BE DONE FROM THE LOCKED 
XLSB.
>
>
>AM KEEPING THE CODE IN Workbook_Open AND UPON CLICK OF THE USER COPYING HAS TO 
>BE DONE.
>
>
>
>
>BUT HOW CAN I COPY FROM LOCKED XLSB FILE INTO XLSX FILE
>=
>
>On Mon, Oct 4, 2010 at 3:10 PM, sudheer  wrote:
>
>Hi
>>
>>IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS
>>PROBLEM
>>THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO
>>DO IT??
>>
>>1..Running a particular code from .XLSB file
>>2..This .XLSB file is locked and i know the password also.
>>3..Code which is in this locked .XLSB file runs satisfactorily.
>>4.. When it comes to copying some modules from this locked .XLSB to
>>opened XLSX file.IT     FAILS
>>
>>my understainding
>>
>>Since some code is running from locked .XLSB file, this copying code
>>also needs to be run
>>BUT THIS IS NOT HAPPENING WHY??
>>
>>I TRIED ALL THESE
>>
>>
>>
>>Dim argPWD As String
>>argPWD = "tcs"
>>Dim VBP As VBProject
>>Set VBP = ActiveWorkbook.VBProject
>>MsgBox CStr(VBP.Protection)
>>If VBP.Protection <> vbext_pp_locked Then
>>Exit Sub
>>Else
>>Application.ScreenUpdating = True
>>SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True
>>End If
>>
>>
>>---
>>
>>
>>    With Application.VBE.ActiveVBProject
>>
>>         .SendKeys "lolla"
>>          .SendKeys "{ENTER}" '
>>
>>
>>          .VBE.CommandBars("Menu Bar").Controls("Tools") _
>>                      .Controls("VBAProject Properties...").Execute
>>          .SendKeys "^{TAB}"
>>          .SendKeys "{TAB}" & "lolla"
>>          .SendKeys "{TAB}" & "lolla"
>>          .SendKeys "{TAB}"
>>          .SendKeys "{ENTER}"
>>
>>    End With
>>
>>
>>
>>
>>NONE OF THESE ARE WORKING
>>
>>PLEASE COMMUNITY MATES HELP ME
>>
>>--
>>--
>>
>>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
>>
>
>
>-- 
>sudheer.L
>-- 
>--
>
>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.quic

Re: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

[sudheer lolla]

HI PAUL

THANKS FOR YOUR QUICK REPLY

I DON'T WANT THE FILE TO BE SAVED (THATS NOT WITHIN SCOPE WHETHER USER SAVES
IT OR NOT)WITH MACROS

IN ORDER FOR THE EVENTS IN THE .XLSX TO BE RUN,IAM KEEPING THE MACROS IN
"This Workbook" OF THE .XLSX FILE

MACROS WONT GET COPIED WHEN PROTECTION IS ON (.XLSB IS PASSWORD PROTECTED).I
NEED TO UNLOCK THE XLSB COPY MACROS INTO .XLSX AND AGAIN LOCK THE .XLSB

AND ONE MORE THING THIS OPERATION OF COPYING IS TO BE DONE FROM THE LOCKED
XLSB.

AM KEEPING THE CODE IN Workbook_Open AND UPON CLICK OF THE USER COPYING HAS
TO BE DONE.


BUT HOW CAN I COPY FROM LOCKED XLSB FILE INTO XLSX FILE
=
On Mon, Oct 4, 2010 at 3:10 PM, sudheer  wrote:

> Hi
>
> IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS
> PROBLEM
> THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO
> DO IT??
>
> 1..Running a particular code from .XLSB file
> 2..This .XLSB file is locked and i know the password also.
> 3..Code which is in this locked .XLSB file runs satisfactorily.
> 4.. When it comes to copying some modules from this locked .XLSB to
> opened XLSX file.IT FAILS
>
> my understainding
>
> Since some code is running from locked .XLSB file, this copying code
> also needs to be run
> BUT THIS IS NOT HAPPENING WHY??
>
> I TRIED ALL THESE
>
> 
>
> Dim argPWD As String
> argPWD = "tcs"
> Dim VBP As VBProject
> Set VBP = ActiveWorkbook.VBProject
> MsgBox CStr(VBP.Protection)
> If VBP.Protection <> vbext_pp_locked Then
> Exit Sub
> Else
> Application.ScreenUpdating = True
> SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True
> End If
>
>
>
> ---
>
> With Application.VBE.ActiveVBProject
>
>  .SendKeys "lolla"
>   .SendKeys "{ENTER}" '
>
>
>   .VBE.CommandBars("Menu Bar").Controls("Tools") _
>   .Controls("VBAProject Properties...").Execute
>   .SendKeys "^{TAB}"
>   .SendKeys "{TAB}" & "lolla"
>   .SendKeys "{TAB}" & "lolla"
>   .SendKeys "{TAB}"
>   .SendKeys "{ENTER}"
>
> End With
>
>
> 
>
> NONE OF THESE ARE WORKING
>
> PLEASE COMMUNITY MATES HELP ME
>
> --
>
> --
> 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
>



-- 
sudheer.L

-- 
--
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$$ Numer To Text

[Ankit Agrawal]

But sir how it add in to excel.

Thanks & Regards

On Mon, Oct 4, 2010 at 1:35 PM, Mahesh  wrote:

> Hi ankit,
>
> Attached herewith is the add in.
> hope this will solve the issue.
>
>   On Mon, Oct 4, 2010 at 12:04 PM, Ankit Agrawal <
> ankit.agrawal...@gmail.com> wrote:
>
>> Thank you sir but it happen in only one file if we want to def ult it
>> means in every excel sheet it implement automatically.
>>
>> Thanks & regards
>> Ankit
>>
>> On Mon, Oct 4, 2010 at 10:18 AM, C.G.Kumar wrote:
>>
>>>
>>> See http://support.microsoft.com/kb/213360
>>>
>>>
>>>  Hope it serve the purpose.
>>>
>>> On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal <
>>> ankit.agrawal...@gmail.com> wrote:
>>>
 Hello Sir,

 Plz tell me any formula that convert number to text like

 1500/-
 one thousand five hundered only

 Thanks & Regards,
 Ankit

 --

 --
 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,
>>>
>>> C.G.Kumar
>>>
>>>   --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> With Love,
> Mahesh Bisht
>
> --
>
> --
> 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

$$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE

[sudheer]

Hi

IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS
PROBLEM
THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO
DO IT??

1..Running a particular code from .XLSB file
2..This .XLSB file is locked and i know the password also.
3..Code which is in this locked .XLSB file runs satisfactorily.
4.. When it comes to copying some modules from this locked .XLSB to
opened XLSX file.IT FAILS

my understainding

Since some code is running from locked .XLSB file, this copying code
also needs to be run
BUT THIS IS NOT HAPPENING WHY??

I TRIED ALL THESE


Dim argPWD As String
argPWD = "tcs"
Dim VBP As VBProject
Set VBP = ActiveWorkbook.VBProject
MsgBox CStr(VBP.Protection)
If VBP.Protection <> vbext_pp_locked Then
Exit Sub
Else
Application.ScreenUpdating = True
SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True
End If


---

 With Application.VBE.ActiveVBProject

  .SendKeys "lolla"
   .SendKeys "{ENTER}" '


   .VBE.CommandBars("Menu Bar").Controls("Tools") _
   .Controls("VBAProject Properties...").Execute
   .SendKeys "^{TAB}"
   .SendKeys "{TAB}" & "lolla"
   .SendKeys "{TAB}" & "lolla"
   .SendKeys "{TAB}"
   .SendKeys "{ENTER}"

 End With



NONE OF THESE ARE WORKING

PLEASE COMMUNITY MATES HELP ME

-- 
--
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$$ save as cell A1 to to a specific drive - BUT excel then closes - why ?

[Paul Schreiner]

BTW:
putting this code in a BeforeSave macro will cause 
the file to save itself TWICE.

(I'm surprised it doesn't get stuck in a loop)
Because:
BeforeSave means:  "Do this before saving the file".
Then: in your macro, you're saving the file!
so it does it once WITHIN the macro, and once after the macro exits.

Not a problem with a small file, bit if it's large, it will take a while.

put a breakpoint at the end and watch the file date if you don't believe me.

To keep this from happening, anywhere within the macro, put:

cancel = true

Paul



- Original Message 
> From: Johnnyboy5 
> To: MS EXCEL AND VBA MACROS 
> Sent: Sun, October 3, 2010 4:39:40 PM
> Subject: Re: $$Excel-Macros$$ save as cell A1 to to a specific drive - BUT 
>excel then closes - why ?
> 
> Thanks - nice one.
> 
> Johnny
> 
> On 3 Oct, 04:27, siti Vi  wrote:
> >    Dim myPath As String, ThisFile As String
> >    myPath = "H:\Temp\"
> >    ThisFile = myPath & Range("A1").Value
> >    Application.DisplayAlerts = False
> >    ActiveWorkbook.SaveAs Filename:=ThisFile
> >    Application.DisplayAlerts = True
> >
> > On Sat, Oct 2, 2010 at 6:34 PM, Johnnyboy5 
> > wrote:
> >
> >
> >
> > > Hi
> > > When I use the macro below  it does save the file as per cell A1 and
> > > it does save it to the chosen drive.   But it then closes Excel.
> >
> > > On checking the file location it is saved there.
> > > Any ideas what’s wrong.
> > > Thanks
> > > John
> >
> > > Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel
> > As Boolean)
> > >    Dim FileSaveName
> > >    ChDrive "H"
> > >    ChDir "H:\Temp"
> > >    ThisFile = Range("A1").Value
> > >    ActiveWorkbook.SaveAs Filename:=ThisFile
> > > End Sub
> 
> -- 
>--
>-
> 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$$ Ayush Jain – Microsoft MVP 20 10

[rajasekhar praharaju]

hearty congratulations ayush, you really deserve it

Infact you are good encyclopedia for us.

Have a flamboyant future and delightful moments for ur future endeavors.

Regards,
Raj

On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> 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

$$Excel-Macros$$ Help in sending the salary slip

[Ankit Agrawal]

Hello Sir,

I have a problem related to mail through excel. basically I have to make
salary slip. and forward it to the employees. I manage the data into the
excel and do mail merge in MS word. now the problem is start, I have to make
saperately file for the each employee and have to send one by one.

Question

1- Is any way that we can make saperately file autometically and send to it
mail autometically to each employee.
2- is any way that every file haveing its own password and its password
would be employee DOB or any other key

I wish it has solution.

Thanks & regards
Ankit

-- 
--
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$$ Right click

[Paul Schreiner]

Is it in all excel files or just this one?
Do you have macros in the file?

If so, there could be a Worksheet_BeforeRightClick
or Workbook_SheetBeforeRightClick
event that includes a cancel=true line.

try creating a sub to  enable/disable events:

Public Sub Events_Enable()
    Application.EnableEvents = True
End Sub

Public Sub Events_Disable()
    Application.EnableEvents = False
End Sub

run the Events_Disable macro and try it again.

Paul

- Original Message 
> From: sivam 
> To: MS EXCEL AND VBA MACROS 
> Sent: Mon, October 4, 2010 12:54:00 AM
> Subject: $$Excel-Macros$$ Right click
> 
> Hi this is very simple question. But still i am getting problem with
> this one. Thats why i am posting this query. In my excel sheet right
> click button is not working. Right click button is working on the
> outside of excel. Only inside it is not working. While accessing
> through keyboards it is working. Can you give me any solution for this
> one.
> 
> -- 
>--
>-
> 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$$ COPY MODULES FORM LOCKED .XLSB FILE

[Paul Schreiner]

You say in 4.)that you're copying modujles to an .xlsx file...

You cannot SAVE macros in an .xlsx file!
Microsoft created the .xlsx file format specifically so that
it would be data/formulas only.  No macros.
In order to ATTEMPT to keep malicious code from being passed
to unsuspecting users!

There are other ways to copy modules from one file to another:
  
'
'This macro will export all "standard" modules to a folder
'
Public Sub ExportAllMacros()
    Dim vbaModule
    Dim VBComp, tmp, Fldr
    Set vbaModule = ActiveWorkbook.VBProject.VBComponents
    Fldr = "C:\temp\modules\"
    
    Application.StatusBar = "Exporting all Modules..."
    Application.EnableEvents = False
    For Each VBComp In vbaModule
    If VBComp.Type = 1 Then
    ActiveWorkbook.VBProject.VBComponents(VBComp.Name).Export (Fldr 
& VBComp.Name & ".bas")
    End If
    Next VBComp
    Application.EnableEvents = True
    Application.StatusBar = False
End Sub 
'
'This macro will import all module files in a folder into the currently active 
workbook
'
Public Sub ImportAllMacros()
    Dim File, Files, f, fso, Fldr
    Dim fndMacroflag
    Set fso = CreateObject("Scripting.FileSystemObject")
    fndMacroflag = True
    Fldr = "C:\temp\modules\"
    Set f = fso.getfolder(Fldr)
    Set Files = f.Files
    For Each File In Files
    If (InStr(1, File.Name, ".bas") > 0) Then
    ActiveWorkbook.VBProject.VBComponents.Import Filename:=File.Path
    fndMacroflag = False
    End If
    Next File
    If (fndMacroflag) Then
   MsgBox "Error in loading Modules."
   Exit Sub
    End If
End Sub  
'

You can modify the above macros to do a single module.
then, simply use:

Workbooks("Book2").Activate
to select the workbook you want to add the macros to.

However, even though the macro module will be copied to the new file,
if it is saved in .xlsx format, the macros will NOT be saved...

Paul

 


- Original Message 
> From: sudheer 
> To: MS EXCEL AND VBA MACROS 
> Sent: Mon, October 4, 2010 5:40:25 AM
> Subject: $$Excel-Macros$$ COPY MODULES FORM LOCKED .XLSB FILE
> 
> Hi
> 
> IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS
> PROBLEM
> THE STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO
> DO IT??
> 
> 1..Running a particular code from .XLSB file
> 2..This .XLSB file is locked and i know the password also.
> 3..Code which is in this locked .XLSB file runs satisfactorily.
> 4.. When it comes to copying some modules from this locked .XLSB to
> opened XLSX file.IT    FAILS
> 
> my understainding
> 
> Since some code is running from locked .XLSB file, this copying code
> also needs to be run
> BUT THIS IS NOT HAPPENING WHY??
> 
> I TRIED ALL THESE
>
>-
> 
> Dim argPWD As String
> argPWD = "tcs"
> Dim VBP As VBProject
> Set VBP = ActiveWorkbook.VBProject
> MsgBox CStr(VBP.Protection)
> If VBP.Protection <> vbext_pp_locked Then
> Exit Sub
> Else
> Application.ScreenUpdating = True
> SendKeys "%{F11}%TE" & argPWD & "~~%{F11}", True
> End If
> 
> 
>---
>-
> 
>     With Application.VBE.ActiveVBProject
> 
>           .SendKeys "lolla"
>           .SendKeys "{ENTER}" '
> 
> 
>           .VBE.CommandBars("Menu Bar").Controls("Tools") _
>                       .Controls("VBAProject Properties...").Execute
>           .SendKeys "^{TAB}"
>           .SendKeys "{TAB}" & "lolla"
>           .SendKeys "{TAB}" & "lolla"
>           .SendKeys "{TAB}"
>           .SendKeys "{ENTER}"
> 
>     End With
> 
>
>-
> 
> NONE OF THESE ARE WORKING
> 
> PLEASE COMMUNITY MATES HELP ME
> 
> -- 
>--
>-
> 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: Budget sheet

[anandydr]

Conditional formatting is what has been used here in your budget
sheet. Select the area which you want to format. With Excel 2007
onwards you can use Jim's method in case you use older version
Conditional format is an option under Format Menu. Somehow 2007 and
newer version have a lot more options than older ones.

Hope that helps,
Anand Kumar

On Oct 2, 9:26 pm, neil johnson  wrote:
> Dear Everyone,
>
> There is budget sheet . I need your help . In sheet Mention BT summary sheet
>  . There is symbol of ► like this . This symbol has three colors red ,
> yellow , green according the variance . Its symbol color should be change
> according to variance. If someone make report of budget , then tell me
> please how we do this.
>
> Thanks and Regards
>
>  budget1.xls
> 357KViewDownload

-- 
--
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$$ Ayush Jain – Microsoft MVP 20 10

[anandydr]

Congrats Ayush,

You quite well deserved...

Warm regards,
Anand Kumar.

On Oct 4, 9:43 am, Jai  wrote:
> U deserve this Friend.
>
> On Mon, Oct 4, 2010 at 9:35 AM, C.G.Kumar wrote:
>
>
>
> > Congratulation friend on reaching a milestone. Hope may more to come 
>
> >  On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:
>
> >> Dear Group,
>
> >> I am proud to announce that I am awarded Microsoft Most Valuable
> >> Professional MVP on October 01, 2010 for providing technical expertise
> >> in Excel technical communities for past one year.
>
> >>http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-a...
>
> >> This is a prestigious award from Microsoft given every Quarter to the
> >> people who share their deep knowledge, real-world experience, and
> >> impartial, objective feedback to help people enhance the way they use
> >> technology.
>
> >> My deep thanks to each group member for all your support and
> >> contribution to this group.
>
> >> Best regards,
> >> Ayush Jain
> >> Microsoft MVP
>
> >> --
>
> >> --
> >> 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 athttp://www.excel-macros.blogspot.com
> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> >> 5. Excel Tips and Tricks athttp://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&;...
>
> > --
> > Regards,
>
> > C.G.Kumar
>
> > --
>
> > --
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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&;...
>
> --
> Thanks For Mail.

-- 
--
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$$ Numer To Text

[Ankit Agrawal]

I have add it But How to use it.

thanks & regards,
ankit

On Mon, Oct 4, 2010 at 4:40 PM, Ankit Agrawal wrote:

> But sir how it add in to excel.
>
> Thanks & Regards
>
>   On Mon, Oct 4, 2010 at 1:35 PM, Mahesh  wrote:
>
>> Hi ankit,
>>
>> Attached herewith is the add in.
>> hope this will solve the issue.
>>
>>   On Mon, Oct 4, 2010 at 12:04 PM, Ankit Agrawal <
>> ankit.agrawal...@gmail.com> wrote:
>>
>>> Thank you sir but it happen in only one file if we want to def ult it
>>> means in every excel sheet it implement automatically.
>>>
>>> Thanks & regards
>>> Ankit
>>>
>>> On Mon, Oct 4, 2010 at 10:18 AM, C.G.Kumar 
>>> wrote:
>>>

 See http://support.microsoft.com/kb/213360


  Hope it serve the purpose.

 On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal <
 ankit.agrawal...@gmail.com> wrote:

> Hello Sir,
>
> Plz tell me any formula that convert number to text like
>
> 1500/-
> one thousand five hundered only
>
> Thanks & Regards,
> Ankit
>
> --
>
> --
> 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,

 C.G.Kumar

   --

 --
 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
>>>
>>
>>
>>
>> --
>> With Love,
>> Mahesh Bisht
>>
>> --
>>
>> --
>> 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

Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10

[Intelligent But Crazy]

Hi Ayush,

Congrates for this status. We all are very happy to listen this..


Regards
Pankaj k Pandey

On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> 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
>



-- 
Pankaj Pandey
Bhopal

-- 
--
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$$ COPY CODE FROM WORKBOOK THAT IS LOCKED

[sudheer lolla]

Hi
IAM IN URGENT NEED OF AN ADVISE THAT COULD HELP ME GET OUT OF THIS PROBLEMTHE 
STEP BY STEP THAT NEEDS TO BE DONE ARE GIVEN .ONLY THING IS HOW TO DO IT??
1..Running a particular code from .XLSB file 2..This .XLSB file is locked and i 
know the password also.3..Code which is in this locked .XLSB file runs 
satisfactorily.4.. When it comes to copying some modules from this locked .XLSB 
to opened XLSX file.IT     FAILS
my understainding
Since some code is running from locked .XLSB file, this copying code also needs 
to be runBUT THIS IS NOT HAPPENING WHY??
I TRIED ALL 
THESE
Dim argPWD As StringargPWD = "tcs"Dim VBP As VBProjectSet VBP = 
ActiveWorkbook.VBProjectMsgBox CStr(VBP.Protection)If VBP.Protection <> 
vbext_pp_locked ThenExit SubElseApplication.ScreenUpdating = TrueSendKeys 
"%{F11}%TE" & argPWD & "~~%{F11}", TrueEnd If

---
     With Application.VBE.ActiveVBProject                .SendKeys "lolla"      
     .SendKeys "{ENTER}" '
                   .VBE.CommandBars("Menu Bar").Controls("Tools") _             
          .Controls("VBAProject Properties...").Execute           .SendKeys 
"^{TAB}"           .SendKeys "{TAB}" & "lolla"           .SendKeys "{TAB}" & 
"lolla"           .SendKeys "{TAB}"           .SendKeys "{ENTER}"
     End With

NONE OF THESE ARE WORKING
PLEASE COMMUNITY MATES HELP ME


LOLLA SUDHEER

("Achievers never expose themselves,their achievements expose them")

-- 
--
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$$ Ayush Jain – Microsoft MVP 20 10

[Kal xcel]

Ayush,

>From the bottom of my heart I salute you.

Congratulation to you.

Feeling proud to became member of this group.

Thanks

Kalyan



On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> 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

$$Excel-Macros$$ Re: Ayush Jain – Microsoft MVP 20 10

[anandydr]

Congrats Ayush,

Beside congratulating you on your MVP status I would also like to know
how this status is awarded. Although I've been through the website but
still the process for nomination, time i.e. for how long a MVP has
been contributing, or number/quality of post has not been very clear.
Since you are an MVP now, I believe you would be the best person to
describe these.

Warm regards and congrats again,
Anand Kumar

On Oct 3, 3:17 pm, Ayush  wrote:
> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-a...
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP

-- 
--
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$$ Numer To Text

[Ankit Agrawal]

Thank you sir but it happen in only one file if we want to def ult it means
in every excel sheet it implement automatically.

Thanks & regards
Ankit

On Mon, Oct 4, 2010 at 10:18 AM, C.G.Kumar wrote:

>
> See http://support.microsoft.com/kb/213360
>
>
>  Hope it serve the purpose.
>
> On Mon, Oct 4, 2010 at 9:22 AM, Ankit Agrawal 
> wrote:
>
>> Hello Sir,
>>
>> Plz tell me any formula that convert number to text like
>>
>> 1500/-
>> one thousand five hundered only
>>
>> Thanks & Regards,
>> Ankit
>>
>> --
>>
>> --
>> 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,
>
> C.G.Kumar
>
>   --
>
> --
> 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