Re: $$Excel-Macros$$ Sum on the basis of colour formula

Very good On Thu, Apr 11, 2013 at 4:00 PM, Abhishek Jain wrote: > Attached. > > > On Thu, Apr 11, 2013 at 3:20 PM, L.K. Modi wrote: > >> Dear All >> >> >> In the given sheet i want sum on the basis of colour , is there any >> formula to solve my problem >> >> >> regards >> L.K.Modi >> >> -

$$Excel-Macros$$ Visual Basic, Expert in VBA for MS Office(Mainly for excel) Requirement

Fwd::: Required Profile = *Skill set :* Visual Basic, Expert in VBA for MS Office(Mainly for excel), Good knowledge of Excel Macro Years of experience : 4-6 yrs Role : Developer Date of Joining : ASAP ** ** *Location:* Bangalore (Domestic Onsite) ** ** ** **

Re: $$Excel-Macros$$ EXCEL FILE CONTAINING IP ADDRESS

On 7/1/11, L.K. Modi wrote: > Dear Group Members > > > I need an excel file in wihch by running macro we can see our IP ADDRESS. > Please provide me that file by which we can know the IP address of our > System > > > Regards > LKModi > > -- > ---

Re: $$Excel-Macros$$ database concept - Reg

Dear Ravi, Please have a view on attached Sheet. On Tue, May 17, 2011 at 5:15 PM, Rajan_Verma wrote: > Make a Custom List for all names > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Tuesday, May 17, 2011 3:03

Re: $$Excel-Macros$$ Formula within VB code

