Re: $$Excel-Macros$$ Right approach to learn macro coding

2011-10-26 Thread Mr excel
Ansari,your ppt is excellent.Nice tutorial for the beginners like me.Can You create more PPTS with some advanced VBA...Awaiting your reply. On Mon, Oct 24, 2011 at 1:20 PM, NOORAIN ANSARI wrote: > Dear Navdeep, > > Please find Excel VBA Basic PPT. > > > -- > Thanks & regards, > Noorain Ansari >

$$Excel-Macros$$ JOB

2011-10-26 Thread NOORAIN ANSARI
** *Experience:* 5 - 8 Years *Location:* Chennai *Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization *Industry Type:* IT-Software/ Software Services *Role:* Information Systems(MIS)-Mgr *Functional Area:* Systems, EDP, MIS *Posted Date:* 21 Oct Job Descripti

Re: $$Excel-Macros$$ Vlookup

2011-10-26 Thread Aamir Shahzad
*Done SAM*, wonderful thanks for your cooperation. I think I must have to save this add in file in save location for permanent use of this function is it? second this add in don't show in ribbon no problem but I saw that my friend create the add in and it shows in the ribbon with his multi commands

Re: $$Excel-Macros$$ Vlookup

2011-10-26 Thread Sam Mathai Chacko
No, do not create an xlsb. Create an xlam. The add it to the add-in list. Sam On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad wrote: > created as xlsb now tell me how to use, I mean how to use now > > Aamir Shahzad > > On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko wrote: > >> Aamir, I was ju

Re: $$Excel-Macros$$ Vlookup

2011-10-26 Thread Aamir Shahzad
created as xlsb now tell me how to use, I mean how to use now Aamir Shahzad On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko wrote: > Aamir, I was just checking, and found that I was wrong. You have to save a > file as an add-in for this to work. Create a new file, put the code in a new > modu

Re: $$Excel-Macros$$ Vlookup

2011-10-26 Thread Sam Mathai Chacko
Aamir, I was just checking, and found that I was wrong. You have to save a file as an add-in for this to work. Create a new file, put the code in a new module of that file, and save it as add-in (.xlam). Sam On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad wrote: > I am pasting SAM see attached fi

Re: $$Excel-Macros$$ Folder and sub index

2011-10-26 Thread Sam Mathai Chacko
Great. This this works well we the sub folders. Thanks for sharing Regards, Sam On Thu, Oct 27, 2011 at 1:24 AM, Haytham Zoromba wrote: > Have found attached file. > > > > On Wed, Oct 26, 2011 at 21:10, Haytham Zoromba > wrote: > >> But what about if i want to make it go in sub folders also ??

Re: $$Excel-Macros$$ Vlookup

2011-10-26 Thread Sam Mathai Chacko
Aamir, you have to past the code in the code module, not the workbook/sheet module Sam On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad wrote: > SAM - I am doing your instruction like this: > 1) In the blank new work book opening marco by shortkey. > 2) selecting personal workbook. Click ok > 3) t

Re: $$Excel-Macros$$ Vlookup

2011-10-26 Thread Aamir Shahzad
SAM - I am doing your instruction like this: 1) In the blank new work book opening marco by shortkey. 2) selecting personal workbook. Click ok 3) then going to VBE window. In the Personal Macro workbook & in the module after pasting your code then save then close. 4) after that in excel typing the

$$Excel-Macros$$ Require some free MIS template.....

2011-10-26 Thread Indrajit $nai
Hi All, Can some one provide me some MIS template, like production analysis, quality analysis (weekly, monthly and yearly basis)? It will be very helpful for me. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are co

Re: $$Excel-Macros$$ Folder and sub index

2011-10-26 Thread Haytham Zoromba
But what about if i want to make it go in sub folders also ??? On Wed, Oct 26, 2011 at 21:08, Haytham Zoromba wrote: > Supper, thanks > > Bregards, > Haytham > > > On Wed, Oct 26, 2011 at 21:01, Sam Mathai Chacko wrote: > >> Are you looking for this? >> http://www.excelfox.com/forum/showthread.

Re: $$Excel-Macros$$ Folder and sub index

