Please give me program which can add/subtract/multiply/divide numbers
in macros.
Regards
Paresh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA
Hi Amit..
I can help you if you send me your excel file and also mdb file so, I
will create VBA project as per your requirement.
Feel fee to contact me.
On Apr 25, 2:33 pm, Amit amits.he...@gmail.com wrote:
Hi,
I wan to write data to an existing (with required tables) MDB from
Hi Amit..
I can help you if you send me your excel file and also mdb file so, I
will create VBA project as per your requirement.
Feel fee to contact me.
On Apr 25, 2:33 pm, Amit amits.he...@gmail.com wrote:
Hi,
I wan to write data to an existing (with required tables) MDB from
Hi Jayesh,
I've got some ebooks on Excel. If you need them you can have them. In
case you have specific querries all the forum is here to help you.
Regards,
Anand
On Apr 26, 9:44 pm, Aindril De aind...@gmail.com wrote:
Hi Jayesh,
Could you please elaborate your exact problem please
Hi All,
Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
lessons start your VBAmacros.
Thanks
SK
--~--~-~--~~~---~--~~
-
Some important links for excel users:
Hi SK, Could not find it could you send a direct link..
Regards,
Andy
On Mon, Apr 27, 2009 at 4:07 PM, Suyog nashi...@gmail.com wrote:
Hi All,
Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
lessons start your VBAmacros.
Thanks
SK
Hi Abdul,
To prepare for MCAS Exam Preparation, you may go through Microsoft
published books and articles. Try sample exams, you may find them on
search engines. Fee Structure is flat $50.
For running offers and discounts, please visit
http://www.prometric.com/microsoft
Regards
Ashish Jain
Hi Sachin,
To Learn VBA or any other thing, follow this simple rule.
Learn and Practice
Yes, you'll make mistakes but that's how we learn. Explore the
discussions, try to solve other users queries, read online articles,
books suggested on www.excelitems.com . and gradually you'll be an
expert.
Hi Jayesh,
Here is a good reference on How to use Lookup methods?
http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
On Apr 25, 2:37 pm, Jayesh
Hi,
can u send me the link...
Regards,
Girish
On 4/27/09, Aindril De aind...@gmail.com wrote:
Hi SK, Could not find it could you send a direct link..
Regards,
Andy
On Mon, Apr 27, 2009 at 4:07 PM, Suyog nashi...@gmail.com wrote:
Hi All,
Refer uploaded VB 33 lesson (39).doc for
Hi Satish,
Try Merge Worksheets command. It's located in Sheet Utils --
Merge Worksheets of Open XL addin available free on
http://www.excelitems.com
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
On Apr 23,
I've been using these formulas to sort some values and return
results
I would like to combine these 2 into one formula
=IF(AND(ISNUMBER(FIND(LEFT(B20368,1),JCR)),IF(SUM(COUNTIF(C20368,
{DST,LVN,DNM}))0,TRUE(),FALSE())),I20368-0.01,J20368)
=IF(OR(AND(B20368, ISNUMBER(FIND(LEFT(B20368,1),
Hi,
You can use:
=IF(C8C7,1,0)
regards!
2009/4/27 Mayank Patel mkpat...@gmail.com
Dear Friends
Please suggest the formula.
sample file is attached.
Thanks to all in Advance
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
--
Fabio L Lemos
email: flnle...@gmail.com
It was a nice query...
See attached file it has the solution...
On Mon, Apr 27, 2009 at 7:01 PM, Fabio Lemos flnle...@gmail.com wrote:
Hi,
You can use:
=IF(C8C7,1,0)
regards!
2009/4/27 Mayank Patel mkpat...@gmail.com
Dear Friends
Please suggest the formula.
sample file is
I think u need to be more specific.
Sorry, I couldn't get ur query.
On Mon, Apr 27, 2009 at 6:20 PM, H Upadhyay harishcupadh...@gmail.comwrote:
Dear All,
Need ur help, pls suggest how can i create code for Solver
Regards
Harishh Upadhyay
9773284902
--
Thanks Regards,
Harmeet
Hi All,
Using attached tool you can open all the files from a given location.
Warren, u can have reference from it.
Thanks.
On Mon, Apr 27, 2009 at 6:28 PM, Ashish Jain 26may.1...@gmail.com wrote:
Hi Gremlin,
You're doing right, except using the Chdir.
There is No need of it. You may
Hi all,
I have a workbook with three worksheets in them (AOB,WW,CST).
Each of the worksheet have 20 variables.
I want to use them all in sas.But it is easier to process if all the
variables are converted to character type.
I manually change the data type beofre uploading them into sas.
Can you
Hi Ashish,
I must say, Its a killer tool. Keep up the good work buddy.
U r simply Awesome.
What do u all say.?
On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain 26may.1...@gmail.com wrote:
If you want to do any or all of the following. Visit
http://www.excelitems.com
and
To create folder use ---MkDir C:\HHH
To get the file path use -- filepath=application.getopenfilename
On Mon, Apr 27, 2009 at 5:19 PM, Mathan mathan4s...@gmail.com wrote:
*Hi All,*
**
*1. How to create a folder and other documents with macro in desktop.. ?*
*2. How to get a
Hi all,
I'm pretty new to this type of coding in vba.
I'm trying to write a code that works within a simple range to perform
calculations based on which cell is being inputted into within that
range. It should work just like this website
http://www.engnetglobal.com/tips/convert.asp?catid=15
Hey Ashish.
Hi! Doing a Good Job ! Please keep it up..
The link u have sent doesnt seem to be working. I am unable to open. can u
please recheck the sent link!
Thanks / Rgds,
Aakash..
--- On Mon, 4/27/09, Ashish Jain 26may.1...@gmail.com wrote:
From: Ashish Jain 26may.1...@gmail.com
Dear Fabio Lemos,
I appreciate your solution to the Query but may i know the logic of this
formula how it works plzzz
*=IF(C8C7,1,0) - Explain this plz*
Regards
Ahmed
On Mon, Apr 27, 2009 at 4:31 PM, Fabio Lemos flnle...@gmail.com wrote:
Hi,
You can use:
=IF(C8C7,1,0)
Hi Ashish,
Can this ADD in be used with Excel 2000.
If not do have the one which can be used eith Excel 2000 as i feel it is
really helpful tool.
and
Thanks for sharing this ADD In with every one
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain
Hi Ashish,
Can this ADD in be used with Excel 2000.
If not do u have the one which can be used with Excel 2000 as i feel it is
really helpful tool.
and
Thanks for sharing this ADD In with every one
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Mon, Apr 27, 2009 at 6:57 PM, Ashish Jain
Dear Friends,
I Sincerely appreciate your suggestions. But i think in both the solutions
in column C is taken in to consideration Nowhere Data in the column B is
considered. My problem is little complicated. it is not necessary that the
same values will come next to each other, and i want the
Hi,
Check the attached formula this works only if the Sub Cat is sorted
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Mayank Patel
Sent: 27 April 2009 06:54 pm
To: excel-macros@googlegroups.com
Subject:
Really Good
shrinivas
Date: Mon, 27 Apr 2009 20:28:26 +0530
Subject: $$Excel-Macros$$ Re: !!URGENT!! Formula Required Please HELP
From: harmeet.hew...@gmail.com
To: excel-macros@googlegroups.com
CC: mkpat...@gmail.com
It was a nice query...
See attached file it has the
27 matches
Mail list logo