RE: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Thanks, Chandru. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Thursday, February 23, 2012 9:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function Dear Noora

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

Hi Hariharan, Is there any special reason to do this from Excel? SendKeys is unreliable, and you have no way to verify the results using built-in VBA functionality. Usually: The best place to script would be on the server using tools installed there. The next best place would be in your ter

Re: $$Excel-Macros$$ Required Name

Thank you sir, Regards, Ankit On Thu, Feb 23, 2012 at 7:15 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please attached sheet with solution.. > > -- > Thanks & regards, > Noorain Ansari > ** *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ water fall chart

http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/ On Thu, Feb 23, 2012 at 11:35 PM, danial mansoor wrote: > hi experts, > > can any one send me working on water fall chart with connector lines?i > need template with formulas i just need to put values and it automatically > made chart with

$$Excel-Macros$$ water fall chart

hi experts, can any one send me working on water fall chart with connector lines?i need template with formulas i just need to put values and it automatically made chart with connector using given data. note: data should be composed on intail and final values and in between these 4 values.

Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users

That’s because the defined name was not referenced in the chart sources. series=smith.xls!definedname Don Guillett SalesAid Software dguille...@gmail.com From: John A. Smith Sent: Thursday, February 23, 2012 9:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Chart Template

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

Dear Noorain, Asa Excellent answer very clear explanation thanks regards chandru On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff wrote: > Hi Johann, > > To add to Noorain's explanation: > > ** ** > > Boolean (True/False) values cannot be added, multiplied, averaged, etc. by > agg

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

I'm from SAS background. Can anybody please provide an example for the following scenario. On Thu, Feb 23, 2012 at 11:02 AM, Sam Mathai Chacko wrote: > I know I mentioned otherwise in > http://osdir.com/ml/excel-macros/2011-12/msg00084.html > > However,* you cannot use ++* > > You can use +0, *1

Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function

I know I mentioned otherwise in http://osdir.com/ml/excel-macros/2011-12/msg00084.html However,* you cannot use ++* You can use +0, *1, -0, /1, ^1 etc, but -- is the most elegant and common approach. Regards, Sam Mathai Chacko On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff wrote: > Hi Johann,

$$Excel-Macros$$ Progress bar help

Dear all, i have very long code it like 250 lines during my code process how use Prgress bar untill my code end sub the progress bar will run, Thanks Regards chandru -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pl

Re: $$Excel-Macros$$ Custom Format Examples

thanks Noorain, its helpful for excel users lke me , On Thu, Feb 23, 2012 at 8:17 PM, xlstime wrote: > very useful > > On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI > wrote: > >> Dear Group, >> >> I have shared a Custom Format example sheet, i got it from below link >> >> http://spreadshe

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

??...need images save in sheet wise and summary sheet On Thu, Feb 23, 2012 at 9:34 PM, Bé Trần Văn wrote: > > > 2012/2/23 Abhishek Jain > >> Thanks Noorain sir for your kind words but its the original coder who >> deserves the applause. >> >> Veeru, I will have a look in your new re

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

2012/2/23 Abhishek Jain > Thanks Noorain sir for your kind words but its the original coder who > deserves the applause. > > Veeru, I will have a look in your new requirement after a few hours though > I am sure one of the experts from the group would address this by that > time. > > Thanks > > A

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

Hi Experts, Could you please help on this? Am I clear in the requirement? Thanks, Hariharan Tharagan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012

Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users

Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime wrote: > in Name Manager, > > press alt+i+n+d > > > On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith wrote: > >> Xlstime, >> >> Where do I put that formula? >>

Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users

Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime wrote: > Dear John, > > Please find the attachment > > > use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) > > > > > On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith wrote: > >> I would like to

Re: $$Excel-Macros$$ Custom Format Examples

very useful On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI wrote: > Dear Group, > > I have shared a Custom Format example sheet, i got it from below link > > http://spreadsheetpage.com/index.php/file/custom_number_formats/ > > Hope it will help to all of you. > > -- > Thanks & regards, > Noorai

Re: $$Excel-Macros$$ Number gets change by modification

Great Job done *Asa* *Rossoff* !!! On Thu, Feb 23, 2012 at 5:38 PM, Asa Rossoff wrote: > Hello, Priyanka, > > Just tried. > > ** ** > > It works for me any of these ways: > > (1) File-> Open (Show all files) > > (2) Data-> External-> From Text > > (3) Drag File onto Excel-> T

Re: $$Excel-Macros$$ Help with code please.

I do not disagree. Don Guillett SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Wednesday, February 22, 2012 7:36 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help with code please. Hey Don, I wasn't saying my modification would be faster. Find starts sea

Re: $$Excel-Macros$$ Required Name

Dear Ankit, Please attached sheet with solution.. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Thu, Feb 23, 2012 at 6:22 PM, Ankit Agrawal wrote: > Dear Sir

$$Excel-Macros$$ Excel macro for IBM Mainframe 3270

Hi Experts, I am a IBM Mainframe 3270, Reflection User (Terminal Emulation Front End)and I don't have access for Session Manager. I just need a macro to do some process automation. * Is it possible to interact with Mainframe without connectivity? * Will Send Keys work f

