Re: $$Excel-Macros$$ Need Formula- Very Very Urgent
Thanks Noorain, for your Quick Help. but actually my requirement is Formula, is there any inbuilt formula or combination of inbulilt formulas?? On Mon, Sep 5, 2011 at 9:09 PM, Intelligent But Crazy wrote: > > Dear Group, > > Is there any formula which can give the count of alphabets in a cell > without space & special characters ? > -- > Pankaj Pandey > Bhopal > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Help with Pivot Table
Dear Ashish, Pls help, Whenever i am creating a pivot table in Excel 2007 and using some calculated fields into that, after that if i am saving that file into Excel 2003, so all the pivots are getting past special automatically. Pls help with this issue, -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Help on TL Recital Snapshot
Hi Noorain, This is a Very good Solution. But i am unable to edit this array. can you pls tell me if i want to use this same concept of array in any other file so how can do this. please give me some more detail about using array formula in excel. On Fri, Mar 18, 2011 at 10:51 AM, NOORAIN ANSARI wrote: > Dear Lucky, > > Please see attached sheet.. > > Rgds, > Noorain Ansari > > On Thu, Mar 17, 2011 at 3:48 PM, lucky singh wrote: > >> >> Hi Team, >> >> need your help on the attached file on sheet one.. >> >> >> need a summary TL wise on sheet one... >> >> >> Thanx & Regards, >> Lucky >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & regards, > Noorain Ansari > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Merry Christmas & Happy new year...
Any Body have the cards for New Year too. IF yes to Olease share. Regards Pankaj k Pandey On 12/25/10, renuka chari wrote: > GOOD & GREAT "X" - MAS > > On Dec 24, 3:47 pm, Venkat wrote: >> Hi Lucky, >> >> Find attached >> >> Best Regards, >> >> Venkat Cv >> >> On Fri, Dec 24, 2010 at 11:15 AM, lucky singh >> wrote: >> >> > Hi Guys, >> >> > Do anyone has a excel greetings for Christmas or new year... >> >> > plz do forward. >> >> > Thanx in advance, >> > Regards, >> > Lucky >> >> > -- >> >> > ------ >> > Some important links for excel users: >> > 1. Follow us on TWITTER for tips tricks and links : >> >http://twitter.com/exceldailytip >> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 >> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> > To post to this group, send email to excel-macros@googlegroups.com >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> > Like our page on facebook , Just follow below link >> >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... >> >> -- >> *Best Regards,* >> *Venkat* >> ) 91 99414 31925 >> >> r1s.swf.xls >> 2106KViewDownload >> >> rs.swf.xls >> 493KViewDownload > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Ayush Jain – Microsoft MVP 20 10
Hi Ayush, Congrates for this status. We all are very happy to listen this.. Regards Pankaj k Pandey On Sun, Oct 3, 2010 at 3:47 PM, Ayush wrote: > Dear Group, > > I am proud to announce that I am awarded Microsoft Most Valuable > Professional MVP on October 01, 2010 for providing technical expertise > in Excel technical communities for past one year. > > > http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx > > This is a prestigious award from Microsoft given every Quarter to the > people who share their deep knowledge, real-world experience, and > impartial, objective feedback to help people enhance the way they use > technology. > > My deep thanks to each group member for all your support and > contribution to this group. > > Best regards, > Ayush Jain > Microsoft MVP > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ How to create Speedometer chart in Excel
Hi Experts, -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ secrets...@gmail.com
Hi Expert, thank you so much for your help, it solve my 90% of problem, but actually i have aprox 60 charts in my dashboard. so for this is there any comman macro, otherwise i have to write 60 macro, to assing each macro to every chart. Pls help Regards Pankaj k Pandey On Tue, Aug 31, 2010 at 3:13 PM, STDEV(i) wrote: > -- Forwarded message -- > From: siti Vi > Date: Tue, Aug 31, 2010 at 4:24 PM > Subject: Re: $$Excel-Macros$$ secrets...@gmail.com > To: excel-macros@googlegroups.com > > > Sub ZoomChart1() > Static zoomIn As Boolean > ActiveSheet.ChartObjects("Chart 1").Activate > ActiveChart.ChartArea.Select > > With ActiveSheet.Shapes("Chart 1") > If zoomIn Then >.ScaleWidth 0.5, msoFalse, msoScaleFromTopLeft >.ScaleHeight 0.5, msoFalse, msoScaleFromTopLeft >zoomIn = False > Else >.ScaleWidth 2, msoFalse, msoScaleFromTopLeft >.ScaleHeight 2, msoFalse, msoScaleFromTopLeft >zoomIn = True > End If > End With > ActiveSheet.Range("A1").Activate > End Sub > > > On Tue, Aug 31, 2010 at 11:23 AM, Intelligent But Crazy > wrote: > > Hi Group, > > I need your expertise in one of my advance Excel Dashboard. > in > > sample Excel sheet there are Two Excel Chart, I required when my mouse > > courser got focus on chart 1 so it's show in zoom. and when my mouse > > courser lost focus from chart 1 so its show in normal form. same happen > with > > chart 2. > > > > Please help me out with this query, & kindly treat it as urgent basis. > > > > Thanks in advance, > > -- > > Pankaj Pandey > > Bhopal > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Need your expertise in Advance Excel
Hi Group, I need your expertise in one of my advance Excel Dashboard. in sample Excel sheet there are Two Excel Chart, I required when my mouse courser got focus on chart 1 so it's show in zoom. and when my mouse courser lost focus from chart 1 so its show in normal form. same happen with chart 2. Please help me out with this query, & kindly treat it as urgent basis. Thanks in advance, -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample File..xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ secrets...@gmail.com
Hi Group, I need your expertise in one of my advance Excel Dashboard. in sample Excel sheet there are Two Excel Chart, I required when my mouse courser got focus on chart 1 so it's show in zoom. and when my mouse courser lost focus from chart 1 so its show in normal form. same happen with chart 2. Please help me out with this query, & kindly treat it as urgent basis. Thanks in advance, -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Sample File..xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Required Urgent Help In VBA...........
Hi Experts Pls Help Mee Regards Pankaj k Pandey On 8/20/10, Intelligent But Crazy wrote: > hi Experts, > > I m working on a project, I required a help that in > Audit form if any one click on Submmit button so first it check thatis > there any box left blank, if yes so a Errorbox appaier, other wise > contenue with the programming. > > Pls help me for this.. > > File Attached for refrence > > in waiting of your Reply > Pankaj k Pandey > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent: Help required in VBA form
Thanks a lot Krisnan It is working. I really appricieat your knowladge, I m glade to get help from you. Regards Pankaj k PAndey On 8/5/10, Kishan Reddy, K wrote: > Try this, > > But check it may have adverse effects, > > Private Sub CommandButton2_Click() > UserForm1.Show 0 > End Sub > > Also check for help on SHOW method ( modal/nonmodal forms). > > Share with me if you have any problems > > Bye, > > Kishan Reddy, K > kishanreddy.kethire...@gmail.com > > > On Aug 5, 6:38 am, Intelligent But Crazy wrote: >> Hi Dav, >> >> First of all congrats, I request you to pls help me in >> this problem, my whok project n promotion is now only depands on this. >> >> I m waitinig for your reply. >> >> Regards >> Pankaj k Pandey >> >> On 8/4/10, Intelligent But Crazy wrote: >> >> >> >> > My Apologiese >> >> > Pls find the Password details. >> >> > For Workbook: bads...@143 >> >For VBA Editor : bads...@143 >> >For Worksheets : SecretShot >> >For Mastersheet : SecretShot >> >> > Pls help me in this. >> >> > Thanks >> > Pankaj k Pandey >> >> > On 8/3/10, Intelligent But Crazy wrote: >> >> Hi group, >> >> >> My self pankaj, >> >> currentally I m working on a project, I have created a Excel VBA form >> >> for quality analysis, but i m facing a problem that when the VBA form >> >> is open in this Excel so i m unable to activate any onather Excel >> >> file. >> >> Pls help me in this only because of this my whole project will be >> >> useless. >> >> >> Excel file is attech for refarence. >> >> >> Thanks >> >> Pankaj k Pandey >> >> >> -- >> >> -- >> >> Some important links for excel users: >> >> 1. Follow us on TWITTER for tips tricks and links : >> >>http://twitter.com/exceldailytip >> >> 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 >> >> 3. Excel tutorials athttp://www.excel-macros.blogspot.com >> >> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> >> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> >> <><><><><><><><><><><><><><><><><><><><><><> >> >> HELP US GROW !! >> >> >> We reach over 7000 subscribers worldwide and receive many nice notes >> >> about >> >> the learning and support from the group.Let friends and co-workers know >> >> they >> >> can subscribe to group at >> >>http://groups.google.com/group/excel-macros/subscribe >> >> > -- >> > Pankaj Pandey >> > Bhopal >> >> -- >> Pankaj Pandey >> Bhopal > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent: Help required in VBA form
Agreed with your point, but i want that if i required so i can only see any other Excel file while opening a Form. I dont want to do any thing on that file just want to see for refrence. Kindly suggest Regards Pankaj k Pandey On 8/5/10, Intelligent But Crazy wrote: > Hi Dav, > > First of all congrats, I request you to pls help me in > this problem, my whok project n promotion is now only depands on this. > > I m waitinig for your reply. > > > Regards > Pankaj k Pandey > > > On 8/4/10, Intelligent But Crazy wrote: >> My Apologiese >> >> Pls find the Password details. >> >> For Workbook: bads...@143 >>For VBA Editor : bads...@143 >>For Worksheets : SecretShot >>For Mastersheet : SecretShot >> >> >> >> Pls help me in this. >> >> Thanks >> Pankaj k Pandey >> >> On 8/3/10, Intelligent But Crazy wrote: >>> Hi group, >>> >>> My self pankaj, >>> currentally I m working on a project, I have created a Excel VBA form >>> for quality analysis, but i m facing a problem that when the VBA form >>> is open in this Excel so i m unable to activate any onather Excel >>> file. >>> Pls help me in this only because of this my whole project will be >>> useless. >>> >>> >>> Excel file is attech for refarence. >>> >>> Thanks >>> Pankaj k Pandey >>> >>> -- >>> -- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 7000 subscribers worldwide and receive many nice notes >>> about >>> the learning and support from the group.Let friends and co-workers know >>> they >>> can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >> >> >> -- >> Pankaj Pandey >> Bhopal >> > > > -- > Pankaj Pandey > Bhopal > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent: Help required in VBA form
Hi Dav, First of all congrats, I request you to pls help me in this problem, my whok project n promotion is now only depands on this. I m waitinig for your reply. Regards Pankaj k Pandey On 8/4/10, Intelligent But Crazy wrote: > My Apologiese > > Pls find the Password details. > > For Workbook: bads...@143 >For VBA Editor : bads...@143 >For Worksheets : SecretShot >For Mastersheet : SecretShot > > > > Pls help me in this. > > Thanks > Pankaj k Pandey > > On 8/3/10, Intelligent But Crazy wrote: >> Hi group, >> >> My self pankaj, >> currentally I m working on a project, I have created a Excel VBA form >> for quality analysis, but i m facing a problem that when the VBA form >> is open in this Excel so i m unable to activate any onather Excel >> file. >> Pls help me in this only because of this my whole project will be >> useless. >> >> >> Excel file is attech for refarence. >> >> Thanks >> Pankaj k Pandey >> >> -- >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes >> about >> the learning and support from the group.Let friends and co-workers know >> they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > > -- > Pankaj Pandey > Bhopal > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Urgent: Help required in VBA form
My Apologiese Pls find the Password details. For Workbook: bads...@143 For VBA Editor : bads...@143 For Worksheets : SecretShot For Mastersheet : SecretShot Pls help me in this. Thanks Pankaj k Pandey On 8/3/10, Intelligent But Crazy wrote: > Hi group, > > My self pankaj, > currentally I m working on a project, I have created a Excel VBA form > for quality analysis, but i m facing a problem that when the VBA form > is open in this Excel so i m unable to activate any onather Excel > file. > Pls help me in this only because of this my whole project will be useless. > > > Excel file is attech for refarence. > > Thanks > Pankaj k Pandey > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to chenge Form Stlye in VBA
hi Group, Can any one help me, to know that how can we chenge Form Stlye in Excel VBA. Currentaly it show a classical look. can i convert it into any onather look (like std or window look). Sample file attech for refrence Pls help -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe New File.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Import Data into excel from notepad
Hi Ashish, Thanks for the Help, It's really too helpfull for me, But could you give just one more favour, I Imported the data on Excel N data comes in N numbers of sheet, now I want to "Text to Colunm" of First colunm (A:A) of every sheet so what the changes I have to do in that macro. In waiting of your Help Pankaj k Pandey On 6/10/10, ashish koul wrote: > run it select the notepad file and click on ok > > > > On Thu, Jun 10, 2010 at 9:59 AM, Mahesh wrote: > >> Hi Ashish, >> >> Thank for the codes but i m not able to use them, >> >> Can u give my the process how to start and how to end the same. >> >> >> >> On Tue, Jun 8, 2010 at 7:14 PM, ashish koul wrote: >> >>> ub importnotepaddata() >>> On Error GoTo xdd >>> >>> Dim FileName As String >>> FileName = Application.GetOpenFilename("Text Files (*.txt),*.txt", , >>> "Please select text file...") >>> Dim i As Long >>> i = 1 >>> Set objFSO = CreateObject("Scripting.FileSystemObject") >>> Set objFile = objFSO.OpenTextFile(FileName, 1) 'Change the Path to your >>> text file >>> >>> Do Until objFile.AtEndOfStream >>> strLine = objFile.ReadLine >>> If strLine <> "" Then >>> Cells(i, 1) = strLine >>> >>> i = i + 1 >>> If i = 1048575 Then >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> ' INSERTING A NEW SHEET >>> >>> Sheets.Add After:=Sheets(Sheets.Count) >>> >>> i = 1 >>> >>> >>> >>> >>> >>> End If >>> >>> >>> End If >>> Loop >>> >>> objFile.Close >>> Set objFSO = Nothing >>> xdd: >>> Exit Sub >>> >>> End Sub >>> >>> >>> On Tue, Jun 8, 2010 at 3:09 PM, Mahesh wrote: >>> thanks for ur reply but i have around or more than 17 lacs record. What i want is a macro ro code which automatically move the rest record (next 7 lacs) to next sheet in the workbook. On Tue, Jun 8, 2010 at 1:50 PM, pankaj kumar wrote: > (to fileopen)...cmnd will solve d prob > > > On Mon, Jun 7, 2010 at 8:50 PM, Mahesh wrote: > >> Dear All, >> >> Need your help on below mention issue. >> >> I have a notepad file which contains more than 10 lacs records. >> >> Can anyone give me a solution, how to open it in excel? >> >> -- >> With Love, >> Mahesh Bisht >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and >> co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 7000 subscribers worldwide and receive many nice notes > about the learning and support from the group.Let friends and > co-workers > know they can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- With Love, Mahesh Bisht -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes
Re: $$Excel-Macros$$ Macro to send emails using excel list *
Hi Mahesh, Thanks a lot, this is working fine now. i m great full to you. could you pls give me one more help. i want to use check names option in outlook. so what code should i use in this macro. Thanks Pankaj k Pandey On 5/18/10, Mahesh parab wrote: > Hi > > You can do below mention changes to add CC,BCC in mail > .To = Cells(cell.Row, "D").Value > .CC = Cells(cell.Row, "E").Value > .BCC = Cells(cell.Row, "F").Value > > change the column name as per your requirement. > if you want to add yesterday's date in boday of mail then you can use below > mention code > .Body = (Date - 1) > > or you can link cell value in body of mail. forrmula in column Q will be > =today()-1 in excel sheet > & vbNewLine & vbNewLine & Cells(cell.Row, "Q").Value & _ > > if you still have doubts write back or you can send sample sheet. > > On Mon, May 17, 2010 at 1:08 AM, Intelligent But Crazy > wrote: > >> Intelligent But Crazy (secrets...@gmail.com) was added to your Guest >> List<https://www.boxbe.com/approved-list>by their request | Delete >> this >> guest<https://www.boxbe.com/anno?action=remove&tc=2806636259_589131336>| >> [image: >> Boxbe] <https://www.boxbe.com/overview> >> >> Hi Mahesh, >> >>Thanks a lot for this help, this is really too >> helpfull for all outlook users. >> I also want to know that if i have to add CC or BCC in mail so what >> the changes i have to do in macro. & n pls also tell me if i have to >> add yesterday date in body of the mail every day in every mail so what >> should i do. >> >> Pls help me in this i will be glad to et this help. >> >> Thanks in Advance >> Pankja k Pandey >> >> On 5/15/10, Mahesh parab wrote: >> > Hi >> > In attach workbook refer Sendfiles sheet. you can get required info on >> below >> > mention link. >> > >> > http://www.rondebruin.nl/sendmail.htm >> > >> > On Fri, May 14, 2010 at 10:47 PM, Fabio Sascho >> > wrote: >> > >> >> Dear friends >> >> >> >> >> >> >> >> Below you can find the code I wrote to make Excel send emails thought a >> >> list of names >> >> >> >> >> >> >> >> My problem is the attachment talk. >> >> >> >> >> >> >> >> I need a code that gets all files from a certain directory and attach >> into >> >> the email using the “ .attachment.Add” >> >> >> >> >> >> >> >> Does anyone know how to do that ? >> >> >> >> >> >> >> >> Thanks in advance >> >> >> >> >> >> >> >> Dim olApp As Object >> >> >> >> Dim olMail As Object >> >> >> >> Dim olSubject >> >> >> >> Dim olTratamneto >> >> >> >> Dim olName >> >> >> >> Dim olMsg >> >> >> >> Dim FirstLine >> >> >> >> Dim LastLine >> >> >> >> Dim olAttachment As FileDialog >> >> >> >> Dim olAttachmentDirectory As Object >> >> >> >> >> >> >> >> LastLine = Cells(65536, 1).End(xlUp).Row >> >> >> >> >> >> >> >> olTratamento = InputBox("Insira aqui uma mensagem que vem antes do Nome >> do >> >> seu cliente como Dear,Hello, Etc" _ >> >> >> >> , "Tratamento da Mensagem", "Hello ") >> >> >> >> >> >> >> >> olSubject = InputBox("Insira o assunto do email", "Subjetc Box", >> "BROTHERS >> >> IN GRANITE OFFER") >> >> >> >> >> >> >> >> Set olApp = CreateObject("Outlook.application") >> >> >> >> Set olMail = olApp.CreateItem(0) >> >> >> >> Set olAttachment = Application.FileDialog(msoFileDialogFilePicker) >> >> >> >> With olAttachment >> >> >> >> .AllowMultiSelect = True >> >> >> >> End With >> >> >> >> >> >> >> >> FirstLine = 2 >> >> >> >> For i = FirstLine To LastLine >> >> >> >> olName = Cells(FirstLine, 1).Value >> >> >> >> With olMail >&g
Re: $$Excel-Macros$$ Macro to send emails using excel list
Hi Mahesh, Thanks a lot for this help, this is really too helpfull for all outlook users. I also want to know that if i have to add CC or BCC in mail so what the changes i have to do in macro. & n pls also tell me if i have to add yesterday date in body of the mail every day in every mail so what should i do. Pls help me in this i will be glad to et this help. Thanks in Advance Pankja k Pandey On 5/15/10, Mahesh parab wrote: > Hi > In attach workbook refer Sendfiles sheet. you can get required info on below > mention link. > > http://www.rondebruin.nl/sendmail.htm > > On Fri, May 14, 2010 at 10:47 PM, Fabio Sascho > wrote: > >> Dear friends >> >> >> >> Below you can find the code I wrote to make Excel send emails thought a >> list of names >> >> >> >> My problem is the attachment talk. >> >> >> >> I need a code that gets all files from a certain directory and attach into >> the email using the “ .attachment.Add” >> >> >> >> Does anyone know how to do that ? >> >> >> >> Thanks in advance >> >> >> >> Dim olApp As Object >> >> Dim olMail As Object >> >> Dim olSubject >> >> Dim olTratamneto >> >> Dim olName >> >> Dim olMsg >> >> Dim FirstLine >> >> Dim LastLine >> >> Dim olAttachment As FileDialog >> >> Dim olAttachmentDirectory As Object >> >> >> >> LastLine = Cells(65536, 1).End(xlUp).Row >> >> >> >> olTratamento = InputBox("Insira aqui uma mensagem que vem antes do Nome do >> seu cliente como Dear,Hello, Etc" _ >> >> , "Tratamento da Mensagem", "Hello ") >> >> >> >> olSubject = InputBox("Insira o assunto do email", "Subjetc Box", "BROTHERS >> IN GRANITE OFFER") >> >> >> >> Set olApp = CreateObject("Outlook.application") >> >> Set olMail = olApp.CreateItem(0) >> >> Set olAttachment = Application.FileDialog(msoFileDialogFilePicker) >> >> With olAttachment >> >> .AllowMultiSelect = True >> >> End With >> >> >> >> FirstLine = 2 >> >> For i = FirstLine To LastLine >> >> olName = Cells(FirstLine, 1).Value >> >> With olMail >> >> .OriginatorDeliveryReportRequested = True ' delivery confirmation >> >> .ReadReceiptRequested = True ' read confirmation >> >> .Subject = olSubject >> >> .To = Cells(FirstLine, 2).Value >> >> .CC = Cells(FirstLine, 3).Value >> >> .BCC = Cells(FirstLine, 4).Value >> >> .Body = olTratamneto & Chr(32) & Cells(FirstLine, 1).Value & >> Chr(13) & Chr(13) & Sheets("MAIL_OFFER").Cells(1, 1).Value >> >> .Attachment.Add = “Several file” >> >> End With >> >> Next i >> >> End Sub >> >> >> >> >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about >> the learning and support from the group.Let friends and co-workers know >> they >> can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- Pankaj Pandey Bhopal -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the