Thanks.
On Thu, Feb 23, 2012 at 3:22 AM, ChilExcel chilexcel...@gmail.com wrote:
check whether this help
http://www.rondebruin.nl/key.htm
Thanks
Chilexcel
2012/2/22, Indrajit $nai talk2indra...@gmail.com:
Hi All,
Is there any coding is available which can capture the
Very useful file.
Thanks Abhishek to share with group.
On Thu, Feb 23, 2012 at 1:27 PM, Abhishek Jain abhishek@gmail.comwrote:
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.
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”
File attached for ready reference.
On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande prajakt.pa...@gmail.comwrote:
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
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 noorain.ans...@gmail.comwrote:
Very useful file.
Thanks Abhishek to share with group.
On Thu, Feb 23, 2012 at 1:27 PM, Abhishek Jain
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:
Dear Prajakt,
See attached sheet..
On Thu, Feb 23, 2012 at 1:52 PM, Prajakt Pande prajakt.pa...@gmail.comwrote:
File attached for ready reference.
On Thu, Feb 23, 2012 at 12:21 PM, Prajakt Pande
prajakt.pa...@gmail.comwrote:
Dear Experts,
How to show user name (Computer name or
dear Asa
Its not working in text also
please u try the same
On Thu, Feb 23, 2012 at 1:59 PM, Asa Rossoff a...@lovetour.info 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.
** **
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,
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
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 for
Thanks Asa ,it worked
On Thu, Feb 23, 2012 at 5:38 PM, Asa Rossoff a...@lovetour.info 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
Dear Noorain,
Thanks for your support.
It fine, but can we do running time. Means second by second.
-- Forwarded message --
From: NOORAIN ANSARI noorain.ans...@gmail.com
Date: Thu, Feb 23, 2012 at 1:01 PM
Subject: Re: $$Excel-Macros$$ Show User name current time
To:
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 prajakt.pa...@gmail.comwrote:
Dear Noorain,
Thanks for your support.
It fine, but can we do running time. Means second by
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
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
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
Dear Ankit,
Please attached sheet with solution..
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Thu, Feb 23, 2012 at 6:22 PM, Ankit Agrawal
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
very useful
On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
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
Xlstime,
Where do I put that formula?
John
On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com 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
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 xlst...@gmail.com wrote:
in Name Manager,
press alt+i+n+d
On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.comwrote:
Xlstime,
Where
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/2/23 Abhishek Jain abhishek@gmail.com
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.
??...need images save in sheet wise and summary sheet
On Thu, Feb 23, 2012 at 9:34 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote:
2012/2/23 Abhishek Jain abhishek@gmail.com
Thanks Noorain sir for your kind words but its the original coder who
deserves the applause.
thanks Noorain, its helpful for excel users lke me ,
On Thu, Feb 23, 2012 at 8:17 PM, xlstime xlst...@gmail.com wrote:
very useful
On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI noorain.ans...@gmail.com
wrote:
Dear Group,
I have shared a Custom Format example sheet, i got it from
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
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 a...@lovetour.info
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 samde...@gmail.comwrote:
I know I mentioned otherwise in
http://osdir.com/ml/excel-macros/2011-12/msg00084.html
However,* you cannot use ++*
You
Dear Noorain, Asa
Excellent answer very clear explanation thanks
regards
chandru
On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff a...@lovetour.info wrote:
Hi Johann,
To add to Noorain's explanation:
** **
Boolean (True/False) values cannot be added, multiplied, averaged,
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
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.
http://chandoo.org/wp/2009/08/10/excel-waterfall-charts/
On Thu, Feb 23, 2012 at 11:35 PM, danial mansoor danial_...@hotmail.comwrote:
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
Thank you sir,
Regards,
Ankit
On Thu, Feb 23, 2012 at 7:15 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Ankit,
Please attached sheet with solution..
--
Thanks regards,
Noorain Ansari
** http://excelmacroworld.blogspot.com/*http://noorainansari.com/*
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
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
36 matches
Mail list logo