Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
Dear Mr.Prabhu, Pls add my number also in Whatsapp Group Mobile: 9321035459 Regards Bala On Tue, Sep 19, 2017 at 12:32 PM, Manoj Garg <datac...@gmail.com> wrote: > Dear Mr. Prabhu > Please add me in WHATAPP GROUP > > M: 9927199217 <099271%2099217> > > On Tue, Sep 19, 2017 at 12:17 PM, N.Shivkumar <shiv1...@gmail.com> wrote: > >> Dear Mr. Prabhu >> Please add me in WHATAPP GROUP >> >> M: 9422613567 <094226%2013567> >> >> >> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> 2) Don't post a question in the thread of another member. >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> 4) Acknowledge the responses you receive, good or bad. >> 5) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at https://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > > > Regards, > Manoj Garg > Mobile:+91-9927199217 <099271%2099217> > <http://www.datacure.blogspot.com> > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Bala Iyer From Mumbai On Sat, Sep 21, 2013 at 11:10 AM, Rupesh Patil patil.rupesh1...@gmail.comwrote: Hi My name is Rupesh from Pune Maharashtra, India. I am working as technical support engineer and customer support engineer. I am looking for VBA help. actually I have task assigned to build up tool for data entry and I am completely new with VBA so, Thanks and regards, Rp. On Saturday, 9 June 2012 00:51:59 UTC+5:30, Ayush Jain wrote: Hey all new and current posters, Welcome to excel group,one of the largest online community of excel Fans! I hope you enjoy your time here find this forum to be a friendly and knowledgeable community. Please feel free to post a small introduction, a friendly hello or tell us a bit about yourself. Why not tell us where are you from, what you do, what your interests are, how old you are, which is your favourite excel site or blog is or anything else that comes to mind! Thanks for your time Ayush Jain Group Manager Microsoft MVP -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)
Hi, can you please tell me what additional information you need. Thanks, Bala On Thu, Dec 3, 2009 at 9:21 PM, RolfJ r...@pacificsound.us wrote: I'd be happy to help, but would need a bit more information. Rolf Jaeger SoarentComputing http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm On Dec 2, 4:52 am, bala Subrahmanyam puligadda simplyb...@gmail.com wrote: Hi ALL, Please help me in the repeating some calculations by using the macro. Please find the attachment. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to do is to calculate the sum of potential hours for ABC (F7:F16) customer Billable% = Customer Billable hours/Potential hours (H17/F17) Cust.Non Billable% = Cust Non Billable hours/Potential hours(L17/F17) Total Cust% = Total Cust Hours/Potential hours(N17/F17) Non Cust Productive% = Non Cust Productive hours/Potential hours.(017/F17) Total Productive % = Total Productive hours/Potential hours(Q17/F17) Overhead% = Overhead hours/Potential hours(S17/F17) Total All%= Total All Hours/Potential hours(U17/F17) This if for ABC organisation, like this we have to repeat this calculation for all the organizations and leave the grand totals at the bottom. This is a sample report, normally no,of organizations and details regarding the organization will vary from the report. I need a solution which will fit for all these changes. please help. but the columns are fixed for every report. Thank you.. Macro Help.xlsx 42KViewDownload -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent, can anyone help me)
Hi ALL, Please help me in the repeating some calculations by using the macro. Please find the attachment. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to do is to calculate the sum of potential hours for ABC (F7:F16) customer Billable% = Customer Billable hours/Potential hours (H17/F17) Cust.Non Billable% = Cust Non Billable hours/Potential hours(L17/F17) Total Cust% = Total Cust Hours/Potential hours(N17/F17) Non Cust Productive% = Non Cust Productive hours/Potential hours.(017/F17) Total Productive % = Total Productive hours/Potential hours(Q17/F17) Overhead% = Overhead hours/Potential hours(S17/F17) Total All%= Total All Hours/Potential hours(U17/F17) This if for ABC organisation, like this we have to repeat this calculation for all the organizations and leave the grand totals at the bottom. This is a sample report, normally no,of organizations and details regarding the organization will vary from the report. I need a solution which will fit for all these changes. please help. but the columns are fixed for every report. Thank you.. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Macro Help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Help required in repeating calculation using macro (This is urgent)...
Can any one help me...I need this very urgent.. Thanks... -- Forwarded message -- From: bala Subrahmanyam puligadda simplyb...@gmail.com Date: Sat, Nov 28, 2009 at 12:00 PM Subject: $$Excel-Macros$$ Help required in repeating calculation using macro To: excel-macros@googlegroups.com Hi ALL, Please help me in the repeating some calculations by using the macro. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to do is to calculate the sum of potential hours for ABC (F7:F16) customer Billable% = Customer Billable hours/Potential hours (H17/F17) Cust.Non Billable% = Cust Non Billable hours/Potential hours(L17/F17) Total Cust% = Total Cust Hours/Potential hours(N17/F17) Non Cust Productive% = Non Cust Productive hours/Potential hours.(017/F17) Total Productive % = Total Productive hours/Potential hours(Q17/F17) Overhead% = Overhead hours/Potential hours(S17/F17) Total All%= Total All Hours/Potential hours(U17/F17) This if for ABC organisation, like this we have to repeat this calculation for all the organizations and leave the grand totals at the bottom. This is a sample report, normally no,of organizations and details regarding the organization will vary from the report. I need a solution which will fit for all these changes. please help. but the columns are fixed for every report. Thank you.. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Macro Help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Help required in repeating calculation using macro
Hi ALL, Please help me in the repeating some calculations by using the macro. the following are the details for that we have to do calculation on the Employee Summary Rep tab. Please look into A17 row i.e., the subtotal for Organisation name ABC now what we have to do is to calculate the sum of potential hours for ABC (F7:F16) customer Billable% = Customer Billable hours/Potential hours (H17/F17) Cust.Non Billable% = Cust Non Billable hours/Potential hours(L17/F17) Total Cust% = Total Cust Hours/Potential hours(N17/F17) Non Cust Productive% = Non Cust Productive hours/Potential hours.(017/F17) Total Productive % = Total Productive hours/Potential hours(Q17/F17) Overhead% = Overhead hours/Potential hours(S17/F17) Total All%= Total All Hours/Potential hours(U17/F17) This if for ABC organisation, like this we have to repeat this calculation for all the organizations and leave the grand totals at the bottom. This is a sample report, normally no,of organizations and details regarding the organization will vary from the report. I need a solution which will fit for all these changes. please help. but the columns are fixed for every report. Thank you.. -- -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Macro Help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Excel to Oracle (urgent Please help)
Hi All, Can anyone help me in loading the excel information to Oracle Applications. I have a list of transactions which I manually enter in to Oracle AP transactions manually. can we record macro which automatically pic the transactions by step and post it to the Oracle Applications tab which I use. Thanks in advance --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)
Hi Roopesh... Thanks for that... On Mon, Aug 17, 2009 at 1:31 PM, Roopesh Kapur roopesh.ka...@gmail.comwrote: y can either use sendkey or go to a website cld. Www.dataload.nethttp://www.dataload.net/ On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote: Hi All, Can anyone help me in loading the excel information to Oracle Applications. I have a list of transactions which I manually enter in to Oracle AP transactions manually. can we record macro which automatically pic the transactions by step and post it to the Oracle Applications tab which I use. Thanks in advance --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Excel to Oracle (urgent Please help)
Hi Paul, I will describe you what exactly I do in Oracle Apps. By taking the information in Excel I will post them in AR Batches - Reciept Batches Reciept #, Amount, Customer# and Invoices # in the next screen. If your process help me. could you please send it to me. Thanks... On Mon, Aug 17, 2009 at 4:34 PM, Paul Schreiner schreiner_p...@att.netwrote: I use Excel as a front-end to an Oracle database EXTENSIVELY. I have over 60,000 lines of code running applications which store ALL of the data to Oracle. I have a sub that connects to the Oracle database. then, I build the SQL command and execute it. if you'd like an example of this approach, let me know and I'll put one together. Paul -- *From:* Roopesh Kapur roopesh.ka...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Monday, August 17, 2009 4:01:17 AM *Subject:* $$Excel-Macros$$ Re: Excel to Oracle (urgent Please help) y can either use sendkey or go to a website cld. Www.dataload.nethttp://www.dataload.net/ On 8/17/09, bala Subrahmanyam puligadda simplyb...@gmail.com wrote: Hi All, Can anyone help me in loading the excel information to Oracle Applications. I have a list of transactions which I manually enter in to Oracle AP transactions manually. can we record macro which automatically pic the transactions by step and post it to the Oracle Applications tab which I use. Thanks in advance --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Please give me a solution urgent.!!!!!!!!!!!!
Hi, use this following link...I think it will be helpful to you.Good Luck http://support.microsoft.com/kb/213360 On Fri, Jul 10, 2009 at 3:32 PM, amresh kumar amreshkushw...@gmail.comwrote: Hi, Please give me a solution urgent. formula of convert numeric value of in Text Example: If i have 231 numeric then he convert in text value. 231=two hundred thirty one 1000=thousand 1020=one thousand twenty Regards AK --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help to remove the * from cell entire row
hi, try this macro Sub RemoveChar() Dim StrAdd As String StrAdd = Range(A5000).End(xlUp).Address Range(A1).Select While ActiveCell.Address StrAdd If InStr(1, ActiveCell.Value, *) 0 Then ActiveCell.Value = Right(ActiveCell.Value, Len (ActiveCell.Value) - 1) End If ActiveCell.Offset(1, 0).Select Wend End Sub with Regards BAla --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Copy document name paste in excel
hi, try this code -- this example print excel file name in the given folder Dim oWbk As Workbook Dim sFil As String Dim sPath As String Dim strDocName as string sPath = Path \ FolderName ChDir sPath sFil = Dir(*.xlsx) Do While sFil Set oWbk = Workbooks.Open(sPath \ sFil) Set oWbk = Workbooks.Open(sPath \ sFil) On Error Resume Next Err.Number = 0 If Err.Number = 0 Then strDocName = Activeworkbook.name Thisworkbook.activate Activecell.value = strDocName Activecell.offset(1,0).select End If Wbk.Close False sFil = Dir Loop With Regards, Bala --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent help
Hi, try this code Activeworkbook.saveas(Thiswookbook.path \ ClinentName format(now (),ddmmhhmm).xls) With regards BALA On Jun 27, 5:14 pm, Chidurala, Shrinivas shrinivas.chidur...@citi.com wrote: Dear Friends I want file should be save like client name with current date time e.g. ICICIBANK270620091500 Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Condition Checking
hi, use this formula : =IF(INT((LEFT(A2,LEN(A2)-1)))1000,1,NA) with regards BALA --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: To fill the blanks
hi, use this code in Worksheet_Change Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 2 Then Target.Value = Left(Target.Value, 25) End If End Sub Regards bala On Jun 1, 2:44 pm, manish gupta mkg.necess...@gmail.com wrote: Hi Bala, Thank you for helping me in this matter,it is working fine...however i need further help as in attached sheet LOCNAME in this field i want to retain only 25 character from left..can u modify the code once again thanks in advance. manish kumar gupta On Mon, Jun 1, 2009 at 12:40 PM, bala bal...@gmail.com wrote: Hi, Try this code Sub Test() Range(A2).Select While ActiveCell.Value ' For ZIP If ActiveCell.Offset(0, 5).Value = Then ActiveCell.Offset(0, 5).Value = 9 End If ' For B If ActiveCell.Offset(0, 6).Value = Then ActiveCell.Offset(0, 6).Value = 0 End If ' For C If ActiveCell.Offset(0, 7).Value = Then ActiveCell.Offset(0, 7).Value = 0 End If ' For BI If ActiveCell.Offset(0, 8).Value = Then ActiveCell.Offset(0, 8).Value = 0 End If ' For TIV If ActiveCell.Offset(0, 9).Value = Then ActiveCell.Offset(0, 9).Value = 0 End If ' For CONST If ActiveCell.Offset(0, 10).Value = Then ActiveCell.Offset(0, 10).Value = 0 End If ' For YEAR If ActiveCell.Offset(0, 11).Value = Then ActiveCell.Offset(0, 11).Value = End If ' For FL If ActiveCell.Offset(0, 12).Value = Then ActiveCell.Offset(0, 12).Value = 0 End If ' For OCC If ActiveCell.Offset(0, 13).Value = Then ActiveCell.Offset(0, 13).Value = 0 End If ' For SQFT If ActiveCell.Offset(0, 14).Value = Then ActiveCell.Offset(0, 14).Value = 0 End If ' For COUNTRY If ActiveCell.Offset(0, 17).Value = Then ActiveCell.Offset(0, 17).Value = USA End If ActiveCell.Offset(1, 0).Select Wend End Sub Regards Bala On May 29, 4:35 pm, manish gupta mkg.necess...@gmail.com wrote: hi all, I need a help to fill the blank cell in attached excel sheet with certain criteria as below- Field Name Acction Taken ZIP If blank fill with 9 B If blank fill with 0 C If blank fill with 0 BI If blank fill with 0 TIV If blank fill with 0 CONST If blank fill with 0 YR If blank fill with FL If blank fill with 0 OCC If blank fill with 0 SQFT If blank fill with 0 COUNTRY If blank fill with USA I can do it manually but due to more file .i want any shortcut or Micros . can anyone help me regarding this. thanks in advance. Input Template Sample NEW_19_test.xls 79KViewDownload Input Template Sample NEW_19_test.xls 47KViewDownload- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent Excel Help needed
Hi; use this formula and drag it == =IF($E$4+R9$I$4,$E$4+R9,) Regards Bala On May 29, 11:26 am, Prashanth Banneni praba...@gmail.com wrote: Hi All, I have a issue with excel. Hope you can solve it easily :) I have a list with start date and and end date. Once i select the start date and end date the range if dates should be shown in the Row 10. Is it possible using formulae's because the file is too heavy and might crash if we include a Macro. Please let me know the solution at the earliest as i need to give an important presentation on Monday. File is attached. Thanks in Advance Prashanth Analyst Test List.xlsx 28KViewDownload --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Comma Concatenator Macro
hi, Sub test() icount = Len(ThisWorkbook.Name) icount = icount - 4 strtest = Left(ThisWorkbook.Name, icount) ThisWorkbook.SaveAs (ThisWorkbook.Path \ strtest Format (Date, dd-mmm-) .xls) End Sub with Regards Bala On May 27, 5:17 pm, Dhartikumar Sahu dhartiku...@gmail.com wrote: hi bala can u suggest me for saving the file i want to save as file name with current date. can u give me a VBA Code please On Wed, May 27, 2009 at 2:13 PM, bala bal...@gmail.com wrote: Hi, Try this code Range(A1).select while Activecell.value if len(Activecell.value) 3 then Activecell.offset(0,1).value = Activecell.value else Activecell.offset(0,1).value = 0 Activecell.value end if Activecell.offset(1,0).select wend Regards Bala On May 27, 6:01 am, Rick rjmag...@gmail.com wrote: I have code below to put a list of ID's from this: 123 122 121 3532 to this: ('0123','0122','0121','03532') However, I only want to put a zero in front of the ID if it is 3 characters in lenght. Desired output would be ('0123','0122','0121','3532'). Any help would be appreciated. thanks, Public Sub Create_LIST() Range(A1).Select Range(Selection, Selection.End(xlDown)).Select For Each vCell In Selection.Cells If vSQL = Then vSQL = vCell Else vSQL = vSQL ','0 vCell End If Next vCell Range(B1).Select Range(B1).Value = ('0 vSQL ') Selection.Copy End Sub- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: VBA code to search for worksheet with matching date
Hi, Try this code dim dtDate as Date dtDate = Thisworkbook.Names(IDO_Date).RefersToRange.Value for i = 2 to Sheets.count sheets(i).select if date(Range(B2).value)=dtdate then Exit For end if Next On May 19, 7:44 pm, Doug dsrmccl...@gmail.com wrote: Hello, I have a workbook with a separate page for each date. The date is always in cell B2. On the first page of the workbook I want to enter the date into a cell named IDO_Date and click on a button to go to the worksheet for that date. Can someone please show me the easiest code to assign to the button to do this? Thanks. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Export selected worksheets into new workbook from list box
hi your code process all the sheets listed in list box, check if List22.Selected (x) = true then selected value do the process Private Sub CommandButton1_Click() Dim Lst As String Dim x As Long For x = 0 To ListBox1.ListCount - 1 If ListBox1.Selected(x) = True Then Lst = ListBox1.List(x) Select Case Worksheets(Lst).Visible Case Is = xlSheetVisible Worksheets(Lst).Cells.Copy Workbooks.Add Selection.PasteSpecial Paste:=xlValues Selection.PasteSpecial Paste:=xlFormats End Select End If Next Unload Me End Sub regards Bala --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Code for copying a picture from excel to word
Hi , try this code Dim appWord As Word.Document, aadoc set appWord = getobject(FileName) 'copy picture from excel For Each objShape In ActiveSheet.Shapes objShape.Select With objShape .Height = intHeight .Width = intWidth .Copy End With Next 'Paste it into word appWord.Activate With appWord .ActiveWindow.Selection.Goto what:=wdGoToPage, Which:=wdGoToNext, Name:=strPageNumber .ActiveWindow.Selection.Paste End With with regards bala --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: All the names copied to one Cell seperated by a Semicolon
Hi , U can use this code in your module Sub Test() Dim strTest As String Range(A6).Select While ActiveCell.Value If ActiveCell.Offset(1, 0).Value Then strTest = strTest ActiveCell.Value ; Else strTest = strTest ActiveCell.Value End If ActiveCell.Offset(1, 0).Select Wend Range(D6).Value = strTest End Sub regads bala --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to insert text into textbox and click button in the internet through vba code.
hi, see this link : http://www.dailydoseofexcel.com/archives/2004/09/22/automating-internet-explorer/ with regards Bala On Apr 15, 11:16 am, kris krishna.agnihot...@gmail.com wrote: Hi All, I have a requirement to work with internet and to enter some text, need to select option buttons, need work with check boxes and to click the buttons and all. Could you please send me how to do it taking Google.com as an example. Waiting for your reply. Thanks Regards, Krishna. --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: How to insert text into textbox and click button in the internet through vba code.
Hi, use this code Tools -- Referance Add Microsoft Internet Controls Microsoft HTML Object Library Dim brs As InternetExplorer Sub IE() Set brs = New InternetExplorer With brs .Visible = True .Navigate http://Google.com; End With Do While brs.Busy Or brs.ReadyState READYSTATE_COMPLETE DoEvents Loop Call TextBox(q, VBA) Call Button(Google Search) End Sub Public Function TextBox(Name As String, Text As String) As Boolean ' Fill textbox Name with Text Dim Element As Variant brs.Document.getElementByid(Name).Value = Text End Function Public Function Button(Caption As String) As Boolean ' Clicks the button containing text Caption or returns false if button cannot be found Dim Element As HTMLButtonElement Button = True For Each Element In brs.Document.getElementsByTagName(Input) If InStr(Element.Value, Caption) 0 Then Call Element.Click Call LoadPage Exit Function End If Next Element Button = False End Function Sub LoadPage() ' Pauses execution until the browser window has finished loading Do While brs.Busy Or brs.ReadyState READYSTATE_COMPLETE DoEvents Loop End Sub with Regards, Bala --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com - -~--~~~~--~~--~--~---