>From where can we download VB 33 lesson (39).doc ?
On Mon, Apr 27, 2009 at 2:37 PM, Suyog wrote:
>
>
> Hi All,
>
> Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
> lessons & start your VBAmacros.
>
> Thanks
> SK
>
> >
>
--~--~-~--~~~---~--~
Thanks to all,
A Good news, Me and Ayush, planned to launch it for Excel 2003 (not
for any other previous versions).
It will be soon available to group members.
Please make a note Humans take a step forward, that's how
civilizations grows. This means no support and updates will be
available for
Dear Aindril,
Thanks for ur help,
but this formula is not giving desired result. please try again.
Thanks Again
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Tue, Apr 28, 2009 at 8:55 AM, Aindril De wrote:
> Dear Mayank,
>
> You seemed to be almost on track with the formula you had wr
Dear Ashish,
Is there any version which is compatible with Excel 2003 as i am using Excel
2003.
Best Regards,
Jitendra Kumar
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 Down
Hello Ashish,
Thanks you very much for the link , Appreciate your prompt reply
Thanks & Regards
Jayesh Joshi
--- On Mon, 27/4/09, Ashish Jain <26may.1...@gmail.com> wrote:
From: Ashish Jain <26may.1...@gmail.com>
Subject: $$Excel-Macros$$ Re: Want help on Lookup and pivot tables
To: "MS EXCEL
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 solution.
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: $$Excel-Ma
Dear All Groupmembers,
I want to prepare an index sheet which will contain the name of all the
sheets and their (continuous) page numbers (given in footer). The index
should be able to update on any insertion of new sheet or on deletion of
any. Further the page numbers should also be updated
Dear Mayank,
You seemed to be almost on track with the formula you had written, however
you have to add the trick of finding duplicates on the same formula.
I have updated the formula and it seems to be working properly now.
=IF(OR(OR(AND(C8=C9,C8<>C7),AND(C8<>C9,C8<>C7)),OR(COUNTIF($B$8:B8,B8)=
Hi,
You can find the solution in the attached file. Try putting the values in
input-range to see the effect.
Hope it helps.
Akhilesh Kumar Karna
On Tue, Apr 28, 2009 at 12:13 AM, Urrutia wrote:
>
> Hi all,
>
> I'm pretty new to this type of coding in vba.
> I'm trying to write a code that wor
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 resu
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
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 <2
Dear Fabio Lemos,
I appreciate your solution to the Query but may i know the logic of this
formula how it works plzzz
*=IF(C8<>C7,1,0) <- Explain this plz*
Regards
Ahmed
On Mon, Apr 27, 2009 at 4:31 PM, Fabio Lemos wrote:
> Hi,
> You can use:
>
> =IF(C8<>C7,1,0)
>
> regar
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>
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
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 wrote:
> *Hi All,*
> **
> *1. How to create a folder and other documents with macro in desktop.. ?*
> *2. How to get a files as input fil
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 D
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 he
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 m
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 wrote:
> Dear All,
>
> Need ur help, pls suggest how can i create code for Solver
>
> Regards
> Harishh Upadhyay
> 9773284902
>
> >
>
--
Thanks & Regards,
Harmeet Singh
--~--~--
It was a nice query...
See attached file it has the solution...
On Mon, Apr 27, 2009 at 7:01 PM, Fabio Lemos wrote:
> Hi,
> You can use:
>
> =IF(C8<>C7,1,0)
>
> regards!
>
> 2009/4/27 Mayank Patel
>
>> Dear Friends
>>
>> Please suggest the formula.
>> sample file is attached.
>>
>> Tha
Hi All,
Here is the Link
http://excel-macros.googlegroups.com/web/VB+33+lesson+(39).doc
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
--
On Apr 27, 4:47 pm, girish gv wrote:
> Hi,
>
> can u send me t
Hi,
You can use:
=IF(C8<>C7,1,0)
regards!
2009/4/27 Mayank Patel
> 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
--~
If you want to do any or all of the following. Visit http://www.excelitems.com
and Download Open XL.
1. Run Charts Slideshow
2. Calculate Business Working Days
3. Sort Worksheets
4. Merge Worksheets
5. Superhide a worksheet
6. Copy Multiple Selections
7. Learn VBA/VSTO
8. Copy Worksheets to MS
Dear Friends
Please suggest the formula.
sample file is attached.
Thanks to all in Advance
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
--~--~-~--~~~---~--~~
-
Some import
Dear All,
Need ur help, pls suggest how can i create code for Solver
Regards
Harishh Upadhyay
9773284902
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and
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(B2036
Hi Gremlin,
You're doing right, except using the Chdir.
There is No need of it. You may directly use Workbooks.Open ..
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
On Apr 14, 3:50 am, CF_Gremlin wrote:
> I
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 Ap
*Hi All,*
**
*1. How to create a folder and other documents with macro in desktop.. ?*
*2. How to get a files as input file through a user form?*
**
*pls give me examples.*
--~--~-~--~~~---~--~~
---
Hi,
can u send me the link...
Regards,
Girish
On 4/27/09, Aindril De 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 wrote:
>
>>
>>
>> Hi All,
>>
>> Refer uploaded VB 33 lesson (39).doc for new comers. Refer a
Hi Jake,
He is right and I won't say that it's absolutely impossible.
Using VBA only it's pretty not possible. By Overriding the
the function's class in a specific dll, you can do so.
But for that you should be aware of the dll name, class name
and the knowledge of API Prog. and building+deployin
Hi Karan,
If you're accessing the forums directly on web then you can't attach
the files with the message. But if you're accessing group via email
subscription then you can attach files as you does normally with your
e-mail client.
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
---
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 Joshi
Superb Aindril - Hats Off !!! Keep enjoying the queries :)
Regards
Ashish Jain
Developer of OpenXL
On Apr 27, 3:39 pm, Aindril De wrote:
> Hi Paresh,
>
> 1. 1st open a new workbook, Alt+F11 go to vba editor, on the left side
Hi,
Can you please explain a bit more? Since your question can have many
answer. Whether you want to scan a CSS or HTML? Do you want to create
a table of all attributes and their corresponding values? Do you want
to create a CSS/HTML using Excel table? Please clear the smoke flowing
over your pro
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 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
www.e
Hi Paresh,
1. 1st open a new workbook, Alt+F11 go to vba editor, on the left side,
right click on a icon and choose insert userform, when click on this
userform toolbox of controls appear, click the textbox button and click and
drag a rectangle on the userform to create an entry box, create anothe
Hi Anand,
It would be great if you could send me the e book on excel..
Many Thanks,
Pranay Asera
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of anandydr
Sent: Monday, April 27, 2009 2:43 PM
To: MS EXCEL AND VBA MACROS
Subject:
Hi SK, Could not find it could you send a direct link..
Regards,
Andy
On Mon, Apr 27, 2009 at 4:07 PM, Suyog wrote:
>
>
> Hi All,
>
> Refer uploaded VB 33 lesson (39).doc for new comers. Refer all 33
> lessons & start your VBAmacros.
>
> Thanks
> SK
>
> >
>
--~--~-~--~~
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 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 wrote:
> Hi Jayesh,
>
> Could you please elaborate your exact problem please
>
> Regards,
> Andy
>
>
Dear All,
I want to learn VBA in excel. Please help me.
Thanks
Sachin Shukla
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and T
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 wrote:
> Hi,
>
> I wan to write data to an existing (with required tables) MDB from
> Excel 2003/2007 h
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 wrote:
> Hi,
>
> I wan to write data to an existing (with required tables) MDB from
> Excel 2003/2007 h
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 Tutor
48 matches
Mail list logo
