$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

2009-08-24 Thread vivek agrawal
Hi See the attached image which contains the instructions on how to change the tab order of objects on a user form. in the image "Info Survey" refers to your user form... Hope that will help Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving ener

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

2009-08-24 Thread bharghav r
Its starnge to c tht it works in my system but not in my colleagues system.I guess its not a problem with the code rather with his system.Anyways thanx for the code.. On Tue, Aug 25, 2009 at 10:39 AM, vivek agrawal wrote: > Hi > > Shell "F:\Running Apps\FTP Backup\backup.bat", 1 > > the above cod

$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

2009-08-24 Thread bharghav r
Vivek, Can u give me the code.The portal which u hav referred is a payable site. Regards, Bharghav R On Tue, Aug 25, 2009 at 10:18 AM, vivek agrawal wrote: > hi > the below web page will help you to set tab order for the text boxes... > http://www.excel-vba.com/vba-forms-3-6-text-boxes.htm > >

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

2009-08-24 Thread vivek agrawal
Hi Shell "F:\Running Apps\FTP Backup\backup.bat", 1 the above code might help but i would like to know why the code which you gave is not reliable. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 4:5

$$Excel-Macros$$ Re: Find the second highest no.

2009-08-24 Thread vivek agrawal
Hi Gaurav The LARGE function allows to find any level of value... from highest to lowest. 2 arguments required 1. the range of numbers 2. the level required for example, 1 for highest, 2 for second highest. and so on... ALL THE BEST Thanks and Regards, Vivek Agrawal Skype ID - v

$$Excel-Macros$$ Re: Urgent: Need help in dashboard creation

2009-08-24 Thread vivek agrawal
hi the below web page will help you to set tab order for the text boxes... http://www.excel-vba.com/vba-forms-3-6-text-boxes.htm to execute a code on entering a data in a cell and pressing enter. you will have to call that procedure in the worksheet_change() sub procedure

$$Excel-Macros$$ Re: Find the second highest no.

2009-08-24 Thread Mahesh
Hi, You can use the below mention fromula for finding the second highest value. =LARGE(A1:A10,2) Rgds, Mahender Bisht On Mon, Aug 24, 2009 at 7:39 PM, Gaurav Banerjee wrote: > Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae. > For eg. > 12 > 3 > 45 > 1 > 18 > 90 > 15

$$Excel-Macros$$ Urgent: Need help in dashboard creation

2009-08-24 Thread bharghav r
Hi All, 1> Is there any option of switching between textboxes(textbox1,textbox2,combobox) using tab key in excel ? 2> On entering data in a particular cell n hitting enter key I must be able to run a set of code.Is this possible? -- Thanks and Regards Bharghav Ramdas --~--~-~--~

$$Excel-Macros$$ Re: Excel 2002 Forms toolbar

2009-08-24 Thread Tommy
I went on the link below and discovered that some of the controlls on the Froms Toolbar were designed to run on Excel 5.0, not what I have. I wonder why they were included on a version that couldn't use them!. http://www.bettersolutions.com/excel/EVZ193/QB215612321.htm As you probably guess, I a

$$Excel-Macros$$ Re: How to plus two textboxes in currency and with 2 decimals

2009-08-24 Thread Ciffor
Thx for your reply! Sadly, it doesn't work. I have three textboxes; txt1, txt2 and txt3. Example: In txt1 the number "200" is entered. In txt2 the number "150,50" is entered. Now, the result i'm hunting for which txt3 should be showing, is "350,50". But as it is now, it shows "350" or "351".

$$Excel-Macros$$ Re: How to use sheet names in formulae ?

2009-08-24 Thread Subu
Thanks Martin Initially I struggled with this...but now got the hang of it.. Best regards Subu On Aug 20, 1:02 am, gasparovicm wrote: > Hello, > You can use INDIRECT function, something like > INDIRECT(CONCATENATE(A4;"!$A:$A")) > instead of > KESORAMIND!$A:$A > then name of sheet in formula wi

$$Excel-Macros$$ Re: saving VBA-created objects

2009-08-24 Thread Joseph Choi
you may need to save the user input state of your controls (combo box, listbox) and save it on your workbook, into cells. then, at startup (or workbook/sheet load), read these values and reapply them to your controls. of course, someone here may have a solution to actually save the form. On Mon,

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-24 Thread Prashant Bhawar
On Mon, Aug 24, 2009 at 8:02 PM, prashant bhawar wrote: > > > On Mon, Aug 24, 2009 at 10:49 AM, Sandeep wrote: > >> Hi Prashant, >> >> For changing path of file, the best way for you is to open both of your >> excel files then select >> 'C:\Documents and >> Settings\Sandeep\Desktop\[cm17AUG2009b

