$$Excel-Macros$$ Re: HAPPY NEW YEAR 2014
Happy New year to one and all. With best wishes, Kishan Reddy, K On Tuesday, December 31, 2013 3:24:13 PM UTC+5:30, friend wrote: Wish you a happy a glorious new year 2014 and all the best for the coming year -- - -- 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.
$$Excel-Macros$$ Re: Access Qurey
You can use the the links (linked tables) as like original table. Means, You can directly open the link and paste the data. You can refer the linked table in queries, forms, reports and even macros modules. Regards, Kishan Reddy, K -- 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$$ Data Entry Form/Database
Dileep, You can contact me, I am sending my contact details through mail. Regards, Kishan Reddy, K On Wednesday, October 2, 2013 6:34:34 PM UTC+5:30, Bv Dileep wrote: Thanks for your quick response. And please do let me know in this forum is anyone resides in Hyderabad and if you are ready to teach VBA. Please let me know On Oct 2, 2013 6:15 PM, ashish koul koul@gmail.com javascript: wrote: *try these * *https://app.box.com/s/zxhxpoitad7sih0wpigl * *https://app.box.com/s/szaxukie20xnutka8f3e*https://app.box.com/s/szaxukie20xnutka8f3e * https://www.facebook.com/photo.php?fbid=525682004167816set=a.209740072428679.47011.15180389897type=1theater * On Wed, Oct 2, 2013 at 6:13 PM, B V Dileep bvdi...@gmail.comjavascript: wrote: Hi, could please send me any tutorial link or document. That would be great. On Oct 2, 2013 5:32 PM, koul@gmail.com javascript: wrote: ** Use excel as front end and access as back end to store information Create an access database with tables , etc save it in a share folder Create userform in excel and connect it with access db using ado Regards Ashish Sent on my BlackBerry® from Vodafone -- *From: * B V Dileep bvdi...@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Wed, 2 Oct 2013 06:44:22 -0500 *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *Re: $$Excel-Macros$$ Data Entry Form/Database Hi, Just now I heard that creating forms and bit of VB code will work is it true? On Oct 2, 2013 4:21 PM, xlstime xls...@gmail.com javascript: wrote: no its not possible with only excel... need to create another database like ..ms access or sql . Enjoy Team XLS On Wed, Oct 2, 2013 at 3:53 PM, Bv Dileep bvdi...@gmail.comjavascript: wrote: Hi Experts, We have 10 associates, they are updating the data in different excel workbooks. at the end of the day i have to collate all those workbooks into one. is there any way if we provide them one workbook with share mode. If they update the data in the sheet. Only i have to get the updated status for all the users. -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . 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 a topic in the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-macros/uL79ux23UnY/unsubscribe. To unsubscribe from this group and all its topics, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . 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
$$Excel-Macros$$ Re: Stock prices data fetching through VBA
All websites will get Indian companies stock prices data from nseindia.com and bseindia.com. If you want to get stock quotes of indian companies based on stock code you can get that data directly from the above websites sites, instead of depending on third party sites. Regards, Kishan Reddy K On Tuesday, September 17, 2013 12:28:53 PM UTC+5:30, Murali prasad wrote: im trying to get the prices data from chartsapi.finance.yahoo.com to excel... by giving the inputs like -- scrip name, date from, date to, time frame, by which the url is developed based on inputs and get data to excel... output as below: date--time--open price--high price--low price--close price--volume. thanks regards, murali -- 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.
$$Excel-Macros$$ Re: Run time error out of memory 7
Hello, Give more details. At what stage, you are getting the error. When opening the file, When opening a particular form/ running a query / executing a report etc. Also provide The size of access file. Once thing you can try is to condense the access database using compact repair database option. Regards, Kishan Reddy, K On Tuesday, August 14, 2012 2:18:44 PM UTC+5:30, Prince Dubey wrote: Hi Group, I have a project which is running fine on my system with XP OS but the same project giving error of Out of Memory 7 on other system with XP platform. I am using VBA and Acess as data source. I tried my level best to track the source of error but not able to find it.So can you pls come up with your suggetions what may wrong with project. regards Prince -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: What is the future of VBA?
Comparing to Programming languages, application packages do have a long life. Still, why do you worry, about the future of VBA. Softwares are born, evolve become obsolete over a period of time. But software concepts, which have deep foundation in physical sciences mathematics do have a long life. While software professionals spend their time and resources to learn softwares, but will not try to understand the concepts fundamentals. The persons who (at least try to) understands the concepts fundamentals of various softwares will not bother about the life span of a particular software. Also, You can't project the life span of a software, just like you can't assess the life span of your own life. So, enjoy the fun of softwares and also the life. Regards, Kishan Reddy, K On Sunday, August 12, 2012 2:01:17 AM UTC+5:30, (%Allmydreams%) wrote: Dear All, What is the future of VBA? Or will it be killed suddenly like VB6? Do write back all your thoughts on given subject Regards Yogananda Muthaiah -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: want to show always last date in date range in chart X-Axis
One way is to display every value on x axis. But this will work only for limited values on x. Means your date range is below 20 or 30. Here you have to format the x axis. Select the scale tab. set the minor unit = 1 and major unit = 1. Another way is to display the max date above or some where around the graph for information purpose or add a suitable title reflecting the from date and to date. This is the way I found a solution, when i faced the same problem. Regards, Kishan Reddy, k On Thursday, August 9, 2012 7:17:50 PM UTC+5:30, Divaker Pandey wrote: Hi Expert, can any one help me to show last available date in chart -xaxis range. Divaker -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: Ledger opening balance and balance in MS Access
You can create a form or report, with the required format. It is needed to write VBA code based upon the dates given. As u said If you require report from 01-jun-2010 to 31-aug-2010, which will be provided as inputs to form/report Then it is required to calculate the opening balance which is obviously the closing balance as on 31-may-2010. This can be done in two ways (i) using SQL code select sum(debit), sum(credit) from ledger where Date between fromdate and todate. (ii) using recordsource object/method where you get the required records and process the records one by one. This is only a skeleton. If you are comfortable with forms and reports, please design it and send a sample access file, so that I can add the required VBA code to suit your purpose. Regards, Kishan Reddy, K On Dec 6, 4:40 pm, Veer virbhardwaj...@gmail.com wrote: hi friends, i want to make ledger accounts in ms access. i am able to make ledger for full period with opening balance but i m problem making ledger for a specific period. for example i have full debit credit data from 01 jan 2010 to 31 dec 2010 with opening balance. i can creat report for full period with opening balance. but if i want from 01 june 2010 to 31 aug 2010 i need opening balnce as on 1 june 2010 then all transaction within period and closing balance as on 31 aug 2010. kindly give some idea in MS Access 2010. if u have any template please provide. Thanks Veer -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ MS Access solution
Hello Rohan, Even though Excel and Access are two products of MS-office, working with them is quite different. While in excel the core term is cell, which when culminated leads to rows, columns, worksheets workbooks. In excel we work with formulas functions, with relative or absolute cell addressing, (either we use VBA codeing or not) Where as in acces the primary term is record which is a DBMS ( Database management system) term. MS-ACCESS, is a RDBMS, Relational Database Management System. Here you need to work upon records, tables using queries, forms, reports relationships. Even though functions can be generally used here, It is advisable to use queries or VBA code. Send me a sample file with exact requirement, so that I can look up and guide you. Your requirement can be exactly and directly addressed using queries VBA code. Regards, Kishan Reddy, K On Dec 6, 8:58 am, Asa Rossoff a...@lovetour.info wrote: Hi Rohan, In Access you should build a query instead of doing a lookup. Your query can refer to various parameters from fields in forms, or the user can be prompted for parameters (Access treats all field names that don't exist in a table as parameters). The other time you might use vlookup in Excel would be to cross-reference multiple tables of data. In Access, just use relationships between the tables and include all the referenced tables in your query. The value from the previous day report can be calculated by your query, along with the value for today's report, and you can set any criteria related to that you like in your query. After you create a query that retrieves all the data that will go on your report, use that query as the data source for your report. Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rohan Sent: Monday, December 05, 2011 2:30 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ MS Access solution Hi, I have a new project in hand for building a reporting solution for MS Access. I am trying to explore the idea as to how to I go about getting the desired results. My challange is, that the report would require to refer to the previous day report earlier done using the VLOOKUP formula in excel. However, the idea of using VLOOKUP function in Access is possible or not I am not sure. While exploring some new functions in MS ACCESS, I came accross DLOOKUP but I am not sure, if it can produce the same results. Group, Need your assistance with any ideas that you can share as to how do I go about accomplishing this. If you already have worked on a solution like this which helps in daily reporting by comparing the value from the previous day report and if you can share the solution with me, that will really give me ideas and would be really appreciated. Thank you !! Regards, Rohan. -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: saving command button not functioning
Please add the following code. rst.update after assigning values to the fields Also instead of using rst.fields(0), --- you can use rst.fields(fileno) which will be more legible and readable. Private Sub cmdsave_Click() Dim rst As Recordset Set rst = CurrentDb.OpenRecordset(select * from t_main) rst.AddNew rst.Fields(0) = txtfileno rst.Fields(1) = txtempname rst.Fields(2) = txtempdesign rst.Fields(3) = txtdob rst.Fields(4) = txtdoj rst.Fields(5) = txtdor rst.Fields(6) = ttotyrs rst.Fields(7) = ttotmths rst.Fields(8) = ttotdays rst.Fields(9) = txtnonyrs rst.Fields(10) = txtnonmths rst.Fields(11) = txtnondays rst.Fields(12) = txtnetyrs rst.Fields(13) = txtnetmths rst.Fields(14) = txtnetdays rst.Update End Sub Regards, Kishan Reddy, K -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Plus Sign in a Column
If you want enter any text, which looks like a formula or a number use ' (Single quote, this key can be locoted beside the enter key on the keyboard) If you want enter a + symbol, type '+ in the cell. This feature is inherited by excel from old spreadsheet program Lotus 123. Also there are some others We generally use Alt key on the keyboard to activate menu bar. (Ofcourse you prefer using mouse). In lotus to activate menu you need to use / (forward slash). This feature is also copied into excel. Interesting? Want to learn more. Take excel help using the following search string Lotus 1-2-3 keyboard equivalents Regards, Kishan Reddy, K On Nov 9, 1:25 pm, ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ vadnalaki...@gmail.com wrote: Dear all I have a small problem in MS Excel in a particular column I want to enter only + sign if I press = sign also it should come to + sign only anybody can assist me please Regards V.Kiran Kumar -- FORUM RULES (934+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: record a macro
Hello Akhilesh, Elaborate your exact requirement. Kishan Reddy, K On Oct 28, 5:10 pm, airen airen1...@gmail.com wrote: Hi Experts, Is there any way to record a macro between applications? Thanks Akhilesh Airen -- FORUM RULES (925+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Excel VBA/ Access
Hello James, I think for using any forms/running any quires, the access has to be opened. Also I think Connection method only used to share the data from the table/queries. Try the following code. Sub MyOpenDb() Dim appAccess As Object Set appAccess = CreateObject(Access.Application) appAccess.OpenCurrentDatabase (D:\XXX\ABCD.MDB) appAccess.Visible = True appAccess.docmd.openquery appAccess.Quit End Sub Revert back, if any comments, issues Regards, Kishan Reddy, K On Sep 14, 3:31 pm, ja...@macstop.co.uk ja...@macstop.co.uk wrote: Hi, I have posted this on the access group too, it can't really be classified as one or the other, but it's driving me mad, can anyone help. I have an Access 2010 database, which I have saved as .mdb. (ie not accdb) It has an update query in, which takes 2 string parameters. When I run it from Access it works fine - asks me for the 2 parameters then updates the table accordingly. However, I am trying to run it from Excel VBA. At first I thought the issue was the parameters, so I created another update query which takes 0 parameters. The continual error I get is 'Operation must use an updateable query'. It goes without saying that I can connect to the database, and I can run normal Select statements - anyone got any ideas? Code below: (obviously the execute line is the one that gives the error). Function RunUpdateQuery(objConn As ADODB.Connection) Dim objCommand As ADODB.Command Set objCommand = New ADODB.Command With objCommand .ActiveConnection = objConn .CommandType = adCmdStoredProc .CommandText = qryTest .Execute End With End Function -- -- 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$$ Re: Report Generation
Try Ms-Access. Put your data in a table and try the report wizard, which will guide you. If you still want the report in excel itself, it can be done using VBA coding. Send a sample file so that best approach can be decided based upon the quantity of data and compelxity of the report. Regards, Kishan Reddy, K On Sep 8, 9:37 am, Shankar Bheema shankar.n...@gmail.com wrote: What is the procedure to develop reports basing on the excel database through UserForm. Report generation in the sense, not in column and rows. It would be look like a form in word document. -- -- 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$$ Unsolved Queries
Be simple. You might be well aware of command buttons, drop downs, Text box, check box etc. Well these are called CONTROLS or OBJECTS. Either You are a programmer or not you might be well aware of these controls, You interact with these controls using keyboard or mouse or other input divices. Example with mouse You can click, double click, right click, drag drop objects etc. As well with keyboard you press the keys on the keyboard, known as typing, means you press the keys. These are nothing but called EVENTS (click, double click, right click, keypress). You expect something by CLICKING on a COMMAND BUTTON. These expectations means, what should happen when an event is written an EVENT-PROCEDURE Simple Example. You have a FORM. It Contains a Command Button. You want to display a message Command Button was clicked when the command button is clicked. So You write the code in the event procedure Sub CommandButton_Press Msgbox Command Button was clicked End Sub Let us see the BIG PICTURE. Revisit CONTROLS/OBJECTS: command buttons, drop downs, Text box, check box are simple controls. Worksheet, Workbook are composite objects, which are made with other objects ie, rows, columns, cells etc. Workbook contains worksheets (collection of worksheet). Worksheet contains rows, columns, cells etc. Just like a Human body contains different organs (objects) like heart, brain, stomack etc each will have its own functions (event procedure). and each orgon inturn is made up of different types of cells (basic controls). This is called OBJECT ORIENTED PROGRAMMING or EVENT DRIVEN PROGRAMMING. Regards, Kishan Reddy, K -- -- 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$$ Macro to monitor another Macro
I think, it is time you to study error handling procedures. Example. ON ERROR GO TO RESUME RESUME NEXT Go Ahead. Regards, Kishan Reddy, K On May 9, 1:15 am, hanumant shinde arsfan2...@yahoo.co.in wrote: Hey guys, its been 2 days but not even single reply. is it too tough or its not at all possible. i am not asking u to develop a macro n give it to me. just gimmi some hints to proceed. i hope this is fine with you guys.i m relying on you guys a lot. Thanks - Original Message From: hanumant shinde arsfan2...@yahoo.co.in To: Excel Group excel-macros@googlegroups.com Sent: Sat, 7 May, 2011 1:37:54 AM Subject: $$Excel-Macros$$ Macro to monitor another Macro Hi Guys, lets say there are 2 workbooks wkbk_run and wkbk_monitor. wkbk_run has macro which runs automatically and sometimes it throws OLE error for which we need to MANUALLY click OK button. i want wkbk_monitor to monitor that wkbk_run and whenever that OLE error occurs it should click OK automatically. i know there is some API to click OK button but i dont know anything about it. is it possible to create such a macro to monitor another macro. there are N numbers of Macros like wkbk_run so i cannot keep that code in all the workbook. so i want another macro to monitor all the macro which runs automatically. so it will be like monitor macro will run when 1st macro starts running and that will stop running when last macro gets over. thanks guys. please let me know if is it possible? -- -- - 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/discussexcel -- -- 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$$ Re: Delete raws having data above the specified period
There is no sample data in the attached file. Regards, Kishan Reddy, K On May 8, 5:22 pm, Rajesh K R rajeshkainikk...@gmail.com wrote: Hi Experts I need code to find the cells in column A having date above the date specified in C1 then select the entire column and delete it. Then loop until all the data above the specified period deleted. Regards Rajesh Kainikkara Test(1).xls 15KViewDownload -- -- 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$$ Re: Access Problem
Yogesh, I think it is the problem with heading row (field Names). There are certian convensions which has to be followed while giving field names in access. In that case you can review (rename) the column names in such a way that they will not include any special characters and lengthy names. If you still face the problem, please attach the file to locate the problem. Regards, Kishan Reddy, K On May 8, 4:20 pm, Yogesh Gohil yashr...@gmail.com wrote: Hi Guys, Some time when i want to import any data in Access then i get an error * is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long.* can Any one suggest me how to remove this error. Thanks Yogesh Gohil -- -- 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$$ Re: Filter Problem in Excel 2003
Mr Ramesh, I think the filter drop down list has a limitiation of 1000 entries in excel 2003 which might be extended to a bigger number in excel 2007. Again the dropdowns are re-populated when filter is set on a column. For example, I filtered on 'Customer No' column for Nov-10, it got out 'deposit date' drop down values '1-nov-2010'. What is understand is: When, working with filter in a workbook (excel 2003) having more than 1000 rows, if the criterias in a particular column also exceeds 1000 (like deposit date), then it is better to break it into two columns. Break the Deposit date into two columns, ie Deposit Month and Deposit Date. For filtering on a particular date, first filter on particular month and then select the date. Regards, Kishan Reddy, K . On Nov 7, 7:44 pm, Ramkesh Maurya sunscel...@gmail.com wrote: Dear all, I am facing a problem in filter (in column N) when I use Excel 2003. There is a date 1-Nov-2010 which is not appearing in the Auto Filter option although when I deleted blank cell but this is appearing when i sorted in asc/descind order In Excel 2007 this is appearing. I have attached the file. Thanks for any suggestion -- Ramkesh 9990260398 PDC TRACKER - SOUTH.zip 2274KViewDownload -- -- 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=wallref=ts
Re: $$Excel-Macros$$ Wishing you all A Very Happy Diwali...
To all the members families Happy Deewali Kishan Reddy, K On Nov 4, 8:54 pm, Chandra Shekar chandrashekarb@gmail.com wrote: Hi Ashish, WISH U THE SAME Thanks Chandra Shekar B On Thu, Nov 4, 2010 at 6:08 PM, ashish koul koul.ash...@gmail.com wrote: Wishing you all A Very Happy Diwali... -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- ------ 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...- Hide quoted text - - Show quoted text - -- -- 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=wallref=ts
$$Excel-Macros$$ Re: Formula to monitor profit/loss in stocks trading
I had gone through the excel file, I think, the format has to be changed, so as to enable stock splits and bonus issues. The important thing, that has to incorporated in the sheet is to add Running closing stock has to maintained. Further changes has to be made based upon running closing balance I will come back on this again, In a little while Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Oct 19, 12:10 pm, Yahya yahya...@gmail.com wrote: Dear all Can someone help me in this or provide a better spreadsheet? On Mon, Oct 18, 2010 at 8:47 AM, Yahya yahya...@gmail.com wrote: Dear all I use the attached excel sheet to calculate the profit/loss in the trading of individual stocks. The formula works fine in normal cases. But whenever there is some bonus/stock split etc. it fails. Can someone help me to derive a formula that will suit all cases? -- Regards Yahya -- Regards Yahya -- -- 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=wallref=ts
$$Excel-Macros$$ Re: Formula to monitor profit/loss in stocks trading
The file was sent to you through mail. For any thing you can mail me or Can catch me on google talk. Regards, Kishan Reddy, K On Oct 22, 11:26 am, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: I had gone through the excel file, I think, the format has to be changed, so as to enable stock splits and bonus issues. The important thing, that has to incorporated in the sheet is to add Running closing stock has to maintained. Further changes has to be made based upon running closing balance I will come back on this again, In a little while Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Oct 19, 12:10 pm, Yahya yahya...@gmail.com wrote: Dear all Can someone help me in this or provide a better spreadsheet? On Mon, Oct 18, 2010 at 8:47 AM, Yahya yahya...@gmail.com wrote: Dear all I use the attached excel sheet to calculate the profit/loss in the trading of individual stocks. The formula works fine in normal cases. But whenever there is some bonus/stock split etc. it fails. Can someone help me to derive a formula that will suit all cases? -- Regards Yahya -- Regards Yahya -- -- 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=wallref=ts
$$Excel-Macros$$ Re: Excluding holidays from a UDF
A break through Maintain your holidays in a worksheet. (either maintain them in ascending order or order them through code depending on the frequency of changes in holidays) In the function just count the holidays falling between start_date and end_date simply deduct them from the getworkdays. Regards, Kishan Reddy, K On Oct 18, 5:42 pm, me! infinite.space@googlemail.com wrote: Hi, I have the following code that calculates the number of days (excluding Sundays) between two dates, and ideally I'd like to add another parameter to my function to allow me to exclude non-working days (in a similar way to the in-built NETWORKDAYS function - - NETWORKDAYS(start_date,end_date,holidays) Can anyone help? . . . Many thanks, J Function GetWorkdays(FirstDate As Date, LastDate As Date, _ Optional Hols As Variant) As Integer Dim i As Integer, ii As Integer, wkdys As Integer Dim dy As Date Dim f As Boolean wkdys = 0 For i = 1 To (LastDate - FirstDate) dy = CDate(FirstDate + i) If Weekday(dy) 1 Then f = False If Not IsMissing(Hols) Then For ii = 1 To Hols.Count If Len(Hols(ii)) = 0 Then Exit For If CDate(Hols(ii)) = dy Then f = True Exit For End If Next End If If Not f Then wkdys = wkdys + 1 End If Next GetWorkdays = wkdys End Function -- -- 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=wallref=ts
Re: $$Excel-Macros$$ write to end of page to foot total
Mr Brain, A macro can be written such that 1. It will copy certain number of rows (one page full) to another sheet (example sheet2) 2. In sheet2 it will be formatted for printout (such that C/F, B/F, Page header, Page footer etc.) (counters will be maintained for page numbers, C/F, B/ F ) 3. the page will be printed 4.Repeat the process till all 10,000 rows are over If you won't get reasonable solution from others, U can send me the file to my mail ID. I can construct the macro and send it to you. Regards, Kishan Reddy kishanreddy.kethire...@gmail.com On Oct 7, 12:26 pm, fill brain fillbr...@gmail.com wrote: Hello , i mean i want to see to totals on custom footer.. like below excel file.. i wrote xxx which place i want to write footer total.. my intention. that is file... ornek.xls i added it in the group files.http://excel-macros.googlegroups.com/web/ornek.xls?gda=e7Xufj4o61... -- -- 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=wallref=ts
$$Excel-Macros$$ Re: Help Excel alert
Mr Rasheed, We can write a macro such that can pass through number of dates, compare with the current date and return the details of the bills to be paid today in a message box. Regards, Kishan Reddy, K On Sep 17, 9:46 pm, Abdul Rasheed rashee...@gmail.com wrote: HI Can any one have idea how to build particular alter in excel for specific event has occur, for example, payment due on the basis of due date so if that date comes then automatic alert would be appeared, please if any one have idea about this kind of solution please help me out. Regards Abdul Rasheed -- -- 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$$ Re: User text boxes in word
Right click the Text Box, Select properties. set the EnterKeyBehavior Property to true and set the multiline property to true. That's it. Bye Regards, Kishan Reddy, K On Sep 12, 8:09 pm, Johnnyboy5 intermediatec...@gmail.com wrote: How do I get the text box to line feed on pressing enter instead of the enter key jumping to the next text box ? Johnny -- -- 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$$ Macro to reshade every other row after column sort
Usha, This function is used mainly in finance. This can be better explained by an example. Let us assume, you are having Rs. 1,00,000/- which you want to invest. You got two proposals. 1. Fixed deposit at 10% interest for five years. 2. an annuity plan : end of 1st year you will get 17,000 end of 2nd year you will get 22,000 end of 3rd year you will get 27,000 end of 4th year you will get 32,000 end of 5th year you will get 37,000 In the first case you know the interest rate. In the second case you have to calculate the interest rate. So that you can choose what is more benificial. for this purpose you can use IRR function Just type your proposed investment and returns in like below in A1 -10 Your investment in B117000 first year return in C122000 second year return... and the like D1, E1, F1 Now use IRR function =IRR(A1:F1) This is only sample example. Regards, Kishan Reddy, K On Sep 9, 1:17 pm, Usha Negi ushadhvin...@gmail.com wrote: Dear All, Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel and how to use it? Regards, Usha -- -- 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$$ Re: How To Connect To Access Database Through VBA
Deepak, Let me know, why you want to create the form in Excel and link it to access. You can directly create a form in access which is very simple. Regards, Kishan Reddy, K On Sep 9, 10:48 am, Deepak Pal Singh deepaktheind...@gmail.com wrote: Hi, I need a help to connect excel file to a database in Access, I've a table format in the attached file, can anyone make a macro to solve this query. 1) Macro should take inputs from a useform and saved the data in the table in access databse. Seq# should be unique and auto generated for every new entry. 2) Details already entered in the databse should be ammendable through a userform, like if i have to make changes in date of birth of a individual then it should be possible by entering Seq# (Unique No) 3) If someone want to view data for an individual then it can be done by providing the unique Seq# in a user form. Platform is 2007. I hope it is enough chellangable to get response from experts. All the Best Thanks Regards Deepak Kumar Access.xlsx 13KViewDownload -- -- 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$$ Re: which events should i use in textbox .
Mr Neil, You need not write any code for this. Just open the form in VBA, select the text box1 and right click it, select properties. In that Set Autotab = true set maxlength = 2 do the same thing for text box2. Regards, Kishan Reddy, K On Sep 2, 1:17 pm, neil johnson neil.jh...@googlemail.com wrote: Hi Everyone, Which events should I use. I have three text boxes. When I enter the date in one textbox without using tab , curser moves to another text box and when i enter the date in text box2 then curser moves to textbox3 without using tab. Please find the attached sheet. Thanks and Regards userform question.xls 55KViewDownload -- -- 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$$ Re: Top Poster of the month :- Dave Bonallack
Hai Dave, Congrats, Keep the spirit. Regards, Kishan Reddy, K On Sep 3, 10:01 am, Ayush jainayus...@gmail.com wrote: Hi Group, I am glad to announce that Dave Bonallack has topped in posting for the month of Aug'10 with 67 Posts (9% of group posts). He has done it repetitively for two months. Thank you , Dave I encourage you all to make your contribution by sharing tip , tricks and solutions. This is your group and you have to make it happening group. Hi Dave , Many Many thanks for all your voluntary contribution and keeping this group active and alive by your solutions. Keep up the good work. Thanks again. Best regards, Ayush Jain Group Manager. -- -- 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$$ Re: Question about excel report
try from menu bar command Windows - freeze panes May this be useful. Regards, Kishan Reddy, K On Sep 3, 4:08 am, jjsmd jschwart...@gmail.com wrote: Hi: I am new to excel and I was wondering hiw I would do the following. I have an excel worksheet with names of people in a sheet going from column A to X and row 1 to 10. I would like to get a worksheet showing the location and then name. Ex: A1=John, A2=Smith and so on. Is this easily done? and if so how? Thanks -- -- 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$$ Re: CURSOR GOES TO PARTICULAR CELL WHEN I START THE FILE
Mr Salva, Just open visual basic editor (tools - macros - visual basic editor) Double click on This workbook in project explorer. copy paste this code in code window. Private Sub Workbook_Open() Sheets(Sheet2).Select Range(A494).Select End Sub Regards, Kishan Reddy, K On Sep 2, 9:28 am, big smile bigsmile...@gmail.com wrote: Respected Excel Guru's How to make the macro so that When ever i start the file my cursor goes into that particular cell only. For EX. Sheet 2 - A494 etc. The purpose behing this is ex. i have set the target of achieving certain amount -- so how much still pending to achieve. Thanks have a nice day. C P SAVLA -- -- 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$$ Re: cells resize
Rajesh, check the files copy of create cells.xls regards, Kishan Reddy, K On Aug 30, 7:03 pm, Rajesh D rajesh...@gmail.com wrote: Hi can some one help me on the attached worksheet query -- Thanks Rajesh create cells.xls 18KViewDownload -- -- 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$$ Re: I have a problem for following worksheet
just use space between 9:00 AM Regards, Kishan Reddy, K On Aug 30, 8:03 pm, Pankaj Kumar rajputpanka...@gmail.com wrote: Dear all, When i use the forumulla it shows value pls find attached sheep -- *Warm Regards Pankaj kumar M:9899816107begin_of_the_skype_highlighting 9899816107 end_of_the_skype_highlighting e-mail: rajputpanka...@gmail.com rajputpank...@yahoo.in* * rajputpankaj1...@rediffmail.com* time sheep.xlsx 18KViewDownload -- -- 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$$ Re: paths between cells
You can use Edit - goto (special) command to select specific cells in a particular range. check this command. Once you feel comfortable, record a macro. Then, if you require any further enhancements, reply me. One important thing, people tend to ignore unknown persons. Regards, Kishan Reddy, K On Aug 22, 7:32 pm, n3wsgr0ups stozs...@gmail.com wrote: Need you brains guys! Suppose I have a defined range on my worksheet, and within that range I have numbers or blank cells. i'm trying to write some vba code that given 2 cells as a start and stop point, finds all the blank cell paths between those two numbers. ie suppose 1 is at a1 and 5 is at c4 and the range is a1 to e6, i need to produce a list of non blank cell paths between the 1 and 5. a path being a way to traverse the cells between the two numbers by walking on non-blank cells including cells that touch at corners. Thanks in anticipation. -- -- 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$$ Birthdays list formula or macro
Hello, Phillip, Handle this by step by step. 1. IN column E Put the Heading Date in the Current Year. add fomula in E8 =DATE(YEAR($B$2),MONTH(B8),DAY(B8)) 2. In column F put Birthday falls in No. of days add formula in F8 =E8-$B$2 3. In Column G put the Heading Get it in English add formula in G8 =IF(F8=0,Today,IF(F8=1,Tomorrow,X)) Done. If you don't require, you can hide E F. Even though it can be done in signle step, I Have divided this into three steps for your better understanding and to make it is for little modification by yourself. Bye. Regards, Kishan Reddy, K. On Aug 21, 6:13 am, Aindril De aind...@gmail.com wrote: Hi Phillip, Please find attached the solved workbook. Do let me know if it helps or you need further help. I have added some other features other than your requirement which I felt might come handy, as well, which will predict the following: Today (As required) Tomorrow (As required) Day After (As required) After x Days (Added) Not in this month (Added) Cheers, Andy On Sat, Aug 21, 2010 at 4:04 AM, Phillip Swanepoel pswa...@gmail.comwrote: Hi all Attached is a sample work book. In column b down i got birthdays. next to that the persons name. B2 will be either =today() or =now() (or something else that will trigger the days date... how can i display in a column who has a birthday today or tomorrow? Phillip Swanepoel pswa...@gmail.com (JanPhi) 0825360597 0287134213 34° 4'58.48S, 21°14'51.33E This email has been forwarded using a mobile phone with a internet/wap application. Go towww.operamini.comfor more info -- -- 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 birthdays-Andy.xls 29KViewDownload -- -- 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$$ Re: Naming ranges which change in size using VBA
Dear David, Just carefully replace, RefersToR1C1:==Sheet1!R2C1:R12C6 with RefersTo:=Selection You have four ranges, so do the replace four times for each range. Regards, Kishan Reddy, K On Aug 21, 1:04 am, David Stubbs davidmstu...@gmail.com wrote: Hello everyone, I am trying to write a macro to name four ranges in a sheet. The ranges will have the same width every time, and the ranges below the two at the top with always be separated by 1 blank row but more or less rows. I thought it would work by using: Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select To select one range, then name it and then move to the next range and repeat. But when I record the macro, the cell references for the ranges are hard coded in, so when I run it on new data with a different number of rows, the named ranges do not correspond to the new data. The full code I have is below, and a file call “dynamic naming.xlsm” has been loaded to the group site. Any thoughts much appreciated Thanks David - Sub NamingMacro() ActiveCell.Offset(1, 0).Range(A1).Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select ActiveWorkbook.Names.Add Name:=WorldIm, RefersToR1C1:==Sheet1!R2C1:R12C6 ActiveWorkbook.Names(WorldIm).Comment = ActiveCell.Select Selection.End(xlDown).Select Selection.End(xlDown).Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select ActiveWorkbook.Names.Add Name:=WorldEx, RefersToR1C1:==Sheet1!R14C1:R26C6 ActiveWorkbook.Names(WorldEx).Comment = ActiveCell.Select Selection.End(xlToRight).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlToRight).Select ActiveCell.Offset(1, 0).Range(A1).Select ActiveCell.Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select ActiveWorkbook.Names.Add Name:=USIm, RefersToR1C1:==Sheet1!R2C10:R9C15 ActiveWorkbook.Names(USIm).Comment = ActiveCell.Offset(1, 0).Range(A1).Select Selection.End(xlDown).Select Selection.End(xlDown).Select ActiveCell.Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select ActiveWorkbook.Names.Add Name:=USEx, RefersToR1C1:==Sheet1!R11C10:R18C15 ActiveWorkbook.Names(USEx).Comment = 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 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$$ Required Urgent Help In VBA...........
Mr Pankaj, 1. The code is password protected. 2. Let me Know where is the Submit Button. (in which sheet) 3. Let me know precisely what are the cells that you want to check for blanks. Regards, Kishan Reddy, K On Aug 21, 10:36 am, Intelligent But Crazy secrets...@gmail.com wrote: Hi Experts Pls Help Mee Regards Pankaj k Pandey On 8/20/10, Intelligent But Crazy secrets...@gmail.com 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 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 -- -- 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$$ Re: how we can schedule auto open excel
Divide your issue into two 1. schedule to auto Open an application/file at a particular file. This is actually part of operating system. in operating system (for example windows) take Help on SCHEDUAL A NEW TASK. 2. executing a macro on opening the file. This is part of excel. Just place your code in Workbook_open Open the excel file/application. Open the visula basic editor. Select the This workbook. Private Sub Workbook_Open() End Sub Copy the above two lines Put you code in between this lines. Your code will be executed every time the file is opened. Still have any problem contact me. Regards, Kishan Reddy, K On Aug 21, 10:07 am, VILAS CHAVAN vilaschav...@gmail.com wrote: how we can schedule to auto open excel application on given time and run macro. Please let me knw and knw the solution on that. -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra -- -- 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$$ Re: Need Help in Cross tab
Hello Shariq, I don't understand why can't you use pivot table. Actually, it is simple with pivot table. Just drag the date to the rows header. drag the hours to the column header. LoadId to the data area. If you get sum on loadId, double click on it, and change it to count. The only difference is you will get 1, instead of Yes. Regards, Kishan Reddy, K On Aug 21, 12:56 pm, shariq khan shariqcoo...@gmail.com wrote: Hi All, I need your help, as I’m unable to solve the problem which I’m going to explain you guys…….. Please refer the attached the excel with two tabs “Data” and “Report” On Data tab I have three columns loaded and Date and hours. Now I need a macro code to generate a report actually the cross between Date and Hours(we don’t have duplicate hours in date) and the we have max 22 hours in a date . if we have particular hours is the Data tab under a date then we need to flag the value with “Yes” under the fixed location of that hours in Report Tab. I hope you guys understand what I need. I cannot use pivot table. If you look into the attached excel you will get an idea what I need. Please help me guys……. Thanks in advance Thanks and Reagrd’s Shariq Sample Data.xls 31KViewDownload -- -- 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$$ Re:
Dear Jai, Select the cells that you want to hide. On the Format menu, click Cells, and then click the Number tab. In the Category list, click Custom. In the Type box, select the existing codes and press BACKSPACE. In the Type box, type ;;; (three semicolons). Select the OK button Regards, Kishan reddy, K On Aug 21, 2:07 pm, Jai jaihumtu...@gmail.com wrote: Hello Experts Can you Tell me that how can Hide the One Cell in Excel in Sheet. -- Thanks For Mail. -- -- 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$$ Re:
Mr. Dilip, Mr Jai has; requested only to hide the contents of the cell without any protection. So is my answer. This way you can only hide the contents of the cell, but U can't protect against alteration. Regards, Kishan Reddy, K On Aug 21, 6:20 pm, Dilip Pandey dilipan...@gmail.com wrote: Dear Kishan, Is it diferent for the approach where we can go to Protection tab and check the checkbox against the option Hidden? -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 8/21/10, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Dear Jai, Select the cells that you want to hide. On the Format menu, click Cells, and then click the Number tab. In the Category list, click Custom. In the Type box, select the existing codes and press BACKSPACE. In the Type box, type ;;; (three semicolons). Select the OK button Regards, Kishan reddy, K On Aug 21, 2:07 pm, Jai jaihumtu...@gmail.com wrote: Hello Experts Can you Tell me that how can Hide the One Cell in Excel in Sheet. -- Thanks For Mail. -- ------ 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 -- Thanks Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India- Hide quoted text - - Show quoted text - -- -- 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$$ Re: How can Divide the Numbers by 1 lac in excel
You can use the following OPERATORS in excel +addition, - substraction * multiplication / division for example if your data is in Column B1, Just Type this column C =B1/10 Your values in lacks will be available in column C If you want round it (Restrict the number of decimal places) Use this =Round(B1/10,2) It will round to two decimal places as we have given 2. Regards, Kishan Reddy, K On Aug 20, 8:53 am, OPSHARMA opsharma...@gmail.com wrote: Dear Experts, I have many data in excel sheet and want to convert the same in Lakh. Kindly help me how can it be divided it through single formula. Regards OPS -- -- 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$$ Re: Problem New1
Change this line Dim ltext As LOng, curRow As Long AS Dim ltext As String, curRow As Long Regards, Kishan Reddy, K On Aug 19, 10:24 pm, hemant shah hemanthin...@gmail.com wrote: Hi Team, I need your help in the attched excel. I have explained everything in attached sheet. Regards Hemant shah Problem New1.xls 93KViewDownload -- -- 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$$ Re: Removing selected letters and symbols from a cell
Two solutions. 1. through a function If the data is in Column A, Use this function in column B =MID(A1,FIND((,A1)+1,7) 2. Using Commands (Data - Text to Columns a. Select the data b. Go to Data - Text to Columns c. Select Delimited Option and click on Next d. Select Others Type ( in next column and click on next e. Click on finish button Now the data will be split into two columns select the data in second column Repeat the above process in step d. Type ) instead of (. Regards, Kishan Reddy, K On Aug 18, 4:51 pm, Alexander Cargill zanderman1...@googlemail.com wrote: Hi all I was wondering if you could help. I have a sheet with entrys into a cell that looks like this: AAECHO::DELTA (422|279) K24 AALPHA::HOTEL (447|319) K34 ALPHA::FOXTROT (445|320) K34 ALPHA::GOLF (446|319) K34 ALPHA::INDIGO (448|320) K34 ALPHA::JULLIET (449|319) K34 ALPHA::KILO (448|323) K34 BRAVO::ALPHA (459|317) K34 BRAVO::DELTA (463|318) K34 CHARLIE::BRAVO (426|330) K34 All I want to be left with is a sheet with entry's like this: 422|279 447|319 445|320 446|319 448|320 449|319 448|323 459|317 463|318 426|330 And the data that has K and a number behind it in a separate column(there is multiple K numbers). If you could help ide be most grateful. Many thanks Alex Cargill -- -- 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$$ Need help with a formula
As dave said, there is a formula in column Click on the formula. Carefully copy the formula except '=' symbol type the following in the same cell. =iserror(FORMULA, 0, FORMULA) Replace the FORMULA with the copied formula Regards, Kishan Reddy, K On Aug 19, 9:27 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi Becky, If XL has put NA in a cell, you must already have a formula there. You'll need to send a sample workbook so we can see get the whole picture. Regards - Dave. Date: Wed, 18 Aug 2010 12:15:30 -0700 Subject: $$Excel-Macros$$ Need help with a formula From: rebecca.math...@kraft.com To: excel-macros@googlegroups.com I am trying to create a formula: For a given range which most values are NA, I want the cell to return the value of the cell that is above the first cell that contains value 0 (not NA). -- -- 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 athttp://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
$$Excel-Macros$$ Re: Help needed- Macro to repeat lines 10000 times
Why can't you use Copy paste command. Why you require a macro for this. Regards, Kishan Reddy, K On Aug 18, 9:04 pm, kamal shah kamal...@gmail.com wrote: Hi group I have piece of XML for example below which i need to repeat it for 1 times May I request one of expert to develop a simple macro which will use Paste command and paste piece of lines for 1 times. Cheers Kamal P.S Sample XML TRACONCO1 NamCO17KARV G./NamCO17 StrAndNumCO122DU PONT/StrAndNumCO122 PosCodCO12365487/PosCodCO123 CitCO124ROME/CitCO124 CouCO125IT/CouCO125 TRACONCO1LNGIT/TRACONCO1LNG /TRACONCO1 -- -- 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$$ Re: tree sheets in export in Aceess files and import also.
1.Try to create a macro for import with action transferdatabase, provide the required options. If any problem contact me, Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 16, 10:11 am, ALAM aftab.ala...@gmail.com wrote: Deat all, pls solve my problems. 1. excell files export in Access files and import also. 2. How can make a attandence record attomaticaly in excel files. we have 10 employee details and i want to make a Att. sheet in excel according to employee id. Means, i want to just click Epm Id then we found all details in defferent rows or colomns. *EMP ID NAME IN-TIME DATE EMP ID NAME IN-TIME DATE * 1001 ALEX 7:50 (A.M) 18 Aug,10 1001 ALEX 3:50(P.M) 18 Aug,10 1005 LAXMI 7:15 (A.M) 18 Aug,10 1001 ALEX 3:15 (P.M) 18 Aug,10 -- RegardsThanks, AFTAB ALI 9310903589 -- -- 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$$ Re: Help needed in changing this code
Just Try this code. Dim CELL As Variant Range(B2:B105).Select For Each CELL In Selection If IsEmpty(CELL) Then With CELL.Offset(0, -1).Interior .ColorIndex = 3 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With Else With CELL.Interior .ColorIndex = 10 .Pattern = xlSolid .PatternColorIndex = xlAutomatic End With End If Next You may need to change the colorindex as per your pallate. Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 16, 6:05 am, Alexander Cargill zanderman1...@googlemail.com wrote: Hi all I have been working on the following piece of code to identify Blank Cells and turn them red: Range(B2:B105).Select Selection.SpecialCells(xlCellTypeBlanks).Select ActiveWindow.SmallScroll ToRight:=-1 With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 255 .TintAndShade = 0 .PatternTintAndShade = 0 End With Range(B15).Select I would like to expand the code to do the following: 1 expand this code so it searches the B column but instead off turning the Blank cells in column B red it turns the cells Ajacent to the blanks in column A Red 2 I would like to turn the cells that are adjacent to the cells that are not blank green If you could help with this I would be most greatful Alex Cargill -- -- 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$$ Re: How to open WK1 formated file with Excel 2007
Just save it as (using save as) excel file. Then you can open it in Excel 2007. Regards, Kishan Reddy, K On Aug 13, 1:48 pm, harris a harris...@gmail.com wrote: Hello, I am not able to open lotus formatted files (with extension WK1) using Excel 2007. However, I am able to open it with Excel 2003. Please help. I have uploaded a file test.WK1 just now for you guys to check. thank you cheers Harris -- -- 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$$ Excel VBA : Unique Values
Just use Pivot table. Regards, Kishan Reddy, K On Aug 6, 4:29 pm, Sundarvelan N nsund...@gmail.com wrote: Hi Abhishek, Could you help in one more task also. That is under each Team leader i need to have corresponding agents name. Please help. Thanks Sundarvelan On Fri, Aug 6, 2010 at 4:53 PM, Sundarvelan N nsund...@gmail.com wrote: Hi Abhishek, Please help to proceed with ur idea. Thanks, Sundarvelan On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain abhishek@gmail.comwrote: Dear Sundar, There are two things - First - If you want to put all unique values (the existing ones and the newly added) in those 3 columns and are ready to hit Update button every time then add the following two lines in the beginning of your code - *Range(N5:P65000).Select Selection.ClearContents * This will clear the existing records in those 3 columns and allow your code to put new unique values. Remember - *You have to press the Update button each time* you wish to reflect the most updated data. Second - If you want to put existing unique values in those 3 columns only once and then get the new ones updated automatically, i.e., *without pressing the Update button* then, this is something entirely different. You can do this too but you have to use an add-in for that. If this is what you want, let me know, I'll guide you through the process. Cheers! AJ On 8/6/10, Sundarvelan N nsund...@gmail.com wrote: Hello Friends, Please help me to finish my assignment. I have attached a excel file, in that i need unique team leaders name from E column and updated in the N column, Like wise Managers, Departments. I Need VBA Code that automatically updates if any new entries in the E column it must update in the N column. I have already done / tried one work it runs OK for first time. If i click for second time it gives error message. It is a mix of recorded code plus manual changes. Please help me Thanks, N.Sundarvelan -- ------ 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 -- N.Sundarvelan -- N.Sundarvelan BPMS.xls 155KViewDownload- Hide quoted text - - Show quoted text - -- -- 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$$ Re: WebBrowser
Can you send your application. I will check once. Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Aug 1, 9:07 pm, Anju anjulav...@gmail.com wrote: Any Updates ? On Sat, Jul 31, 2010 at 7:40 PM, anju anjulav...@gmail.com wrote: I am using a WebBrowser control in my application. When i try to download the file through this control, it will show a pop-up of File Download. I tried to handle it automatically and hove done this. But now I want to hide this window and want to make whole operation at back end. Can anyone help me?- Hide quoted text - - Show quoted text - -- -- 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
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 secrets...@gmail.com 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 secrets...@gmail.com 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 secrets...@gmail.com 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
Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1
As per my policy, replacing/deleting any rows/values is not a good idea. I will simply use pivot table or subtotals command on the data and get the results in another sheet. Regards, Kishan Reddy, K On Aug 4, 4:11 pm, Dave Bonallack davebonall...@hotmail.com wrote: Hi Angelo, Have a look at the attached and run the macro. I've used Columns IS:IV as a work space. If you want to put data in these columns, then we'd have to change the macro a little. Regards - Dave. From: spinolaang...@gmail.com Date: Tue, 3 Aug 2010 10:37:22 +0100 Subject: Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 To: excel-macros@googlegroups.com Does someone else know how to do this please! 2010/8/3 Dave Bonallack davebonall...@hotmail.com Hi Angelo, The summing could be done with worksheet functions - probably SUMPRODUCT. But the deleting of lines has to be done by macro, so it makes sense to do both by macro. I can't look at it straight away, but if no one else comes up with anything, I'll have a look later. Regards - Dave. From: spinolaang...@gmail.com Date: Mon, 2 Aug 2010 12:54:55 +0100 Subject: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 To: excel-macros@googlegroups.com Forgot the attachment, sorry :) 2010/8/2 Angelo Spinola spinolaang...@gmail.com Hello All, I need a formula that Checks if B,C, D are the sameif equal (could have more than just two equal) sums the Columns E and F and replace it for just one Line instead of having duplicates or triplicates. How can i create this ? With a Macro ? Regards. -- -- 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 athttp://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 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 athttp://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 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 athttp://groups.google.com/group/excel-macros/subscribe problem.xls 33KViewDownload -- -- 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$$ Re: equation editor in excel 2010
First of all, Let me know why you want you use such type of objects, in excel, when the same can be done through simple formulas and simple macros. Let me understand the purpose. Regardds, Kishan Reddy, K On Aug 2, 12:26 pm, Stuart Redmann dertop...@web.de wrote: Santiago Afonso wrote: Hello. I'd like to use the equation editor in excel 2010 through VBA. In Word, the equation object is OMath ( http://msdn.microsoft.com/en-us/library/bb256563%28office.12%29.aspx), and the macro recorder records some actions done to such an object (like changing equations from professional to inline). Excel 2010's macro recorder does not reflect interactions with any object other than shapes when using the equation editor, and I found no information regarding the usage of the OMath object under Excel. It seems to me as if the OMath object is just Word's wrapper for mathematic formulas, the actual COM object is Microsoft Equation X. 0. This object is provided by Design Science Inc., and as far as I can see on their homepage they don't have an Automation interface for their component (they rather advertise the feature that one can import MathML into their component, but you'll have to buy the latest version of their software). Due to the nature of COM, the macro recorder cannot possibly track any user interactions that are done to embedded objects. This means that you're out of luck. A quick scan with Google yielded very little usable information: It seems that automatable formula editing controls are quite rare. Most probably it will be the easiest if you use Latex to typeset your formulas and import the generated graphics into Excel. Regards, Stuart -- -- 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$$ Re: Macro for tracing the changes
Sudhir, Why can't you use Track changes from Tools menu? Regards, Kishan Reddy, K On Aug 4, 7:51 pm, sudhir kumar sudhir.p...@gmail.com wrote: Thanks stuart for ur reply, but, macro record is work for when u r using same type of command again and again, but this time issue is different On Wed, Aug 4, 2010 at 11:10 AM, Stuart Redmann dertop...@web.de wrote: sudhir kumar wrote: hi friend, i attached an excel file, which having some information in it, now i want that if i will do any type of change in it, i will be able to trace it, means, i change in some of the column or row, or i introduce any new row ,or delete any row. every type of change i want to trace., Why don't you just turn on the macro recorder? This component pretty much saves a playback of all the actions the user does. The recorded macro can be used to generate a log file. I can't think of any other way. Regards, Stuart -- -- 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 -- Regards- Sudhir Kumar Design Engineer, Conceptia Software Technologies Pvt. Ltd. Email id-sudhir.p...@gmail.com, -- -- 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$$ Re: Find duplicate with 3 criteria in Excel 2003
Nadine, This can be done using Vlookup function and filter command. Use Vlookup function on Column B, and another Vlooku on Column C Then Use filter command on Vlookuped columns where there are no #NA values. Great things can be done with available (inbuilt) functions and commands in excel, provided we know how to use them. Regards, Kishan Reddy, K On Jul 31, 1:17 am, Nadine S n8dine4ma...@yahoo.com wrote: Is there a way to find a duplicate with 3 criteria? I know it can be done with one. Assuming there is data in columns A, B, C. I need to find if there are any duplicates that match all three in those columns. Thanks. -- -- 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$$ Re: Problem In Macro Recording (URGENT Plz ! )
Just open the workbook in which you have created the macro. It will work in generally. Regards, Kishan Reddy, K On Jul 30, 2:32 pm, Rehan Baig rehan.bai...@gmail.com wrote: Kishan Thanx, for your help. But kindly tell me if i save macro in This Workbook, Will it work for other workbooks. REHAN On Wed, Jul 28, 2010 at 11:53 AM, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Instead of storing the macro in personal macro workbook, select this workbook. There may a problem with the personal work book. Regards, Kishan Reddy, K On Jul 27, 1:10 pm, Rehan Baig rehan.bai...@gmail.com wrote: Dear Members I have some problem with macro recording, after entering macro name, shortkut key and Store macro in : Personal Macro Workbook Message appears *Personal Macro Workbook must be open in startup folder* ** Some time this message appears and some times not, Kindly help me, in this regard. REHAN BAIG -- -- 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 -- -- 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$$ Fwd: hi
Mr Abhishek Jain, There is problem with the function when the following dates are given. 29/01/2010 30/01/2010 31/01/2010 Please check and modify it. Regards, Kishan Reddy, K On Jul 30, 9:47 am, Abhishek Jain abhishek@gmail.com wrote: You're welcome. However, both works. 1st one is having reference of the text, and in second one, text is within the formula. That's the only difference. AJ On Thu, Jul 29, 2010 at 1:42 AM, sudarshan rampe sidhu...@gmail.com wrote: thanks abishek the second one worked out.. -- -- 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$$ Need Formula
Hello, Let me know, How many number of REPs are there? Why do you want to put them in different sheets? Regards, Kishan Reddy, K On Jul 29, 2:11 pm, Venkatesh Narla nvenki...@gmail.com wrote: Hi, Can u check this this can be helpor not On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Dear All, Please find attach the sheet wherein I need the Data from Tracking Sheet should go the each individual sheets the data. Please see attach file for more understanding. Waiting for your ideas and suggestions... -- Ahmed Bawazir -- -- 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 Need_Help.xls 43KViewDownload -- -- 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$$ Re: Userform locks Excel
attach the form, let me check. Kishan Reddy, K On Jul 28, 10:16 pm, b wer61...@gmail.com wrote: I have an Excel workbook w/ a VBA menu to pops up a userform to write values back to a worksheet in the workbook. Sometimes, the userform locks Excel and it has to be abended. I suspect its due to users have other workbooks open and copying and pasting between them. Can I specify a specific instance in the VBA code for the userform? Is the userform independent of the workbook and could write back to whatever instance is active? Can I specify a window handle? -- -- 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$$ Re: Urgent help Invoice Macro modification
The solution was sent through mail. Is the solution working fine, reply back. Regards, Kishan Reddy, K On Jul 29, 8:33 am, Nagendra Modupalli naga14...@gmail.com wrote: Hi Team, The password is correct STPIInvoices in this up to STPII is CAPS letter nvoices is small latters. Please let me know if you have any questions on this.Thanks in advance. *Private Sub cmdPrint_Click() Set objDataSheet = Me.Parent.Sheets(Data) objDataSheet.Unprotect STPIInvoices Me.Unprotect STPIInvoices PrintAllInvoices objDataSheet.Protect STPIInvoices, , , , , True, True, True, , True, , , True, True, True, True Me.Protect STPIInvoices, , , , , True, True, True Set objDataSheet = Nothing End Sub * On Wed, Jul 28, 2010 at 12:37 PM, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Code is not opening, The password might be wrong. Kishan Reddy, K On Jul 27, 10:21 am, Nagendra Modupalli naga14...@gmail.com wrote: Hi Team, I have Invoices printing macro.It is printing row wise.I want to modify customer wise.Can you please help me.Thanks in advance. And also i have attached my macro file. For example if it is two columns same customer it has to print one invoice and in this two column only it will change Invoice number and amt and i have attached Example file. Password is STPIInvoices -- ThanksRegards Nagendra.M Tel#91 9900516251 -- ThanksRegards Nagendra.M Beautiful photos are developed by negatives in a dark room, so if U see darkness in Ur life believe that God is making a beautiful future for U !!! Macro_STPI Invoice(Annexures).zip 1495KViewDownload Example.xls 38KViewDownload -- -- 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 -- ThanksRegards Nagendra.M Beautiful photos are developed by negatives in a dark room, so if U see darkness in Ur life believe that God is making a beautiful future for U !!! -- -- 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$$ Re: Help creating chart
Hello, Obviously you will have a data sheet on which you have created the graph. Just right clik on the graph and select source data It will show the data on which graph is drawn. Just reselect the range that you want and press OK done. Bye Kishan Reddy, K. On Jul 28, 4:43 am, Steve stevebwea...@comcast.net wrote: I need help! I am trying to adapt a neat little spreadsheet for my use in graphing monthly, quarterly, and year-to-date sales for the current year and a comparison to the same period in the prior year. What I have so far has been downloaded. How can I select the appropriate period to plot i.e. month, quarter, or year-to-date? Thank you in advance for your help. Steve -- -- 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$$ Re: Delete rows from sheet1 with matches in sheet2
Just use sort command, vlookup function filter commands, done sort the data in sheet2 on id. add another column besides ID. and place 1 in the columns in sheet 1, Add another column (Example in D) to sheet1 and name it as index (assuming data is in columns A B C) use the following formula in D vlookup(A2, SHEET2!$A$2:$B$10,2,FALSE) Here you will get 1 in column D Use filter command and fiter for 1's and delete them. Bye, Kishan Reddy, K. On Jul 28, 12:40 am, calibansfolly calibansfo...@gmail.com wrote: I need to delete rows from one sheet that match an id in another sheet. Here's an example: sheet1: id fname lname 3 Brian Johnson 17 Ben Johnson 42 Mary Greene 100 Joe Brown sheet2: id 17 42 Result: id fname lname 3 Brian Johnson 100 Joe Brown Any ideas about how to do this? -- -- 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$$ Re: Problem In Macro Recording (URGENT Plz ! )
Instead of storing the macro in personal macro workbook, select this workbook. There may a problem with the personal work book. Regards, Kishan Reddy, K On Jul 27, 1:10 pm, Rehan Baig rehan.bai...@gmail.com wrote: Dear Members I have some problem with macro recording, after entering macro name, shortkut key and Store macro in : Personal Macro Workbook Message appears *Personal Macro Workbook must be open in startup folder* ** Some time this message appears and some times not, Kindly help me, in this regard. REHAN BAIG -- -- 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$$ Re: trouble with multiple formulas
Why can't you use pivot table or subtotals commands instead of formulas Regards, Kishan Reddy, K. On Jul 27, 10:29 am, nkmorri...@hotmail.com nkmorri...@hotmail.com wrote: Can anyone provide me the formula/s for below query? I have four columns. Company, Product, Date and Weight. What I need to do is add up the monthly volumes per Customer/Product for each month. I have over 170,000 records that I need to sort. I've tried multiple formulas but I can't seem to work it out.Please help! Company Product Date Weight SHOULD EQUAL ABC OW 2006/07 0.2 0.2 ABC OW 2006/08 0.15 0.15 ABC OW 2006/09 0.2 - ABC OW 2006/09 0.1 0.3 ABC OC 2006/10 0.1 - ABC OC 2006/10 0.1 0.2 ABC OC 2006/11 0.3 0.3 ABC OC 2006/12 0.2 0.2 ABC OC 2007/01 0.1 - ABC OC 2007/01 0.2 0.3 ABC PL 2006/07 0.2 0.2 ABC PL 2006/08 0.2 0.2 ABC DD 2006/08 0.2 0.2 ABC PL 2007/04 0.2 - ABC PL 2007/04 0.15 0.35 ABC PL 2007/05 0.1 0.1 HEALTH OW 2007/05 0.2 0.2 HEALTH OW 2007/06 0.2 - HEALTH OW 2007/06 0.2 0.4 HEALTH OW 2007/07 0.2 - HEALTH OW 2007/07 0.1 0.3 HEALTH OW 2007/08 0.2 - HEALTH OW 2007/08 0.2 - HEALTH OW 2007/08 0.2 0.6 HEALTH OW 2007/09 0.2 0.2 HEALTH PL 2007/10 0.2 - HEALTH PL 2007/10 0.2 0.4 HEALTH PL 2007/11 0.3 - HEALTH PL 2007/11 0.2 0.5 DENTAL OC 2007/12 0.2 - DENTAL OC 2007/12 0.2 0.3 DENTAL OW 2008/01 0.15 0.15 DENTAL PL 2008/01 0.2 0.2 DENTAL DD 2008/02 0.1 - DENTAL DD 2008/02 0.2 0.3 DENTAL DD 2008/03 0.2 - DENTAL DD 2008/03 0.2 0.4 DENTAL DD 2008/04 0.1 0.1 -- -- 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$$ Re: Remove selected cell contents
use the following formula in adjucant cell. for example if your data is in column B2 then in C2 copy and paste the following formula. =RIGHT(B2,LEN(B2)-FIND($,B2)+1) once you got all the values in column C 1. copy the contents in column C 2. use Edit - Paste special - values to paste them back in column B Simple. Bye Kishan Reddy, K. On Jul 27, 9:42 pm, flebber flebber.c...@gmail.com wrote: I have a column containing cells which house several delimited values and a dollar value. I want to be able to remove the delimited values and leave the dollar value in the cell in currency format. the cells contain information similar to 22-7-4-7 $22400.10 -- -- 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$$ Re: Urgent help Invoice Macro modification
Code is not opening, The password might be wrong. Kishan Reddy, K On Jul 27, 10:21 am, Nagendra Modupalli naga14...@gmail.com wrote: Hi Team, I have Invoices printing macro.It is printing row wise.I want to modify customer wise.Can you please help me.Thanks in advance. And also i have attached my macro file. For example if it is two columns same customer it has to print one invoice and in this two column only it will change Invoice number and amt and i have attached Example file. Password is STPIInvoices -- ThanksRegards Nagendra.M Tel#91 9900516251 -- ThanksRegards Nagendra.M Beautiful photos are developed by negatives in a dark room, so if U see darkness in Ur life believe that God is making a beautiful future for U !!! Macro_STPI Invoice(Annexures).zip 1495KViewDownload Example.xls 38KViewDownload -- -- 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$$ Re: Help with Date
Dear Hari Nair, If the values in quality column are unique then copy and paste the following formula in column G2 =VLOOKUP(E2,RATE!$C$2:$D$8,2,FALSE) for best performance sort the Rate sheet on quality column. Kishan Reddy, K. On Jul 22, 4:20 pm, HARI NAIR hari.shrin...@gmail.com wrote: Dear Friends, I want rate automatically comes from rate sheet in Data sheet when I enter the remaining details in the attached file, please help, Thanks in advance Regards, Hari PR.xls 18KViewDownload -- -- 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$$ Re: excel help
col_index_num is mandatory for vlookup function, range_lookup is optional. If range_lookup is not given it will take it as TRUE. One important point for using Vlookup is that the table array should be sorted on the first column. On Jul 21, 8:31 pm, preeti vora preeti86v...@gmail.com wrote: Hi team, when we do vlookup is that possible without col_index_num and range_lookup for use vlookup..or can we use any other function instead of vlookup... -- Regards, Preeti Vora. -- -- 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$$ Re: VBA code for importing data from excel to Access table
Hello, Very simple. Select the macros tab. click on the new button. Macro window will appear. In actions column select 'TRANSFERSPREADSHEET'. In action arguments column - specify transfer type, spreadsheet type, table name into which data to be exchanged, excel file name with path, if the excel sheet is having header row in first column - set Has field names to yes. If you want to import only specified range from excle then mention the range. Just save it and name it accordingly. Then select the macro and say RUN. the macro will be executed. If you still have a problem, send me the excel file and access DB to me. Regards, Kishan Reddy, K kishanreddy.kethire...@gmail.com On Jul 19, 10:20 am, debasish debasis...@gmail.com wrote: I am a novice in macro... could you please elaborate more on this.. Thanks regards, Debasish On Jul 18, 8:40 pm, Kishan K kishanreddy.kethire...@gmail.com wrote: Hi, In access, try to create a MACRO with action TRANSFERSPREADSHEET. Regards, Kishan Reddy K. kishanreddy.kethire...@gmail.com On Jul 16, 12:29 pm, debasish debasis...@gmail.com wrote: Hello Everybody, I am working on a access database where in I have to import data from excel data on daily basis. I need a code so that i can update my access table with my excel file daily. Please help regards, Debasish- Hide quoted text - - Show quoted text - -- -- 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$$ Re: Need Help of Graph Making
Remove the heading date in column a1 select the data and go to menu - insert - chart.. follow the wizard. regards, Kishan Reddy, K On Jul 18, 4:59 pm, VILAS CHAVAN vilaschav...@gmail.com wrote: Hello All I need Help to Making Chart with time and date on Date and Time Please Help me -- With Best Regards, Vilas Chavan Email : cvi...@ymail.com, vilaschav...@gmail.com Mumbai - Maharashtra 9967458882 Need Graph.xls 24KViewDownload -- -- 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