Re: $$Excel-Macros$$ How to insert sheets name in cells

2010-05-24 Thread rf1234 rf1234
Hello Mahesh, So u have all files in a folder and u want macro to create the details... xls name date created...etc if it is ok,then let me know perhapes i can help you on this On Mon, May 24, 2010 at 3:43 PM, Mahesh wrote: > Dear All, > > I have around 200 xls files in a folder now i want

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread rf1234 rf1234
Hello Dear, I think this was not the topic of any issue.If in the group gaming posting is possible then it is also good that 1 can post the VBA Job, I am wonder if games on flash using excel can be post,then why the VBA Jobs not Let this,Because this has no logic,I remeber only that,

Re: $$Excel-Macros$$ need VB code for Excel Macro

2010-05-24 Thread Rahul Gandhi.
I think when you are sending the mails it will ask you to press Yes to continew and no to cancel. You have to download "Express Click yes" Software to automate the program, it is easily available in Internet. Regards, Rahul Gandhi. +91-9711772297. On May 22, 11:54 pm, Prem Narayan wrote: > hi

Re: $$Excel-Macros$$ How to insert sheets name in cells

2010-05-24 Thread Rahul Gandhi.
Mahesh, To Insert a Workbook Name, the Formula below formula will work =MID(CELL("filename"),FIND("[",CELL("filename")) +1,FIND("]",CELL("filename"))-FIND("[",CELL("filename"))-1) To insert the Sheet Name, the below formula will work: =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255) To

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread Chechu
I'm just one of the 7.000 group members, so I represent less than 0.01%. But in my opinion, if we are 7.000 members, is because this group day after day helps people to solve Excel / VBA questions and learn more on this topic. The focus is Excel and VBA Macros, as the group name says. If I was look

Re: $$Excel-Macros$$ Need macro help - Need to sort, cut and paste

2010-05-24 Thread Erick C
Hi Paul - I tried the code you provided without making any modifications and I had a few issues. Just for a bit of background: The file I am using for testing has 925 rows, 11 rows should be excluede since the dates in column T do not match column E. Txt file should have 914 rows of data. The mac

$$Excel-Macros$$ Need Help