Fw: $$Excel-Macros$$ Re: Please Help Me!!!***Solved***

2009-08-24 Thread Sandeep
- Original Message - From: Sandeep To: excel-macros@googlegroups.com Sent: Sunday, August 23, 2009 2:27 PM Subject: Re: $$Excel-Macros$$ Re: Please Help Me!!!***Solved*** Hi Everyone, I solved my problem of ranking. Here is attach solution Thanks Everyone for helping me. Specially D

$$Excel-Macros$$ Re: Find the second highest no.

2009-08-24 Thread Sandeep
Hi Gaurav, You can use the 'Large()' function. =large(A1:A10,2) Regards Sandeep - Original Message - From: Gaurav Banerjee To: excel-macros@googlegroups.com Sent: Monday, August 24, 2009 7:39 PM Subject: $$Excel-Macros$$ Find the second highest no. Hi,, How to fnd the se

$$Excel-Macros$$ saving VBA-created objects

2009-08-24 Thread Jene
Hi all, I'm new to your board and hope you might be able to help me out. I've been searching for an answer to this problem and coming up empty - maybe I'm not using the correct terms. I have a set of macros that create combo and list boxes on a worksheet in my workbook. When you click on a command

$$Excel-Macros$$ Re: Find the second highest no.

2009-08-24 Thread Harmeet Singh
See attached file On Mon, Aug 24, 2009 at 7:39 PM, Gaurav Banerjee wrote: > Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae. > For eg. > 12 > 3 > 45 > 1 > 18 > 90 > 15 > 76 > 99 > 9 > > the result should be 90. > > Can any1 hlp out with this? > > > > -- Thanks & Regar

Fw: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-24 Thread Sandeep
- Original Message - From: Sandeep To: excel-macros@googlegroups.com Sent: Monday, August 24, 2009 10:49 AM Subject: Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria Hi Prashant, For changing path of file, the best way for you is to open both of your excel

$$Excel-Macros$$ Re: Find the second highest no.

2009-08-24 Thread siddarth v
Use LARGE function On Mon, Aug 24, 2009 at 2:09 PM, Gaurav Banerjee wrote: > Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae. > For eg. > 12 > 3 > 45 > 1 > 18 > 90 > 15 > 76 > 99 > 9 > > the result should be 90. > > Can any1 hlp out with this? > > > > -- V.Siddarth -

$$Excel-Macros$$ Re: Urgent:: Need code to run batch script thru Excel

2009-08-24 Thread Harmeet Singh
try below code: Sub Runbf() Dim obf obf = Shell("D:\Documents and Settings\Harmeet Singh\Desktop\IP_Address.bat", 1) End Sub On Mon, Aug 24, 2009 at 4:52 PM, bharghav r wrote: > > Hi all, > > > > I am in need of a macro which will run a batch script. > > > Is there any alternative to call a

$$Excel-Macros$$ Re: Find the second highest no.

2009-08-24 Thread Aindril De
Dear Gaurav, Assuming that your data is in range A1:A10, =LARGE(A1:A10,2) will find the second highest number in the range. Let me know if this helps. Regards, Andy On Mon, Aug 24, 2009 at 7:39 PM, Gaurav Banerjee wrote: > Hi,, How to fnd the second highest no. in a grop of 10 No. using formul

$$Excel-Macros$$ Find the second highest no.

2009-08-24 Thread Gaurav Banerjee
Hi,, How to fnd the second highest no. in a grop of 10 No. using formulae. For eg. 12 3 45 1 18 90 15 76 99 9 the result should be 90. Can any1 hlp out with this? --~--~-~--~~~---~--~~ ---

$$Excel-Macros$$ Re: Help for Hlookup using if function

2009-08-24 Thread Dilip Pandey
Hi Mahesh, Please find one simple solution + one dynamic solution for your query in the attached workbook. thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Aug 23, 2009 at 10:51 AM, mahesh parab

$$Excel-Macros$$ Urgent:: Need code to run batch script thru Excel

2009-08-24 Thread bharghav r
Hi all, I am in need of a macro which will run a batch script. Is there any alternative to call a batch file other than the below code. The below code is not reliable Public Sub runBat() Dim RetVal RetVal = Shell("cmd.exe /c %PLANNING_HOME%\bin\pum.bat") End Sub Kindly twe