'HOW TO RUN EXCEL FORMULA USING VBA' Option Explicit Sub Function_BY_VBA() In sheet2 Range c2 Formula will be placed Sheets("SHEET1").Range("C2").Select ''' ActiveCell.FormulaR1C1 ="YOUR EXCEL FORMULA" ActiveCell.FormulaR1C1 = "=IF(RC[-2]>=60,""A grade"",""B gra

Re: $$Excel-Macros$$ prevent copying xl files

Hello Rajesh, There is no foolproof method for this.Try to use run security macro before opening workbook. Try to do this.To avoid unauthorized use of your workbook. 1.Write the Machine name of Authorized person line by line in notepad 2.Save it with your desirables name 3.Check machine name before

Re: $$Excel-Macros$$ Make User Form

of the form & clicked "OK".. & > went to master sheet to check the the data. but could see it > > On Thu, May 27, 2010 at 1:35 PM, rf1234 rf1234 wrote: >> Accept the input from Vba Form To Sheet Says Master. >> And hide the sheet Master with password protectio

Re: $$Excel-Macros$$ Make User Form

Accept the input from Vba Form To Sheet Says Master. And hide the sheet Master with password protection... On Wed, May 26, 2010 at 2:06 PM, neil johnson wrote: > Hi Sir, > > I make user form in excel sheet. Please check it . I want to add more button > . when Agent enter the data . Data not show

Re: $$Excel-Macros$$ How to insert sheets name in cells

Hello Mahesh, So u have all files in a folder and u want macro to create the details... xls name date created...etc if it is ok,then let me know perhapes i can help you on this On Mon, May 24, 2010 at 3:43 PM, Mahesh wrote: > Dear All, > > I have around 200 xls files in a folder now i want

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

; >> On May 24, 9:58 am, kavita ahuja wrote: >> >> >> >> >> >> > There is job for VBA programmer with atleast 2 yrs of experience in WNS, >> > gurgaon. >> >> > Regards >> > Kavita >> >> > On Fri, May 21, 2010 at 1:15 PM

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

MS EXCEL AND VBA MACROS > Sent: Fri, May 21, 2010 9:38:56 AM > Subject: Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members > > Yes Shyam,  this is a great helpful for those who are looking Job on > VBA > and thanks for all moderators who are helping people a lot. > >

$$Excel-Macros$$ Post VBA Jobs for Our Group Members

Dear All, We are here in this beautiful group,where every one is giving the Helping Hand to Others. Really Appreciated,I want to add just little,Some persons will at very great position,they can help To Give More Efforts. Please post the job requirements,so that members of our group can be benefi

Re: $$Excel-Macros$$ sum/count the number of times a name has occured

Hello Dear, You can use countif in range,attached workbook has a sample formula. On Wed, May 12, 2010 at 1:30 AM, nyberg75 wrote: > Hi > > How can i sum/count the number of times a name has occured > > Example: > John > Bill > Gordon > Bill > Bill > Sara > Bill > John > > Result: > Bill = 4 tim

$$Excel-Macros$$ Excel Bug ?

Dear All, Last time 1 of my friend come to me and ask that he is using to search ? and want to replace it 0 just try it,in range a:a values are,i.e 1 1 1 1 1 1 ? ? 1 ? ? ? 1 1 ? Now when u will try to search ? and replace with 0,have a look what happen -- Thanks Regards Shyam Software Enginee

Re: $$Excel-Macros$$ Remove Password in Excel Sheet

Dear Sachin It is already discussed,have a look on previous mail. Password break On Tue, May 4, 2010 at 11:44 AM, Sachin Shukla wrote: > Dear All, > > > I have sheet which is password protected. I forget the password. > > Please suggest me how i open this file and remove the password. > > > Than

Re: $$Excel-Macros$$ Formula Guide Require !!

Hello Dear, Try the following link http://www.cpearson.com/excel/topic.aspx There is a details of all functions and formulas. On Mon, May 3, 2010 at 8:47 PM, D Kumar wrote: > Hi All, > > I am not a perfect in excel but i have a little bit knowledge of some > formulas, is anyone in group 

Re: $$Excel-Macros$$ How to Copy data from different Excel files into a single Excel Sheet in appended way?

Dear Paul Schreiner Your email are very Informative, I like your way to explain. :) On Fri, Apr 30, 2010 at 5:34 PM, rf1234 rf1234 wrote: > Hello Dear, > There are many macro available to import specific range. > I.E > It is possible to select all xls file in 1 folder,and it wi

Re: $$Excel-Macros$$ Form controls disappear when copying sheet

Dear ugoren When you have contorls on your sheet,You can't copy the controls in next sheet. It can be used when you are working with VBA Form. On Tue, Apr 27, 2010 at 8:08 PM, Uri Goren wrote: > Hi, > > I created a sheet in Excel 2007 and added a few buttons to it via the > form controls tool

Re: $$Excel-Macros$$ Help me in contitional formating

Dear Vinod, Have a look in attached Zipped,It will help you. Hope it Will Help On Tue, Apr 27, 2010 at 11:39 PM, vinod rao wrote: > Hello, > I want a conditional formating for the string found "to be done" in column F > and colour the entire row. > > Example > in cell F17 i found t

Re: $$Excel-Macros$$ $$Excel - Macros$$ - Need to Break the password of my VBA Code

Hello Dear, Please send mail with proper subject line and message.Here We are unable to understand your problem. we can help better when we know your problem. On Mon, Apr 26, 2010 at 10:44 AM, ram kumar.m wrote: > > > -- > Thanks and Regard > ramkumar.m > HAVE A NICE DAY FRNDS:) > > -- >

Re: $$Excel-Macros$$ SAS

Hello Dear, Following Is The Discription About Sas SAS Computing •SAS (software), an integrated software suite produced by SAS Institute Inc. •Secure Attention Sequence or secure attention key, a method to invoke a computer operating system's attention, usually signaling it to show the log on scre

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 20 Messages in 12 Topics

Hello Dear, Please let us know,which trading software you are using. We can help better,when we understand your problem. On Sat, Apr 24, 2010 at 10:16 PM, nitz gupta wrote: > Dear Friends, > > is there a way with which i can convert my excel file to interact with my > trading software

Re: $$Excel-Macros$$ Consolidating Unequal Lists

Hello Dear, Are you looking for dependent list,or you want shorting of data. Have a look on attached sheet,I hope it will fulfill your requirement. Hope it Will Help Happy To Help :) Prashant Tripathi On Wed, Apr 21, 2010 at 4:52 PM, royhamill wrote: > Hello, > I have 2 lists of dat

Re: $$Excel-Macros$$ MCA certification help

Dear Alok Following is the link For Ms Excel Master Certification. http://www.microsoft.com/learning/en/us/exam.aspx?ID=77-602&locale=en-us Hope it Will Help Happy to Help :) Prashant Tripathi On Thu, Apr 22, 2010 at 10:53 AM, rf1234 rf1234 wrote: > Dear alok > In my

Re: $$Excel-Macros$$ MCA certification help

Dear alok In my knowledge Microsoft not provide any MCA certification by microsoft Following is the list of certification... (1)MCTS:- Microsoft Certified Technology Specialist (MCTS) certifications enable professionals to target specific technologies and to distinguish themselves by demonstratin

Re: $$Excel-Macros$$ subtracting time

Dear Rahul Your suggestion is appreciable,But how can 1 know that other person is new and he/she wants fundamentals first. I think new member should ask for fundamental study material with introducing himself. On Mon, Apr 19, 2010 at 11:11 AM, lal rahul wrote: >> >>> Hi Group, >>> To

Re: $$Excel-Macros$$ HELP: Appending multiple sheet into one

the said macro(Invoice loader with > Sample Invoice.rar) ? > > Regds. > > On Thu, Apr 8, 2010 at 10:16 AM, rf1234 rf1234 wrote: >> >> Hello Dear >> Attached is the macro and sample xls,you can append or import, >> >> >> >> >> >> &g

Re: $$Excel-Macros$$ Fwd: Macro Help Msg Box

Hello Dear, Have a look on updated Workbook. Now you can read formula also, Note that to read formula u have to write::: sheets("sheet name").range("starting1:ending2").FormulaLocal Hope it Will Help Happy To Help :) On Wed, Apr 14, 2010 at 4:56 PM, Venkatesan c wrote: > Dear Grou

Re: $$Excel-Macros$$ Fwd: Macro Help Msg Box

Hello Dear, You can simply read the range,Just use this attached excel Sheet. Hope it Will Help Happy To Help :) On Wed, Apr 14, 2010 at 4:56 PM, Venkatesan c wrote: > Dear Group, > > Need Assistance for folowing Problam > > active cell value is Number(or)text(or)Formula Should sh

Re: $$Excel-Macros$$ : How to add the current month Date in the header

Hello Dear, We are not able to understand your problem,what i am getting is ,you want vba code.u want to fetch interval from now()[End date] and starting date. Is it ok then reply,so that we can provide you the code. Hope it Will Help Happy to help :) Prashant Tripathi On Wed, Apr 14

Re: $$Excel-Macros$$ : How to add the current month Date in the header

Hello Dear, Please read and use the following instruction. Populating Date In Excel • Populate today's date with the Today function. Type "=TODAY()" in a blank cell to return today's date. The Now function returns the date and the time stamp: "=NOW()". • Step 2 Calculate a future date by enter

Re: $$Excel-Macros$$ Re: Pivot Problem

Hello Dear, Once i have read this book when i was totally unaware of even any computer application. Off course every one learn from his/her experience. So try this following book. Stephen Copestake EXCEL 2003 in easy step dreamtech press ISBN:81-7722-505-7 On Wed, Apr 14, 2010 at 11:25

Re: $$Excel-Macros$$ Fwd: Help Required

Hello Dear, Study materials already provided by admin of this group. Please try to search in post. For your 1'st Program,u can try this Tools-->Macro-->Visual Basic Editor or Alt+ F11 This workbook 'Sample Code

Re: $$Excel-Macros$$ Calling a Macro

Hello dear You can call function in any of event... i.e workbook open button click sheet active .. ... Most important is Calling the function. Private Sub CommandButton1_Click() call test1 End Sub Hope it will Help Happy to Help :) Prashant Tripathi On Sun, Apr 11, 2010 at 6:59 PM

Re: $$Excel-Macros$$ OFFICE ERR : SELECTION IS LOCKED

Hello Dear, There amy be 2 reason. 1.u have try to update online,the pirated virson got the problem after updation online. 2.u have try any addins or macro who change the settings. On Fri, Apr 9, 2010 at 1:03 PM, vikas gupta wrote: > DEAR EXCEL GURUS > > I HAVE A PROBLEM IN EXCEL AND WORD

Re: $$Excel-Macros$$ Need Passward Cracker

egards > LKModi > > On Fri, Apr 9, 2010 at 10:33 AM, rf1234 rf1234 wrote: >> >> Hello Dear >> Open this add ins and then your protected workbook. >> Follow the instruction. >> >> >> >> >> >> >> >> >>

Re: $$Excel-Macros$$ If condition issue

Hello Dear You can use Multiple if Condition & Conditional Formatting. Please have a look on attached sheet... Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 10:55 AM, Raj Kumar wrote: > Hi Dear, > > There is a problem in excel so kinly solve my querry > >

Re: $$Excel-Macros$$ Fwd: plz Sir Do It Urgent

Hello Dear You can use Multiple if Condition & Conditional Formatting. Please have a look on attached sheet... Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 10:24 AM, Anil Saxena wrote: > > > -- Forwarded message -- > From: Anil Saxena > D

Re: $$Excel-Macros$$ Import XML

Hello Dear Two ways you can import your XML Data in your Workbook 1. Manually Importing XML Data 2. Programmatically Importing XML Data Now how to……. 1. Manually Importing XML Data: 1. Start Excel and then click Open on the File menu. 2. In the Files of type list, select XML files. 3

Re: $$Excel-Macros$$ Is there a method to find distinct values in a column

Hello Dear 1 of the easiest method is, Select the range Data-->Filter-->Advance Filter-->Unique Record Only For more have the attached Excel Macro. Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 1:29 AM, Rajesh Nair wrote: > Hi All, > > Please help me to

Re: $$Excel-Macros$$ Excel 2007 - Crashing when shared with more than 10 users

Hello Dear This is excel 2007 Compatibility issue, Please contact or chat with Microsoft Specialist https://support.microsoft.com/oas/default.aspx?gprid=11346&st=1&wfxredirect=1 Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 5:21 AM, Vinod N wrote: > Hi Gur

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 47 Messages in 19 Topics

. Thousands rows of records. >> more... >> >> paulwillekens Apr 08 10:11AM -0700 ^ >> >> Hi Grace, >> >> Let's start with this... If any changes are needed, just tell me... >> >> Kind regards, >> >> Paul Willekens >&g

Re: $$Excel-Macros$$ Need Passward Cracker

Hello Dear Open this add ins and then your protected workbook. Follow the instruction. Hope it Will Help Happy To Help :) Prashant Tripathi On Fri, Apr 9, 2010 at 10:09 AM, Jai wrote: > > >> >> Dear All, >> >> Can you Give me VBA Passward Cracker, >> -- >> Thanks For Mail. > > -- > -

Re: $$Excel-Macros$$ Need urgent help.

e Financial > Services & Microfinance. > > On Thu, Apr 8, 2010 at 3:38 PM, rf1234 rf1234 wrote: >> >> Hello Dear, >> Here is the files without zipped. >> >> >> >> >> >> >> >> >> >> >> >>

Re: $$Excel-Macros$$ Re: IMPORT FIXED WIDTH TXT FILE TO EXCEL

Hello Dear, Nice Article.Appriciate your team spirit. On Thu, Apr 8, 2010 at 3:02 PM, paulwillekens wrote: > Hi Vivek, > > No need to make a .csv > > Open the .txt and Excel will ask whether there is a separator or fixed > length... Choose the latter and on the sample you move the vertical

Re: $$Excel-Macros$$ how can protect the excel sheet in VBA Passward.

Hello Dear, Following is the Code to Protect Unprotect Excel Sheet Using VBA. '' Sub ProtectSheet() Dim Passwo

Re: $$Excel-Macros$$ Need urgent help.

people. > Thank you once again. > > > On Thu, Apr 8, 2010 at 12:00 PM, rf1234 rf1234 wrote: >> >> Hello Dear, >> Go through,attached zipped. >> >> >> >> >> >> >> >> >> >> >> >> Hope it Will Help &

Re: $$Excel-Macros$$ How to use logical expression in find method?

Hello Dear, I have attached to Macro 1.Search Special 2.Search & Replace Hope it Will Help Happy To Help :) Shyam On Wed, Apr 7, 2010 at 11:27 PM, Liu Yunxia wrote: > Hello all, > > I'm trying to do a search in Excel for a cell that contains "Apple" or > "Orange". How can I do that i

Re: $$Excel-Macros$$ Need urgent help.

Will try . > > Cheers > baby > > > On 4/6/10, rf1234 rf1234 wrote: >> >> Hello Dear, >> There are some consultancy email id's.This is updated once. >> I think you will got the quick response. >> >> >> i...@be

Re: $$Excel-Macros$$ : HELP

Hello Dear, I am unable to understand your problem,Is it if *SEC STS CD have any value* *Then concatenate STAT DESC value ?* ** If it is then,please let me know. On Wed, Apr 7, 2010 at 6:22 PM, Sundarvelan N wrote: > * TOT BAL* *STAT DESC* *CANCELLED* *CANCELLED* *PT TYPE(5.4)* * >

Re: $$Excel-Macros$$ Upload Excel data to Access, but Access not installed

Hello Dear, It is possible to import export using ADO Controls,I am bit Confuse, How i can send excel data to access when access is not install. Hope it Will Help Happy To Help :) Shyam On Thu, Apr 8, 2010 at 6:54 AM, Chechu wrote: > Hi, I need some help in an export from Excel to

Re: $$Excel-Macros$$ Plz Help me urgent

Hello Dear, I have check it and find great.It's working nice great work. On Wed, Apr 7, 2010 at 4:56 AM, Harmeet Singh wrote: > Good one  guyz nice to see such creative formulas, here is my share of > knowledge. > Kindly check out the index match function without adding additional colu

Re: $$Excel-Macros$$ list of file name from explorer to excel

Hello Dear, I do not know. that is there any way,to bypass network security and access that folder,but if u can save that folder in your pc,then i can provide u the macro, which will display or list file in particular folder. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 20

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

that excel tool tip file. > sry i m new to excel but like this group much its help me a lot > pls tell me the way how can we use that > as i m clicking on that there is some id type is there and nothing else > > please suggest me > > > Regards > On 4/6/10, rf1234 rf1234 wr

Re: $$Excel-Macros$$ How can I Add tool tips to each of list items ?

Hello Dear, Attached workbook have the solution for your proble. Hope it Will Help Happy To Help :) Shyam On Tue, Apr 6, 2010 at 1:26 PM, Anantha wrote: > Hello Folks, > > Can someone help me in adding tooltips for each listbox items > selected. > > I'm using Excel 2007

Re: $$Excel-Macros$$ hi-help required .

m On Tue, Apr 6, 2010 at 11:47 AM, Sarvesh wrote: > hi > thanks for your help. > > what you are doing is right..but i dont knwo pivot table and how did u do > it...any tutorial for the same...? > > > > regards, > *sarvesh lahoti.* > > > --- On *Tue,

Re: $$Excel-Macros$$ Worksheets password break

, kumara datta yagneswara wrote: > Thanks alot Shyam, > > But it has VBA Password ,will you please help me in breaking that > password. > > Regards, > Kumara Datta > > On Mon, Apr 5, 2010 at 6:01 PM, rf1234 rf1234 wrote: >> >> Hello Dear >>

Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA

Hello Dear, I appriciate your prompt reply,it may be a missunderstanding,but please let me know if any one has a outlook express in his or her PC,Then what is need to write a macro for outlook("To Send The Mail") . It is useful when we are accessing outlook from another application. Your sugg

Re: $$Excel-Macros$$ Re: Help: OUTLOOK VBA

Hello Dear i am unable to understand this phase Do I understand you differently from rf1234 please let us know. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 10:28 PM, paulwillekens wrote: > > > Hi Janet, > > Do I understand you differently from rf1234: you are loo

Re: $$Excel-Macros$$ Excel "Create List" Must Be On The Active Worksheet

Hello Dear, try to insert name define ='test'!$D$1:$C1$3000 Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 9:26 PM, ChristopherL wrote: > When I tried the below code, for "Define" I got the Compile error: Sub > or Function not defined > > Public Sub auto_open >

Re: $$Excel-Macros$$ Share Tips and Tricks

Hello Dear, Please reply with Confirmation,what u r looking for home tab. we can help better,when we will understand the exact problem. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 10:03 PM, Manisha Jain wrote: > Hi All - Can you please share any presentation on

Re: $$Excel-Macros$$ help

Hello Dear, if you are looking to permanently lock the project,i think there is no way. because using hex editor you can break the password.actually i am also looking to lock my project which can not be broke using hex editor. Hope it Will Help Happy To Help :) Shyam On Mon, Apr 5, 2

Re: $$Excel-Macros$$ Filtering in Excel

arter can provide the raw data it would be helpful > is cusotmizing acc. to need. Now it is like working blind. Any in > depth solution pls free to contact in link. > On 4/1/10, rf1234 rf1234 wrote: >> Hello Dear, >> I have checked your provided link.It is showing sp

Re: $$Excel-Macros$$ Need urgent help.

Hello Dear, 1'st welcome in our group,we are giving helping hands to vba programmers. 2'ns please let us better understand your problem,do u want to change domain (looking for job) OR Do you want to be a master in VBA. Please make us understand the problem first. Hope it Will Help Happy T

Re: $$Excel-Macros$$ Worksheets password break

Hello Dear Try to use tools--> unprotect workbook tools-->unprotect sheets tools-->unprotect & share workbook Password is abc123 Remember this password while working on that workbook. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:

Re: $$Excel-Macros$$ Worksheets password break

Hello Dear, I can try,i will let you as soon as possible. Please wait for next post. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 4:55 PM, kumara datta yagneswara wrote: > Hi Frnds, > > > Can any one break this file's password. > > Thanks & Regards, > Kumara Datta. > >

Re: $$Excel-Macros$$ Help: OUTLOOK VBA

Hello Dear, Please reply with full information.What you want to do... 1.send mail from excel 2.send attachment from excel 3.send attachment as current sheet or workbook ,using excel Every code are different,i.e for different different purpose codes are different. So please feel free to let us kn

Re: $$Excel-Macros$$ Worksheets password break

Hello Dear, Vishal has provide awesom programming technique to do the same job. for your more requirement i am sending you addins.just open it at then that workbook,which have password protection. Follow the instruction.it is easy and safe. Hope it Will Help Happy to Help :) Shyam O

Re: $$Excel-Macros$$ Importing Text file

Hello Dear, Here is the attached macro for your problem. Here string are picked after tab or new line. u can make change if string are separated by any special character. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 5:06 PM, rf1234 rf1234 wrote: > He

Re: $$Excel-Macros$$ Importing Text file

Hello Dear, This problem is alredy discussed in previous post. try to find out importing txt from notepad to excel. Hope it Will Help Happy to Help :) Shyam On Mon, Apr 5, 2010 at 2:37 PM, Mahesh wrote: > Dear All, > > Need ur advise... > > I got around 20 text files in a day,which ha

Re: $$Excel-Macros$$ 12 secret shortcuts of Excel

Dear All, This post is really helpful for beginers.Appriciate to provide us a beautiful e-book. On Mon, Apr 5, 2010 at 11:29 AM, saroj.32006 wrote: > Dear Group,  Ayush , Ashish & All Persons involved in helping Group, > I really congratulate  for making this an "Our Group". Thanks a

Re: $$Excel-Macros$$ VBA to detect drive

VB 6.0 1 Add DriveListBox 2.Add DirListBox 3.Add FileListBox Resize your above tools on form according to your need. '''