$$Excel-Macros$$ Re: Required Name

Hi In C16 and copied down, =INDEX($A$2:$A$12,MATCH(B16,INDEX($B$2:$F$12,,MATCH(A16,$B$1:$F$1,0)),0)) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem,

$$Excel-Macros$$ Required Name

Dear Sirs, I have query, plz solve it. Regards, Ankit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may

Re: $$Excel-Macros$$ Show User name & current time

Prajakt, The file I sent has a running clock. Please advise if you have any trouble using it. Thanks & regards, Abhishek On Thu, Feb 23, 2012 at 6:06 PM, Prajakt Pande wrote: > Dear Noorain, > > Thanks for your support. > > It fine, but can we do running time. Means second by second. > > > > -

Fwd: $$Excel-Macros$$ Show User name & current time

Dear Noorain, Thanks for your support. It fine, but can we do running time. Means second by second. -- Forwarded message -- From: NOORAIN ANSARI Date: Thu, Feb 23, 2012 at 1:01 PM Subject: Re: $$Excel-Macros$$ Show User name & current time To: excel-macros@googlegroups.com D

Re: $$Excel-Macros$$ Number gets change by modification

Thanks Asa ,it worked On Thu, Feb 23, 2012 at 5:38 PM, Asa Rossoff wrote: > Hello, Priyanka, > > Just tried. > > ** ** > > It works for me any of these ways: > > (1) File-> Open (Show all files) > > (2) Data-> External-> From Text > > (3) Drag File onto Excel-> Text to Column

RE: $$Excel-Macros$$ Number gets change by modification

Hello, Priyanka, Just tried. It works for me any of these ways: (1) File-> Open (Show all files) (2) Data-> External-> From Text (3) Drag File onto Excel-> Text to Columns All methods provide the text import dialog (or similar for text to columns). In that dialog I: (1) Step 1: Delimited

RE: $$Excel-Macros$$ macro to sort excel data & email to party

Sure point taken... Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: 23 February 2012 10:43 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ macro to sort excel data & email to party Dear Ami

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

Thanks Noorain sir for your kind words but its the original coder who deserves the applause. Veeru, I will have a look in your new requirement after a few hours though I am sure one of the experts from the group would address this by that time. Thanks Abhishek On Thu, Feb 23, 2012 at 1:58 PM,

Re: $$Excel-Macros$$ Number gets change by modification

dear Asa Its not working in text also please u try the same On Thu, Feb 23, 2012 at 1:59 PM, Asa Rossoff wrote: > Hi Priyanka, > > You need to specify that that column is text. Not a number. Excel > doesn't support numbers with over 15 significant digits. > > ** ** > > Asa > > *

Re: $$Excel-Macros$$ Show User name & current time

Dear Prajakt, See attached sheet.. On Thu, Feb 23, 2012 at 1:52 PM, Prajakt Pande wrote: > File attached for ready reference. > > > On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande > wrote: > >> Dear Experts, >> >> How to show user name (Computer name or login name,) in user form, and >> also

RE: $$Excel-Macros$$ Number gets change by modification

Hi Priyanka, You need to specify that that column is text. Not a number. Excel doesn't support numbers with over 15 significant digits. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of PrIyAnKa Sent: Wednesday, February 22, 2012 11:22 PM To: ex

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

Dear Abishek sir, It's thankfull u and i need images save in sheet wise and summary sheet On Thu, Feb 23, 2012 at 1:48 PM, NOORAIN ANSARI wrote: > Very useful file. > Thanks Abhishek to share with group. > > On Thu, Feb 23, 2012 at 1:27 PM, Abhishek Jain wrote: > >> Veeru, >> >> Atta

Re: $$Excel-Macros$$ Show User name & current time

File attached for ready reference. On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande wrote: > Dear Experts, > > How to show user name (Computer name or login name,) in user form, and > also current time with changing the seconds, minutes, and hours, > If person starts his work on particular file, e

$$Excel-Macros$$ Show User name & current time

Dear Experts, How to show user name (Computer name or login name,) in user form, and also current time with changing the seconds, minutes, and hours, If person starts his work on particular file, e.g. tracker.xlms (File name) It needs to show “Good Morning” Good Afternon” Good evening” th

Re: $$Excel-Macros$$ images export in Excel with Image name and Hyperlink

Very useful file. Thanks Abhishek to share with group. On Thu, Feb 23, 2012 at 1:27 PM, Abhishek Jain wrote: > Veeru, > > Attached file imports list for all files in a folder (which you would get > to choose) and puts them in Column A with hyperlinks. > > Hope this helps. > > Credits to the origi

Re: $$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....

Thanks. On Thu, Feb 23, 2012 at 3:22 AM, ChilExcel wrote: > check whether this help > > http://www.rondebruin.nl/key.htm > > Thanks > > > Chilexcel > > 2012/2/22, Indrajit $nai : > > Hi All, > > > > Is there any coding is available which can capture the "Keystroke" in a > > Excel file, Like