2011-10-26 Thread Haytham Zoromba
Supper, thanks Bregards, Haytham On Wed, Oct 26, 2011 at 21:01, Sam Mathai Chacko wrote: > Are you looking for this? > http://www.excelfox.com/forum/showthread.php?196-List-Of-All-Files-In-A-Folder > > Regards, > > Sam Mathai Chacko (GL) > > > On Thu, Oct 27, 2011 at 12:27 AM, Haytham Zoromba <

Re: $$Excel-Macros$$ Folder and sub index

2011-10-26 Thread Sam Mathai Chacko
Are you looking for this? http://www.excelfox.com/forum/showthread.php?196-List-Of-All-Files-In-A-Folder Regards, Sam Mathai Chacko (GL) On Thu, Oct 27, 2011 at 12:27 AM, Haytham Zoromba wrote: > Dears, > > does any one know how to make an index of folder an its sub in excel??? > > -- > Regards

$$Excel-Macros$$ Folder and sub index

2011-10-26 Thread Haytham Zoromba
Dears, does any one know how to make an index of folder an its sub in excel??? -- Regards, Haytham Zoromba -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twi

Re: $$Excel-Macros$$ HAPPY DIWALI!!!!!!

2011-10-26 Thread NOORAIN ANSARI
कविता : मुबारक हो आप सब को ये दीपों का त्योहार.. माँ लक्ष्मी का नूर आपके उपर बरसे. हर कोई आप से लोन लेने को तरसे. आबाद रहे उजालों से आपका घर संसार. मुबारक हो आपको ये दीपों का त्योंहार. अम्बर से भी ऊँची हो आपकी प्रसिद्धी. दिन-दुनी रात चौगुनी हो आपकी समृधि. कभी खाली ना हो खुशियों से आपका खज़ाना. सला

Re: $$Excel-Macros$$ HAPPY DIWALI!!!!!!

2011-10-26 Thread Dilip Pandey
A very happy Diwali to all the Group members. Enjoy. :) Regards, DILIPandey On 26 Oct 2011 23:02, "xlstime" wrote: > Happy Diwali to all. > > On Wed, Oct 26, 2011 at 5:51 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> Dear Members, >> >> WISH YOU A HAPPY DIWAL

Re: $$Excel-Macros$$ HAPPY DIWALI!!!!!!

2011-10-26 Thread xlstime
Happy Diwali to all. On Wed, Oct 26, 2011 at 5:51 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Members, > > WISH YOU A HAPPY DIWALI. > > ALL THE BEST > > Regards, > > Sanjib > > -- > >

Re: $$Excel-Macros$$ Writing Code for creating pivot table

2011-10-26 Thread Darwin Chan
Dear Swapnil, I have tried itit works... Thanks a lot! Darwin 2011/10/26 Swapnil Palande > Hi, > > 1. It is not necessary to define range, I have define it to avoide using > Sheets("2011-10-26").Range("A1") every time in the code. > After defining range, instead of Sheets("2011-10-26").Ran

Re: $$Excel-Macros$$ HAPPY DIWALI!!!!!!

2011-10-26 Thread dguillett1
Read up on this. Sounds like Octoberfest would be more fun. I lived in Austria and Germany for 3 years. Don Guillett SalesAid Software dguille...@gmail.com From: Sanjib Chatterjee Sent: Wednesday, October 26, 2011 7:21 AM To: excel-macros Subject: $$Excel-Macros$$ HAPPY DIWALI!! Dear Memb

Re: $$Excel-Macros$$ HOW TO REPLY TO A POST

2011-10-26 Thread dguillett1
You just did. You are welcome Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: DanJ Sent: Tuesday, October 25, 2011 8:17 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ HOW TO REPLY TO A POST Sirs, Don Guillet did reply to my query re "HELP: SHOR

$$Excel-Macros$$ Wish you all a very happy Diwali

2011-10-26 Thread bholanathverma
Wish you all a very happy Diwali -- Thanks and Regards Bholanath_Verma Mobile:(P) +234 805 886 7891 (O) +234 702 911 9176 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

Re: $$Excel-Macros$$ unable to do any operation with this data

2011-10-26 Thread Sanjib Chatterjee
thank you very much it is working fine. thank to all the member to support me. regards, sanjib On Tue, Oct 25, 2011 at 7:32 PM, dguillett1 wrote: > I have this in my personal.xls file assigned to a custom button > Select your range and fire it > > Sub fixmynums() > Application.ScreenUpdati