Re: $$Excel-Macros$$ need help

Hello Dear You can automate your excel workbook,according to need u can write code. If you are new then you can try to download from net. Some of the example are available here. http://www.excel-business-solutions.com/free_download.htm Please have a view of files,template which are uploaded by

Re: $$Excel-Macros$$ Filtering in Excel

Hello Dear, I have checked your provided link.It is showing spam free e mail registration. http://anonomi.com/about/ Now for the topic asked before. Shimmy you can try dependent list.Reply me if you are new and want more information. Hope it Will Help Happy to Help :) Shyam On Th

Re: $$Excel-Macros$$ Re: How to remove Invisible symbols in a cell.

Hello Dear Try to select range what u want to format.then format cell then time then desired fromat. If you are looking this in VBA Macro.Then try to use this. ''

Re: $$Excel-Macros$$ Track changes macro

Hello Dear If your workbook is in share mode,you can trace the authenticate user,who has made the changes... Just try to check: Worksheets("Sheet1").OnEntry If true then report or save the log with user name and machine id. I am just giving idea,for full programe it will take time. Hope

Re: $$Excel-Macros$$ Can Sum Product use in Macro

Hello Dear Definately you can any formula in macro. R1C1="Your Formula" Hope it Will Help Happy To Help :) Shyam On Thu, Apr 1, 2010 at 5:10 PM, pushpender nath wrote: > Hi Rajesh > We can use any formula in Macro. > > Pushpender Nath > > On Thu, Apr 1, 2010 at 1:56 PM, Rajesh Nair wr

Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

