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

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 th

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

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 th

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

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, > An

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

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:

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

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 congratulation

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

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

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

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

Re: $$Excel-Macros$$ Importing data into excel

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 t

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

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

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 WIL

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

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. > > Reg

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

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 :

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

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 the

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 I

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

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

$$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 .XLS

Re: $$Excel-Macros$$ save as cell A1 to to a specific drive - BUT excel then closes - why ?

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

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

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 aw

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

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 on

Re: $$Excel-Macros$$ Right click

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.EnableE

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

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! Ther

$$Excel-Macros$$ Re: Budget sheet

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

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

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:4

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

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

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

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 ex

$$Excel-Macros$$ COPY CODE FROM WORKBOOK THAT IS LOCKED

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

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

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 Octobe

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

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. Sin

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

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