$$Excel-Macros$$ Re: Fw:

2009-08-24 Thread Dilip Pandey
Hi William, Apologies for the delay. Please find the attached solution. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sun, Aug 23, 2009 at 2:50 AM, William wrote: > > - Original Message -

$$Excel-Macros$$ Re: How to plus two textboxes in currency and with 2 decimals

2009-08-24 Thread AmbiguousError
Hi there, Not sure how you're calculating your currencies? But if you enter =ROUND(A1,2), where A1 is the result of your currency calc & 2 is the number of decimal places you're rounding to. Format this cell as the currency you'd like, Sorted? On Aug 24, 3:21 pm, Ciffor wrote: > Hey out there

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-24 Thread AmbiguousError
Hi guys, I've just been playing through your worksheets, great stuff. I've made a couple of changes that you might find useful... although I don't seem able to upload? I brought the results tab into the same workbook as the data. This way when knew data is available, you just paste over the old

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

2009-08-24 Thread vivek agrawal
then do one thing just mail the moderator. he would certainly take care of that you can mail Ashish or Ayush Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 5:13 PM, Sandeep wrote: > *From:*

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

2009-08-24 Thread vivek agrawal
when did u send them... Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 5:07 PM, Sandeep wrote: > They not come the the forum. I don't know what happent to them. > > Sandeep > > - Original Message

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

2009-08-24 Thread vivek agrawal
have your mails been blocked?? Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 4:56 PM, vivek agrawal wrote: > Hi Sandeep > > The mails to this group have to go through moderation. > Only when the m

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

2009-08-24 Thread vivek agrawal
none of the mails are blocked. they are just waiting for moderation its entire upto the moderator to approve the mails... but till date none of my mails have been blocked or any body others' too for that matter. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMo

$$Excel-Macros$$ Re: About mails Send and recieve to the Excel Macro Group

2009-08-24 Thread vivek agrawal
Hi Sandeep The mails to this group have to go through moderation. Only when the moderator approves the mail, that it gets delivered to the group for members viewing. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24,

$$Excel-Macros$$ Re: Frnds

2009-08-24 Thread vivek agrawal
Hi Some pdfs have been uploaded to the groups FILES section. kindly go through that and if u dont find any then feel free to write back. Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Aug 24, 2009 at 2:05 PM, Shiyas

$$Excel-Macros$$ Re: Cell adds previous values automatically

2009-08-24 Thread Ometoon
Tried the camera function for instance? On 20 aug, 21:13, TAlgo wrote: > i dont have a file created yet but its simple. > > I receive real time market data from third party application and link > to excel so cell A5 will constantly updated. > > I would like to capture and sum each price on cell

$$Excel-Macros$$ Frnds

2009-08-24 Thread Shiyas A
Hello Frnds, Good Day to u all Me a beginner in Excel Macros , can anybody suggest me the best book available in the market from which i can learn the basics of VB Macros in Excel with examples on reply email. many thanks n regards Shiyas --~--~-~--~~~---~--~~

$$Excel-Macros$$ Re: Need Urgent help in finding formula.

2009-08-24 Thread vinod rao
Hi Prashanth, Your solution is perfect but the disadvantage is the file size is going to increase as my data his huge. But good attempt i really appreciate Regards, Vinod On Sat, Aug 22, 2009 at 9:02 AM, Prashant Bhawar wrote: > > > On Fri, Aug 21, 2009 at 1:09 PM, vinod rao wrote: > >> Hello

$$Excel-Macros$$ Re: $$Excel - Macro$$, Automatically copy and paste the Formulas based on user inputs

2009-08-24 Thread Suhas
Hi Venkatesh, How can i send the attachement, i cant find any options here On Aug 18, 4:00 pm, venkatesh wrote: > hi Chetan! > > Can you please send a attachement with an example, which can help us > to sort the isssue ASAP. > > Regards > > On Aug 18, 2:42 pm, Suhas wrote: > > > > > Hello Expe

Re: Fw: $$Excel-Macros$$ V look within a specific range based on criteria

2009-08-24 Thread Sandeep
Hi Prashant, For changing path of file, the best way for you is to open both of your excel files then select 'C:\Documents and Settings\Sandeep\Desktop\[cm17AUG2009bhav.xls]cm17AUG2009bhav'!$B$2:$B$1256 with this keep selecting go to your data file and select the range you want . All the thin