FROM > Alphanumeric String > From: ca.mod...@gmail.com > To: excel-macros@googlegroups.com > > > > Dear All > > > if there is a coloum containg mix of nos and alphabets > > like ram12 > moh12345an > 132shyam > > we need only alphabets what can we do >

Re: $$Excel-Macros$$ Re: Tip of The day:Extract Number FROM Alphanumeric String

omment is something, which i am sure i > can give on your every solution > > Keep posting such tips :) > > Harpreet Gujral > > On Mar 30, 5:23 pm, rf1234 rf1234 wrote: >> Dear All, >> Attached is the macro to extracting the numeric value from alphanumeric >>

$$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Dear All, Attached is the macro to extracting the numeric value from alphanumeric string. -- Thanks Regards Shyam Software Engineer '''

Re: $$Excel-Macros$$ Please help In seperating alphabets and numbers from a cell

Hello Dear, Following Is the attached macro for your problem. Hope it will Help Happy To help :) Shyam On Tue, Mar 30, 2010 at 1:55 PM, Abhidha Dixit wrote: > Dear All > > I am seeking for the reply of one queryy > how to seperate alphats and no. > eg: jdsdnc2123asdd > iofruif687

$$Excel-Macros$$ *******TIP*******SOME NET CONCEPT**********

''**Net Concept* ' '''Send Current Workbook Mail'''

Re: $$Excel-Macros$$ Need how can vb in ms excel and ebook

Hello Dear, Try to Read on following link.. http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm This is good link for Beginner. Hope it will Help Happy to Help :) Shyam On Thu, Mar 25, 2010 at 10:32 PM, prabhakar thakur wrote: > Dear Group, >                       I need

Re: $$Excel-Macros$$ How to seaprate contents

Hello Dear, Have a look on attached workbook. Hope it Will Help Happy to Help :) Shyam On Thu, Mar 25, 2010 at 9:53 AM, Harpreet Singh Gujral wrote: > Hi Group, > > I have a cell that contains more than one email address, the idea is to > seaprate them from one another through a lo

Re: $$Excel-Macros$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

Dear Nani Check This Link Out http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm this link provide the basic vba concept with code. For the book you mension,i have to look it out. Hope it Will Help Happy To Help :) Shyam On Wed, Mar 24, 2010 at 7:12 PM, Nani Ram <06n...@gmai

Re: $$Excel-Macros$$ Re: Outlook and excel integration

Hello Dear Please have a view in.. http://groups.google.com/group/excel-macros/browse_thread/thread/460883072a940f4e Hope it Will Help Happy to Help :) Shyam On Tue, Mar 23, 2010 at 4:05 PM, rf1234 rf1234 wrote: > Hello Dear > Mail sent macro is already discussed with code. >

$$Excel-Macros$$ ******TIP*****VBA*****=NOW()

Dear All, A clock indicating the current time is usually displayed in the task bar of the PC. One can hide the clock in the task bar if needed. However, hiding the clock does not mean closing the clock itself. The clock actually runs in the background. A computer has two clocks; a software clock

Re: $$Excel-Macros$$ Re: VBA code to capture System time

Dear All, A clock indicating the current time is usually displayed in the task bar of the PC. One can hide the clock in the task bar if needed. However, hiding the clock does not mean closing the clock itself. The clock actually runs in the background. A computer has two clocks; a software clock

Re: $$Excel-Macros$$ Share Tips and Tricks

*** Speed Up Excel Macro *** Poor calculation speed affects productivity and increases user errors. Studies have shown that a user's productivity and ability to focus on a task deteriorate as response time lengthens. Excel has two main calcul

Re: $$Excel-Macros$$ Hi Please Help ME

Hello Dear, I am unable to understand your problem.Please 1'st explain problem. In your attachment,you have not explain your problem. Please Reply So that we can understand your requirements. On Mon, Mar 22, 2010 at 3:27 PM, anil panchal wrote: > Hi All > > A NB MTRL NB Width Ex

Re: $$Excel-Macros$$ Problems using WorksheetFunction Dec2Hex and Hex2Dec in Excel2003

Hello Dear You can access excel function from vba code. here is the example Syntax : ActiveCell.FormulaR1C1 = "=Here your function,What you want to Access" Example ActiveCell.FormulaR1C1 = "=SUM(R[1]C[1],R[2]C[1],R[3]C[1],R[4]C[1],R[5]C[1])" Hope it Will Help Happy to Help :) Shyam On T

Re: $$Excel-Macros$$ macro efficiency

Poor calculation speed affects productivity and increases user errors. Studies have shown that a user's productivity and ability to focus on a task deteriorate as response time lengthens. Excel has two main calculation modes, which let you control when calculation occurs: * Automatic calculat

Re: $$Excel-Macros$$ Who to remove hyperlinks

Dear All Please have a look on Delete all hyperlink workbook. Hope it Will Help Happy to Help :) Shyam On Mon, Mar 22, 2010 at 9:13 PM, Nani Ram <06n...@gmail.com> wrote: > Hi Members, > > i have huge data with hyperlinks. > Is there any shortcut key or formula to remove all hyperlinks at

Re: $$Excel-Macros$$ Re: Outlook and excel integration

Hello Dear Mail sent macro is already discussed with code. Try to execute that code if expiry date condition fulfill. Hope it will Help Happy to help :) Shyam On Mon, Mar 22, 2010 at 5:12 PM, ~ Z A H E E R ~ wrote: > Sorry, Plz read as > Is it possible to integrate MS Outlook 2007 and M

Re: $$Excel-Macros$$ Navigation Macro..

Hello Dear, You can use go to reference.Sample sheet with code is attached. I think it will help you. Hope it will Help Happy To Help :) Shyam On Tue, Mar 23, 2010 at 5:19 AM, Spud wrote: > Can you post an example showing how the format of the cell values (you > mention that the cell valu

Re: $$Excel-Macros$$ autofill vba

Hello Dear Attached is the sample sheet, Perhaps it can help you to print & achieve suitable result. Hope It Will Help Happy To Help :) Shyam On Fri, Mar 19, 2010 at 12:52 PM, OSAVentures Calamba wrote: > Hi All, I'm trying to fill C6 with value of 1 then selecting that and >

Re: $$Excel-Macros$$ Share Tips and Tricks

Hello All Some of bug i have remember.trying to share with you. On Thu, Mar 18, 2010 at 9:56 AM, Ayush wrote: > Hello Everyone, > > I request you all to share any tips or tricks that you have about MS > Excel in the group. It really helps. > > The tip can be anything like formula, m

Re: $$Excel-Macros$$ Share Tips and Tricks

Hello Ayush You have started a good topic,I think in this topic we can share our some tips and tricks.I am starting a topic ... '' Diffrence between VBA & .NET '''

Re: $$Excel-Macros$$ How To Protect VBA Code.

Hello Dear Following is the Steps,You can follow. ' Open Vba Edito

Re: $$Excel-Macros$$ Useful Tips - MS Excel 2003 to 2007

Dear Harish Really Helpful Topic. Happy to Help :) Shyam On Wed, Mar 17, 2010 at 1:28 PM, harish chandru wrote: > Hi All Hope this helps u all... > > > http://office.microsoft.com/en-us/help/HA101491511033.aspx   -> Interactive > page, very useful > > > >  Thanks > > Harish > > --

  1   2   >