Hi Team,
I would like to know if I can use the value of one procedure as input
to the other procedure.
For example:
I have a user form, it has two command buttons, the first one is
requesting for a file location(address/path) and the second does also
requesting another file location
Dear Amarender,
Please use it..
Public Sub Lfile_Name()
Dim IFileName As Variant
IFileName = Application.GetOpenFilename(Excel Files (*.xls),*.xls)
MsgBox IFileName
End Sub
Public Sub SFile_Name()
Dim SFileName As Variant
SFileName = Application.GetOpenFilename(Excel Files (*.xls),*.xls)
MsgBox
Dear Team
Kindly find the attached file
One of my friend has sent revised IT calc sheet today
--
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
See I have something to aks u?
Can we convert the office 2007 file into office 2003 format, currently
being in the office 2003.
Any help is appreciated.
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
Dear Maries,
This one was nice...can you please also provide us the solution for it?
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Maries
Sent: 07 February 2012 16:09
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Dear Jai, how to use the file i.e., in some .xlam format.
U have any vba code to change the file format (2003 - 2007).
Regards,
Muneer,
CC...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
hi ashish
use =MAX(--REPLACE(A2:A41,1,9,)) with CSE
On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote:
Dear expert,
I want to formula of maximum number find from a different list which
example attached herewith.
Thanks regards
Ashish Bhalara
--
FORUM
Maximum number is 1003, not display in your formula
On Wed, Feb 8, 2012 at 4:49 PM, The Viper viper@gmail.com wrote:
hi ashish
use =MAX(--REPLACE(A2:A41,1,9,)) with CSE
On Wed, Feb 8, 2012 at 4:18 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:
Dear expert,
I want to formula
its working fine.
now i have wrote two types of formulas
go through the attachment.
On Wed, Feb 8, 2012 at 4:53 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote:
Maximum number is 1003, not display in your formula
On Wed, Feb 8, 2012 at 4:49 PM, The Viper viper@gmail.com wrote:
hi
Dear Group Owner,
I am required link of Unsubscribe or you may unsubscribe me from this Group.
Because this company id.
Thanking u
ThanksRegards
_
Sudhir Verma
Asstt. Mngr. A/c's
QUALITY HOME APPLIANCES
47, RAJASTHANI UDYOG NAGAR
DELHI - 110033
MOBILE +91 9818479722
HI
following link will solve your issue
http://ubitmenu.en.softonic.com/
Take care self and other
Regards
Hemal
--
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
thanks Don, but it doesnt solve what i want on the summary sheet, i want to
be able to SELECT from the drop down list from the summary sheet and hv the
ind. companies populate. c
On Wed, Feb 8, 2012 at 2:05 PM, dguillett1 dguille...@gmail.com wrote:
Why not just use datafilterautofilterfilter
Ok Don I understand u what u want to get from me.
Hope this will serve u to understand what I want to say, means (aa),
(bb) (cc) are the 3 separate macros ok. If I want to merge these 3
macros into 1. what could be the process?
How I can merge them?
What code is applicable in doing so?
(aa)
Great Kris,
Seems to be getting there but what about the other members under the
industry eg Agro has Benso and GWEB, ie 2 members , banking has eight
members, you formula is great in populating the first line but what about
the other members. thanks in advance, you guys are realy good
On Wed,
I want to capture an image and save to specified location in system
using vba. Also need the file address in the active cell.
Thank you in advance for your help.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Hi
OK. Try this.
In A1 on Summary,
=INDEX(A3:A14,A2)
In AD3 on 'FINANCIAL ANALYSIS'
0
In AD4 and copied down,
=IF(B4,IF(B4=Summary!$A$1,LOOKUP(9.99E+307,$AD$3:AD3)+1,),)
In AE3
=MAX(AD4:AD38)
In E5 on 'Summary' and copied down across,
=IF(ROWS(E$5:E5)='FINANCIAL
I don’t understand what you want the final result to look like... I’m trying..
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Wednesday, February 08, 2012 8:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Thanx in advance!
Ok Don I
My point is that you may not NEED a summary sheet. However, if you insist a
macro could do the autofilter and copy/paste to the summary sheet driven by
the drop down...
Don Guillett
SalesAid Software
dguille...@gmail.com
From: hilary lomotey
Sent: Wednesday, February 08, 2012 8:09 AM
To:
Hi Don
am not the VBA type for now, still reading beginners manual. but a lil help
with VBA wont hurt . thanks
On Wed, Feb 8, 2012 at 2:42 PM, dguillett1 dguille...@gmail.com wrote:
My point is that you may not NEED a summary sheet. However, if you
insist a macro could do the autofilter and
What does that have to do with MATCH?
Sam
On Wed, Feb 8, 2012 at 1:29 AM, dguillett1 dguille...@gmail.com wrote:
OK. Just add some text to the rest of the rows in col A on sheet2 so
the “activites”name works
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* Sam Mathai
Sam, I MIS spoke the first time
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Wednesday, February 08, 2012 9:21 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Solution required plz
What does that have to do with MATCH?
Sam
On Wed, Feb
Sam, I hope you guessed right. Maybe I’m just getting too old.
However, his data showed an autofilter for the same column without much
explanation.
Hopefully, OP will help us help.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Wednesday, February 08, 2012
Hi,
I am new to excel field but want to learn excel and macros, could you
please provide me training materials. And also add my Id to this
group.
Thanks
Liyakath Ali Khan
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
Thanks Sam.
On 2/7/12, Sam Mathai Chacko samde...@gmail.com wrote:
Use this link and send an invite to your friend
https://groups.google.com/group/excel-macros/members_invite?hl=en
Regards,
Sam
On Tue, Feb 7, 2012 at 11:00 PM, Sam Mathai Chacko
samde...@gmail.comwrote:
I have sent you
Currently you are a member of this group
Sam
On Wed, Feb 8, 2012 at 8:03 PM, Liyakath Khan liyakath1...@gmail.comwrote:
Hi,
I am new to excel field but want to learn excel and macros, could you
please provide me training materials. And also add my Id to this
group.
Thanks
Liyakath
Dear Team
in excel file i know protect sheets but i need particular
Cells put the code or protect how it possible
VBA code also no problem
--
*ThanksRegards*
* *
* **Veerendra.Vanam*
*TOC TEAM*
* * *Bhagyanagar Electrical Contractors**
**
select all the cells, right click, format cell, protection tab, uncheck the
locked status
Now select only those cells that need to be protected, right click, format
cell, protection tab, now check the locked status
Finally, protect the sheet. now those cells cannot be editted.
Sam Mathai Chacko
sir,
it;s not working sir
small example:
A B total 12 6 72 14 8 112 15 8 120
above columns i protect of cells 72,112,120 only how its possible
On Wed, Feb 8, 2012 at 10:51 PM, Sam Mathai Chacko samde...@gmail.comwrote:
select all the cells, right click, format cell,
Superb, wonderful sam, the formula is a beautiful and works to perfection.
Thanks Kris, Don you guys are genius.
On Wed, Feb 8, 2012 at 3:42 PM, Sam Mathai Chacko samde...@gmail.comwrote:
Not sure why you need a CHOOSE in there. Anyway, is this what you are
looking for?
Regards,
Sam
this formula also works to perfection, great guys
On Wed, Feb 8, 2012 at 4:04 PM, Kris krishnak...@gmail.com wrote:
Hi,
PFA
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need
*Learn:*
- Introduction to SUMPRODUCT
Formulahttp://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
- Advanced SUMPRODUCT Formula
Exampleshttp://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/
- Introduction to SUMIFS
Dear Veeru,
Visit on below link
http://www.youtube.com/watch?v=hForkbT9vgs
http://oreilly.com/pub/h/1216
On Wed, Feb 8, 2012 at 10:47 PM, Veeru TOC veerub...@gmail.com wrote:
Dear Team
in excel file i know protect sheets but i need particular
Cells put the code or protect
Dear Prakash,
Please share a sample workbook with excel macro group
On Wed, Feb 8, 2012 at 8:04 PM, Prakash Gusain gusainprak...@gmail.comwrote:
I want to capture an image and save to specified location in system
using vba. Also need the file address in the active cell.
Thank you in
Hi
You can download ebooks from below links
- *Excel 2007 VBA Macro Programming*
http://www.mediafire.com/?9sl8iagf5e51144
- *Microsoft Office Specialist (MOS) 2010 Study Guide for Microsoft®
Excel*
http://www.mediafire.com/?bs2dpn9qbwhih0n
HTH
Mahesh
On Wed, Feb
How about putting the aa bb or cc in the cell manually and then having a
generic macro which would select whichever one you put.
Or could you just use the drop down arrow of the autofilter to get the same
effect faster and more efficiently.
On 9 February 2012 00:15, Mohammed Muneer
Hi All,
I know you can help me as many times before,so this time I'd like to ask you
for help with simple macro.
I'd like to do macro that will copy MASTER tab to the end of the tabs, but
this macro (will be perfect) if can ask user for week number,
and change name MASTER to week and the
Sub copysheetnameSAS()
Sheets(Master).Copy after:=Sheets(Sheets.Count)
ActiveSheet.Name = Week _
InputBox(Enter week NUMBER ie: 10)
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, February 08, 2012 5:01 PM
To: excel-macros@googlegroups.com
Don,
love it
thanks a lot
Pawel
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Wednesday, February 8, 2012 11:33 PM
Subject: Re: $$Excel-Macros$$ MASTER macro.
Sub copysheetnameSAS()
Sheets(Master).Copy
Btw, taking a bath or a shower every single minutes is such a
waste!!! even every day, in poor countries or our grand-parents from
the country side were more clean than what we can think we are today
with less water. I don't take a shower every single day if I had a
'quiet' day, just a soda can
Hi Noorain,
I'm getting error ... Can you please try your code and check?
thanks,
Amar
On 08/02/2012, Kasireddy Amarender kassi.re...@gmail.com wrote:
Thanks Noorain!
Simple and Superb!
On 08/02/2012, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Amarender,
Please use it..
You can use any excel file. I just want to trigger the webcam using
VBA. Hope you guys can help me provide the solution.
On Feb 8, 11:14 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Prakash,
Please share a sample workbook with excel macro group
On Wed, Feb 8, 2012 at 8:04 PM,
Hi
Have you tred mine ?
--
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 not be answered.
2)
Dear Darwin,
Plz see attached file.
is it ok?
From: Darwin Chan darwin.chankaw...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 9 February 2012 9:24 AM
Subject: $$Excel-Macros$$ Cstr function
Dear group,
Would like to ask how to use Cstr,
---
nitin arora wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-1bce156c49-49439e65f4-TjijJGrT3mGgSPg1dNIXfciG6S4
You'll
Hi,
I sent few mails to this group which have excel file attched to them. I
request you to please delete all my posts on priority from the group.
My email id is: nitinaror...@gmail.com
Regards,
Nitin Arora
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate
Hi Sanjib,
In your sample data u can do this by clicking to 'Data' tab in ur excel
sheet---Text To Colums--- Fixed width--Next--- Set the scale line as
per ur requirement--- finish
Do the necessary formatting as per ur requirement.
Find the attached sheet for ur review.
On Thu, Feb 9, 2012 at
Dear Group,
Please suggest any formula to pick next working date, but Saturday and Sunday
should not include.
Working day Next Working day
9-Feb-12 10-Feb-12
10-Feb-1213-Feb-12
Regards,
Shrinivas
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
Hi Shinivas,
=Workday(A2,1,0)
See the attached
On Thu, Feb 9, 2012 at 1:14 PM, Chidurala, Shrinivas
shrinivas.chidur...@citi.com wrote:
**
Dear Group,
Please suggest any formula to pick next working date, but Saturday and
Sunday should not include.
*Working day* *Next Working day*
48 matches
Mail list logo