2010-05-24 Thread qcan
Hi Group, I am not very knowledgable with VBA and would like some help solving a tedious problem. - I would like to copy and past each page contained on this URL into 1 spreadsheet (copy/paste 1st 50, then go to line 51 and do the same for the second 50 etc etc.. http://contests.covers.com/Handi

$$Excel-Macros$$ Macro to Filter All Sheets

2010-05-24 Thread Mahesh parab
Hi I have workbook consist of 4sheets I want to Autofilter each cell value in column A from sheet1 and same cell value will get Autofilter in sheet2, sheet3, sheet4 also i got below mention code on net but it autofilter only particular Criteria in all sheets i want to Autofilter each value from sh

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread Venkatesan c
Dear Ayush, Good show Best Regards, * Venkat * On Mon, May 24, 2010 at 9:00 AM, Ayush wrote: > Dear Group Members, > > Finally, after long time we have achieved a milestone of 7000 > members. > > I would use this moment to thank each one of you for your contribution > to the group. This gro

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread Harpreet Singh Gujral
I have a mixed feeling about posting Job openings to this group, on one hand i would agree with Paul that, the core idea of the group may be defeated in the long run. I think a related group can be started, where in those who are core VBA programmers or simply programmers can join and post job ope

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread Aindril De
Hi All Members Congrats to all and specially Ayush..for managing it so beautifully!!! Also to all active members.. who have selflessly kept this group going.. Looking forward for more and more achievements Cheers!!, Andy On Mon, May 24, 2010 at 8:26 PM, Indrajit $nai wrote: > Hi > All Grou

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread Indrajit $nai
Hi All Group Members, Really it's a great achievement, truly I am very happy to be a part of this "Group", last but not the least *"A very Special Thanks to AYUSH"*. -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread Suryaprasad
Hey, Thats wonderfull. Ayush, You are the best. Thanks Surya On Mon, May 24, 2010 at 9:00 AM, Ayush wrote: > Dear Group Members, > > Finally, after long time we have achieved a milestone of 7000 > members. > > I would use this moment to thank each one of you for your contribution > to the gr

$$Excel-Macros$$ Lotus Notes scheduled Future mails Help

2010-05-24 Thread Venkatesan c
Dear Group I am using Lotus notes 7. I want send scheduled Future mails is there sending Option else any tolls please send it to me. Best Regards, * Venkat * -- -- Some important links for excel users: 1. Follow

Re: $$Excel-Macros$$ Help breaking out data on single worksheet to multiple worksheets

2010-05-24 Thread Paul Schreiner
so... you're wanting the data copied to new WORKBOOKS not sheets (as you said in your first message) makes sense. I'll see what I can do. basing it on a specific column is fairly easy. what I'll do is sort it by column A, then copy the data to a new workbook until the value in "A" changes. I

Re: $$Excel-Macros$$-Macro to Prepare Letters

2010-05-24 Thread Atul Kesaria
> Hello Team, > > I am using macro for mail merge and wanna know how to make changes in font > type and how to bold a particular line/word while doing mail merge. > > Can you please help me. > Thanks and Regards Atul Kesaria -- ---

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread Paul Schreiner
I understand that also. but writing and debugging macros is separate from job searching. I'm just saying that it's one thing to discuss something that is "Off Topic" as long as it relates to the purpos of the User Group. If I were to search for a new job, I would look for groups designed for that

$$Excel-Macros$$ How to insert sheets name in cells

2010-05-24 Thread Mahesh
Dear All, I have around 200 xls files in a folder now i want to make an index of all these files into a new file(xls). Need ur hepl. -- With Love, Mahesh Bisht -- -- Some important links for excel users: 1. Follow

$$Excel-Macros$$ how can use excel funcations in user form texrboxes?

2010-05-24 Thread memonkavi
hello sir help following issue thanks memon how can use excel funcations in user form texrboxes? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread Shivam Shukla
Experience 2 - 5 Years Industry Type KPO / Research /Analytics RoleOutside Consultant Functional Area ITES/BPO/KPO, Customer Service, Ops. Education UG - B.Tech/B.E. - Any Specialization, Electrical, Electronics/Telecomunication PG - M.A - Economics, Maths, Statistics,M.Sc

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread Shreedar Pandurangaiah
Dear All, this is amazing...I truly appreciate everyone's continued effort. Thanks again, Shreedar On Mon, May 24, 2010 at 12:55 PM, sudhir kumar wrote: > Hi > all Group members, > > Thanks for joining this group and countined with us and > very special thanks to Ayush. > > > Sudhir Verma > > >

Re: $$Excel-Macros$$ Congratulations : We are 7000 today

2010-05-24 Thread sudhir kumar
Hi all Group members, Thanks for joining this group and countined with us and very special thanks to Ayush. Sudhir Verma Ayush Thanks for managing On 5/24/10, Ayush wrote: > > Dear Group Members, > > Finally, after long time we have achieved a milestone of 7000 > members. > > I would use t

Re: $$Excel-Macros$$ Need formula to get the desired cell content.

2010-05-24 Thread Maries
Hello Vinod, Find the attached file.. I hope that, this will help you.. Thanks Regards, Maries On Fri, May 21, 2010 at 5:16 PM, Vinu wrote: > Hello, > I have 2 sheets. In one sheet I have a dump data where I will filter based > on requiremets(only first colounm i.e, country is only one f

Re: $$Excel-Macros$$ Post VBA Jobs for Our Group Members

2010-05-24 Thread kavita ahuja
There is job for VBA programmer with atleast 2 yrs of experience in WNS, gurgaon. Regards Kavita On Fri, May 21, 2010 at 1:15 PM, rf1234 rf1234 wrote: > Dear All, > We are here in this beautiful group,where every one is giving the > Helping Hand to Others. > Really Appreciated,I want to add ju