Re: $$Excel-Macros$$ Cell referencing by formula

2010-02-19 Thread ankur
may be there is some cell reference problem attach ur file Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 18, 2010 at 12:19 AM, Maitre Bart wrote: > Hi, > > I have some source data in one sheet (Calculations

Re: $$Excel-Macros$$ Variable Formula Reference

2010-02-19 Thread ankur
hi u can use $ sign in ur formula like $a$2 or $a2 or a$2 this will help u if not plz attach ur file Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 18, 2010 at 1:30 AM, Branden Durst wrote: > Okay, so I am

Re: $$Excel-Macros$$ Inventory

2010-02-19 Thread ankur
there are numerous format of payroll and inventory can plz be more specific to ur requirement Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 18, 2010 at 7:18 AM, Azmath Shariff wrote: > May i know where you

Re: $$Excel-Macros$$ VBA Macros Code examples : ASCII code converter : Column Number to Alphabetic...

2010-02-19 Thread ankur
thanks sir Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Feb 18, 2010 at 6:32 PM, Ayush Jain wrote: > Ayush Jain has sent you a link to a blog: > > Dear members, An ASCII converter function for quick reference.

Re: $$Excel-Macros$$ how to crack Excel VBA password

2010-02-19 Thread ankur
plz send ur file Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 19, 2010 at 7:54 PM, sunil sasidharan wrote: > Hi All, > > I need to edit an excel macro file but the VBA coing is protected and nobody > is aw

Re: $$Excel-Macros$$ formula for showing multiple of a no.

2010-02-19 Thread ankur
hi sastry i think ur query has been solved by paul , for any more clarification u can post ur msg Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Feb 20, 2010 at 12:27 AM, Paul Schreiner wrote: > First of all, y

Re: $$Excel-Macros$$ Excel Learning

2010-02-19 Thread ankur
our group file section has very good collection of books check there Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Feb 20, 2010 at 9:51 AM, ankur wrote: > hi rahul >  a book in pdf format "excel 203 bible" or"

Re: $$Excel-Macros$$ Re: how to crack Excel VBA password

2010-02-19 Thread ankur
send ur file Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Sat, Feb 20, 2010 at 5:16 AM, JsinSk wrote: > Post the file here and someone will crack it for you. > > On Feb 19, 9:24 am, sunil sasidharan > wrote: >> *H

$$Excel-Macros$$ Re: how to crack Excel VBA password

2010-02-19 Thread JsinSk
Post the file here and someone will crack it for you. On Feb 19, 9:24 am, sunil sasidharan wrote: > *Hi All,* > ** > *I need to edit an excel macro file but the VBA coing is protected and > nobody is aware of the password.* > ** > *Could you please help me on how do i crack the excel password or

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-19 Thread ankur
good one Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Mon, Feb 15, 2010 at 1:53 PM, RAHUL SUREKA wrote: > hiii >   Please Reply me how to use the excel file for windows media player and it >

Re: $$Excel-Macros$$ Excel Learning

2010-02-19 Thread ankur
hi rahul a book in pdf format "excel 203 bible" or" excel 2007 bible" will solve ur problems search on google Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Tue, Feb 16, 2010 at 8:46 AM, Venkatesh Narla wrote: >

Re: $$Excel-Macros$$ Urgent relate to life of some

2010-02-19 Thread ankur
hi naveen thnks for information Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Feb 19, 2010 at 7:09 PM, Naveen Sharma wrote: > Hi  Group, > > HELP > > If you know anyone who has met with a fire accid

Re: $$Excel-Macros$$ formula for showing multiple of a no.

2010-02-19 Thread Paul Schreiner
First of all, you should check the "help" for the "or" function. It says: Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE and    The arguments must evaluate to logical values such as TRUE or FALSE, or in arrays or references that contain logical values. that

$$Excel-Macros$$ Excel Multiple Datatypes column query with ADO

2010-02-19 Thread yogananda muthaiah
Excel Multiple Datatypes column query with ADO I used ADO select statement on worksheet selecting a column which has numeric and character datatypes... unfortunately I am getting rows only for numeric data type, and character data values are skipped. Code connection string. With con .Provider = "

$$Excel-Macros$$ formula for showing multiple of a no.

2010-02-19 Thread Sastry
Hi Group, I am writing a simple formula for a compounding interest. Let me quickly take you through the example. Monthly Investment - Rs.2000 Yearly Interest - 10% (compounded twice a year) i.e., 5% every 6th month Tenor - 1 year Month Investment Interest Cls Bal (Col A) (ColB) (Col

Re: $$Excel-Macros$$ Worksheet Name as defined in master sheet

2010-02-19 Thread Paul Schreiner
this should do what you ask. Assuming: "mastersheet" is named "Master" Name for new sheet is in cell "B2" Option Explicit Sub NewSheet()     Dim NewSheetName, I, SheetExists, msg     Dim CurrentSheet     Application.ScreenUpdating = False     CurrentSheet = ActiveSheet.Name     NewSheetName = Thi

$$Excel-Macros$$ Urgent relate to life of some

2010-02-19 Thread Naveen Sharma
*Hi Group,* ** *HELP* ** *If you know anyone who has met with a fire accident or people who are born with problems / disabilities such as jointed ear, nose and mouth, please note they can avail free plastic surgery at Pasam Hospital, KODAIKANAL from March 23rd to 4th April 2010 by Germ

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

2010-02-19 Thread ashish koul
can you attch the file On Fri, Feb 19, 2010 at 6:28 PM, saroj.32006 wrote: > Dear Ashish, > > As per the e-mail exchange between u and Umesh, I am having a doubt. If we > want to consolidate a data which is as like in no. of sheets in a work book > with all employee details in sheets for 12

$$Excel-Macros$$ how to crack Excel VBA password

2010-02-19 Thread sunil sasidharan
*Hi All,* ** *I need to edit an excel macro file but the VBA coing is protected and nobody is aware of the password.* ** *Could you please help me on how do i crack the excel password or is there any free software available?* ** *Thanks in advance for your help Regards, Sunny * -- --

$$Excel-Macros$$ Worksheet Name as defined in master sheet

2010-02-19 Thread Manish Pansari
Dear Excel Masters, I need your help. I want to insert a new worksheet through macro and want to change that sheet name with pre-defined name in master sheet. Whatever name i defined in mastersheet, macro will insert that worksheet in my work book. Further, if work book have that name worksheet t

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

2010-02-19 Thread saroj.32006
Dear Ashish, As per the e-mail exchange between u and Umesh, I am having a doubt. If we want to consolidate a data which is as like in no. of sheets in a work book with all employee details in sheets for 12 months. How can we consolidate the data basing on the Employee Id as an unique or primary k

$$Excel-Macros$$ excel vba code to change hyperlink default file path

2010-02-19 Thread Philip
When inserting a hyperlink the dialog box uses the path of the active workbook. I need code to change the hyperlink path to a sub folder and then insert a hyperlink with Application.Dialogs(xlDialogInsertHyperlink).Show, with that subfolder active. -- -

RE: $$Excel-Macros$$ Rename the files

2010-02-19 Thread Chidurala, Shrinivas
Thanks a lot Ashish -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of ashish koul Sent: Friday, February 19, 2010 10:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rename the files check it now it has