On 12/10/09, excel-macros@googlegroups.com <excel-macros@googlegroups.com> wrote: > ============================================================================= > Today's Topic Summary > ============================================================================= > > Group: excel-macros@googlegroups.com > Url: http://groups.google.com/group/excel-macros/topics > > - Very Urgent::Excel function to assign the 3rd substring of a string to a > variable [3 Updates] > http://groups.google.com/group/excel-macros/t/b414626035a9065 > - Need help to select the data columns into pivot table data field using > VBA code..... [1 Update] > http://groups.google.com/group/excel-macros/t/f5a0e4415b5d7a06 > - Getting the maximum along rows and place they occured [3 Updates] > http://groups.google.com/group/excel-macros/t/4945f3ba289c7644 > - Add brwose button to MS Excel to retrieve data from MS Access 2007 [5 > Updates] > http://groups.google.com/group/excel-macros/t/f6b5e1d8715b777a > - convert lotus file to excel [2 Updates] > http://groups.google.com/group/excel-macros/t/533de4c277552546 > - Require help on a condition [1 Update] > http://groups.google.com/group/excel-macros/t/f13d4f8b596cd932 > - Need marco to take the print out of Web Page [1 Update] > http://groups.google.com/group/excel-macros/t/402c6bdb2f78688f > - VBA Security - Restrict Users from Editing VBA Macros [1 Update] > http://groups.google.com/group/excel-macros/t/1813da1787eb9c3d > - A Simple VBA Query [1 Update] > http://groups.google.com/group/excel-macros/t/534407c8ee50ca68 > > > ============================================================================= > Topic: Very Urgent::Excel function to assign the 3rd substring of a string > to a variable > Url: http://groups.google.com/group/excel-macros/t/b414626035a9065 > ============================================================================= > > ---------- 1 of 3 ---------- > From: bharghav r <bhargha...@gmail.com> > Date: Dec 09 05:56PM +0530 > Url: http://groups.google.com/group/excel-macros/msg/25b5bf3adfd46ba0 > > All, > > I am looking at a function which can search for the 3rd word(substring) in a > string. > > Example: > > Data for abc 07 => abc > Data for fgdg 09 =>fgdg > > > > > -- > Thanks and Regards > > Bharghav R > > > ---------- 2 of 3 ---------- > From: Aindril De <aind...@gmail.com> > Date: Dec 09 10:45PM +0700 > Url: http://groups.google.com/group/excel-macros/msg/1b7a1209ecb08020 > > Hi Bharghav, > > Try this in any cell other than A1, > Suppose A1 contains the text Data for abc 07 > > =MID(A1,FIND(" ",A1,(FIND(" ",A1,1)+1))+1,(FIND(" ",A1,FIND(" ",A1,(FIND(" > ",A1,1)+1))+1)-FIND(" ",A1,(FIND(" ",A1,1)+1))-1)) > Regards, > Andy > > > ---------- 3 of 3 ---------- > From: bharghav r <bhargha...@gmail.com> > Date: Dec 09 09:19PM +0530 > Url: http://groups.google.com/group/excel-macros/msg/b5fac7f35234e28c > > Thanx Andy . > > > -- > Thanks and Regards > > Bharghav R > > > > ============================================================================= > Topic: Need help to select the data columns into pivot table data field > using VBA code..... > Url: http://groups.google.com/group/excel-macros/t/f5a0e4415b5d7a06 > ============================================================================= > > ---------- 1 of 1 ---------- > From: Mathan <mathan4s...@gmail.com> > Date: Dec 09 04:29PM +0530 > Url: http://groups.google.com/group/excel-macros/msg/28d4d568d3461b5c > > Dear All, > > Could you please help me out in this? > > In attached file I need to select all the data from column "C" to "Y" into > data field in pivot table using VBA code. > > It is very hard to drag all the items. e.g.) If we have more > than 100 coulmns. > > Thanks in advance for your quick reply. > > Regards, > Mathan > > > > ============================================================================= > Topic: Getting the maximum along rows and place they occured > Url: http://groups.google.com/group/excel-macros/t/4945f3ba289c7644 > ============================================================================= > > ---------- 1 of 3 ---------- > From: Mammo <debebe...@gmail.com> > Date: Dec 08 11:14AM -0800 > Url: http://groups.google.com/group/excel-macros/msg/58559039a9cc5213 > > I have a 15 by 10 matrix defined as an array. > > For each 15 row, I would like to get the maximum value and te column > number at which this maximum value occurs. > > How can I make a vba macro for this? > > I appreciate your help. > > M. > > > ---------- 2 of 3 ---------- > From: Paul Schreiner <schreiner_p...@att.net> > Date: Dec 09 06:25AM -0800 > Url: http://groups.google.com/group/excel-macros/msg/d4d9e2e8faaa4c38 > > Are you SURE you want a macro? > the =max function could return the maximum value in the row. > I'll have to test it, but the =hlookup function > should be able to return the column heading. > if you want the column NUMBER, then you could put the > numbers in the first row of the matrix... > > if you want a macro.. > Assuming the rows are 1-15 and columns are in 2-11 > and you want the maximum value and column number in column 1... > > sub maxtest() > dim R, C, maxval, maxcol > maxval= 0 > maxcol = "" > for R = 1 to 15 > for C = 2 to 11 > if (cells(R,C).value > maxval) then > maxval = cells(R,C).value > maxcol = C > end if > next C > cells(R,1) = maxval & ":" & maxcol > next R > end sub > > Paul > > > > ________________________________ > From: Mammo <debebe...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tue, December 8, 2009 2:14:16 PM > Subject: $$Excel-Macros$$ Getting the maximum along rows and place they > occured > > I have a 15 by 10 matrix defined as an array. > > For each 15 row, I would like to get the maximum value and te column > number at which this maximum value occurs. > > How can I make a vba macro for this? > > I appreciate your help. > > M. > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > > > ---------- 3 of 3 ---------- > From: Paul Schreiner <schreiner_p...@att.net> > Date: Dec 09 06:45AM -0800 > Url: http://groups.google.com/group/excel-macros/msg/95159738e9b19018 > > OK.. I tested the use of the hlookup > (I'm usually using vlookup, so I don't have much practice) > I put the column numbers in row 16. > This formula finds the maximum value in the row and returns the > column number from row 16. > =HLOOKUP(MAX(B1:K1),B1:$K$16,ROWS(B1:$K$16),FALSE) > > if you want the result to read something like: > > Column 1, MAX = 937 > then you can use: > > ="Column " & HLOOKUP(MAX(B1:K1),B1:$K$16,ROWS(B1:$K$16),FALSE) & ", Max= " & > MAX(B1:K1) > > had to make a minor adjustment to the macro: > > > Sub maxtest() > Dim R, C, maxval, maxcol > For R = 1 To 15 > maxval = 0 > maxcol = "" > For C = 2 To 11 > If (Cells(R, C).Value > maxval) Then > maxval = Cells(R, C).Value > maxcol = C > End If > Next C > Cells(R, 1) = "Column " & maxcol & ", Max= " & maxval > Next R > End Sub > > hope this helps (hth) > > Paul > > > > ________________________________ > From: Paul Schreiner <schreiner_p...@att.net> > To: excel-macros@googlegroups.com > Sent: Wed, December 9, 2009 9:25:02 AM > Subject: Re: $$Excel-Macros$$ Getting the maximum along rows and place they > occured > > > Are you SURE you want a macro? > the =max function could return the maximum value in the row. > I'll have to test it, but the =hlookup function > should be able to return the column heading. > if you want the column NUMBER, then you could put the > numbers in the first row of the matrix... > > if you want a macro.. > Assuming the rows are 1-15 and columns are in 2-11 > and you want the maximum value and column number in column 1... > > sub maxtest() > dim R, C, maxval, maxcol > maxval= 0 > maxcol = "" > for R = 1 to 15 > for C = 2 to 11 > if (cells(R,C).value > maxval) then > maxval = cells(R,C).value > maxcol = C > end if > next C > cells(R,1) = maxval & ":" & maxcol > next R > end sub > > Paul > > > > ________________________________ > From: Mammo <debebe...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tue, December 8, 2009 2:14:16 PM > Subject: $$Excel-Macros$$ Getting the maximum along rows and place they > occured > > I have a 15 by 10 matrix defined as an array. > > For each 15 row, I would like to get the maximum value and te column > number at which this maximum value occurs. > > How can I make a vba macro for this? > > I appreciate your help. > > M. > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > > > > ============================================================================= > Topic: Add brwose button to MS Excel to retrieve data from MS Access 2007 > Url: http://groups.google.com/group/excel-macros/t/f6b5e1d8715b777a > ============================================================================= > > ---------- 1 of 5 ---------- > From: Chanti-Hyderabad <ramesh1...@gmail.com> > Date: Dec 08 12:46PM -0800 > Url: http://groups.google.com/group/excel-macros/msg/e4e867805b6d0381 > > Hi Deepak, > > Thank you for responding. I agree with Paul and I am really very sorry > to post such a confusing request. > > In fact I am looking for a macro which can pull data from a access > file. I think you tool might help me. Request you to send the code. > let me try this out. > > Thanks again > Ramesh > > > > ---------- 2 of 5 ---------- > From: Chanti-Hyderabad <ramesh1...@gmail.com> > Date: Dec 08 12:56PM -0800 > Url: http://groups.google.com/group/excel-macros/msg/942d38588845be4d > > Hi Paul, > > Hope you are doing well. > > Yes I agree with you, and let me apologize for the the vague request. > > You guessed it right, i have a Access database and a excel report..i > want to pull certain fields from the access table. > > It is not that i want a button, if that can happen even in background > would be fine. > > Hope i made my request clear this time. > > Sorry Paul. > > Best regards, > Ramesh > > > > > ---------- 3 of 5 ---------- > From: Chanti-Hyderabad <ramesh1...@gmail.com> > Date: Dec 08 12:58PM -0800 > Url: http://groups.google.com/group/excel-macros/msg/3cbcdc4d04e7e7c3 > > Hope you are doing well. > > Yes I agree with you, and let me apologize for the the vague request. > > You guessed it right, i have a Access database and a excel report..i > want to pull certain fields from the access table. > > It is not that i want a button, but even if a code can extract from > background would be fine. > > Hope i made my request clear this time. > > Sorry Paul. > > Best regards, > Ramesh > > > > ---------- 4 of 5 ---------- > From: Deepak Rai <daksh1...@gmail.com> > Date: Dec 09 04:02PM +0530 > Url: http://groups.google.com/group/excel-macros/msg/a23fc2188242af3b > > Hi, > > Please find the below code for reference: > > > Sub ADOFromExcelToAccess() > > ' exports data from the active worksheet to a table in an Access database > > ' this procedure must be edited before use > > Dim cn As ADODB.Connection, rs As ADODB.Recordset, r As Long > > ' connect to the Access database > > Set cn = New ADODB.Connection > > cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & _ > > "Data Source=C:\FolderName\DataBaseName.mdb;" ‘this is the path of > your access database. > > > > ' open a recordset > > Set rs = New ADODB.Recordset > > rs.Open "TableName", cn, adOpenKeyset, adLockOptimistic, adCmdTable > > ' all records in a table > > r = 3 ' the start row in the worksheet > > Do While Len(Range("A" & r).Formula) > 0 > > ' repeat until first empty cell in column A > > With rs > > .AddNew ' create a new record > > ' add values to each field in the record > > .Fields("FieldName1") = Range("A" & r).Value > > .Fields("FieldName2") = Range("B" & r).Value > > .Fields("FieldNameN") = Range("C" & r).Value > > ' add more fields if necessary... > > .Update ' stores the new record > > End With > > r = r + 1 ' next row > > Loop > > rs.Close > > Set rs = Nothing > > cn.Close > > Set cn = Nothing > > End Sub > > The macro example assumes that your VBA project has added a reference to the > ADO object library. > You can do this from within the VBE by selecting the menu Tools, References > and selecting Microsoft > ActiveX Data Objects x.x Object Library. > Use ADO if you can choose between ADO and DAO for data import or export. > Hope this above code will help. Please do let me know incase I can provide > any further help on it. > > Regards, > > Deepak > > > -- > Thanks, > > Deepak Rai > > > ---------- 5 of 5 ---------- > From: Paul Schreiner <schreiner_p...@att.net> > Date: Dec 09 06:02AM -0800 > Url: http://groups.google.com/group/excel-macros/msg/fe424819eaf18635 > > If you're wanting to REPORT from Access... > it's fairly simple! > > You just need to define an external data source. > Excel lets you define the tables and join conditions > that you need and the fields you want to retrieve. > it then inserts the data in a sheet. > > the nice thing is that you can "refresh" the data > any time and it will re-issue the query. > > What version of excel are you using? > I can help you locate the help screens for External data. > > Now, if you're wanting to UPDATE the Access data, > that's a little more difficult. > > Paul > > > > > ________________________________ > From: Chanti-Hyderabad <ramesh1...@gmail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tue, December 8, 2009 3:58:17 PM > Subject: Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve > data from MS Access 2007 > > > Hope you are doing well. > > Yes I agree with you, and let me apologize for the the vague request. > > You guessed it right, i have a Access database and a excel report..i > want to pull certain fields from the access table. > > It is not that i want a button, but even if a code can extract from > background would be fine. > > Hope i made my request clear this time. > > Sorry Paul. > > Best regards, > Ramesh > >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group. Our goal is to have 10,000 >> subscribers by the end of 2009. Let friends and co-workers know they can >> subscribe to group athttp://groups.google.com/group/excel-macros/subscribe > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > > > > ============================================================================= > Topic: convert lotus file to excel > Url: http://groups.google.com/group/excel-macros/t/533de4c277552546 > ============================================================================= > > ---------- 1 of 2 ---------- > From: Tommy <jntwh...@verizon.net> > Date: Dec 08 08:42PM -0800 > Url: http://groups.google.com/group/excel-macros/msg/2e42825e64fea7a5 > > I am using an old version of Lotus (.wk4). I would like to convert > all of my files (Many!) to Excel. What do you recommend? Thanks. > > > ---------- 2 of 2 ---------- > From: Paul Schreiner <schreiner_p...@att.net> > Date: Dec 09 05:57AM -0800 > Url: http://groups.google.com/group/excel-macros/msg/e0a4fb9274c7189e > > Define: "Many" (approximately) > > Because: To ME, "many" in this context is > 250 > while to some, the thought of calling up each file > and saving it as a csv or txt file for more than > 50 is "many". > > I once had to open and add a confidentiality "stamp" > to 2500 images. > I had to do it manually, because it had to place the > stamp in an area that wouldn't obscure part of the image. > Sure, the task was onerous and mind-numbing. > > In your case, however, if you were needing to convert > several thousand files, then it might be advisable to > seek a means to automate the process. > > Otherwise, make yourself a gallon of coffee and get > ready to be numbbed... > > Now, on a serious side... we should start over: > ----------------------------- > What version of Excel are you using? > A quick look at Excel2007 looks like it no longer > supports opening Lotus123 workbooks. > But Excel2003 (Office97) MAY (can someone check?) > > Do you have the Lotus123 application installed? > or are these ancient files you're recently unearthed > in an archeological dig? > (you've finished scanning the stone tablets, > given the papyrus to others and chosen to > tackle the truly difficult task yourself) > > Depending on the answers to the above questions, > your options vary. > > Let's get these answers before I digress even more! > > Paul > > > > > > > ________________________________ > From: Tommy <jntwh...@verizon.net> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Tue, December 8, 2009 11:42:48 PM > Subject: $$Excel-Macros$$ convert lotus file to excel > > I am using an old version of Lotus (.wk4). I would like to convert > all of my files (Many!) to Excel. What do you recommend? Thanks. > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > > > > ============================================================================= > Topic: Require help on a condition > Url: http://groups.google.com/group/excel-macros/t/f13d4f8b596cd932 > ============================================================================= > > ---------- 1 of 1 ---------- > From: "Chandra Gupt Kumar" <kumar.bemlmum...@gmail.com> > Date: Dec 09 02:40PM +0530 > Url: http://groups.google.com/group/excel-macros/msg/fc2b33acd36549dc > > Dear Pooja Jee, > > > > Hope the solution provided by Dave serves the purpose. > > > > Regards, > > > > C.G.Kumar > > From: Dave Bonallack [mailto:davebonall...@hotmail.com] > Sent: Friday, November 20, 2009 9:57 AM > To: excel-macros@googlegroups.com > Subject: RE: $$Excel-Macros$$ Require help on a condition > > > > Hi Pooja, > Does the attached do what you need? > Regards - Dave. > > > _____ > > Date: Thu, 19 Nov 2009 13:35:28 +0530 > Subject: $$Excel-Macros$$ Require help on a condition > From: vatspoojav...@gmail.com > To: excel-macros@googlegroups.com > > Hi All, > > I've attached a file in which, a data is mentioned with the required > solution. If any body can help me in this, it will be of great help. > > -- > Best Regards > Pooja Sharma > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com <http://www.excelitems.com/> > 2. Excel tutorials at http://www.excel-macros.blogspot.com > <http://www.excel-macros.blogspot.com/> > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > <http://www.vbamacros.blogspot.com/> > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > <http://exceldailytip.blogspot.com/> > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > > _____ > > With all the lastest places, searching has never been easier. Look now! > Looking <http://clk.atdmt.com/NMN/go/157631292/direct/01/> to move this > spring? > > -- > ---------------------------------------------------------------------------- > ------ > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe > > > > ============================================================================= > Topic: Need marco to take the print out of Web Page > Url: http://groups.google.com/group/excel-macros/t/402c6bdb2f78688f > ============================================================================= > > ---------- 1 of 1 ---------- > From: Mahesh <mahender.bi...@gmail.com> > Date: Dec 09 09:55AM +0530 > Url: http://groups.google.com/group/excel-macros/msg/e165100f3040ca4 > > Dear Friends, > > Please help???????? > > > -- > With Love, > Mahesh Bisht > > > > ============================================================================= > Topic: VBA Security - Restrict Users from Editing VBA Macros > Url: http://groups.google.com/group/excel-macros/t/1813da1787eb9c3d > ============================================================================= > > ---------- 1 of 1 ---------- > From: Vinod N <nvino...@gmail.com> > Date: Dec 09 02:04AM +0530 > Url: http://groups.google.com/group/excel-macros/msg/ed43eec4e6be0c3b > > Hi, > > Can you suggest any site which will help me in breaking/cracking the > password.... ? A year back i had created few macros..but ironically i have > forgotten the password and the macros need to be changed with course of time > and environment... > > Thanks > > Vinod N > > > -- > Thanks and Regards > > Vinod N > > > > ============================================================================= > Topic: A Simple VBA Query > Url: http://groups.google.com/group/excel-macros/t/534407c8ee50ca68 > ============================================================================= > > ---------- 1 of 1 ---------- > From: Abhishek Jain <abhishek....@gmail.com> > Date: Dec 08 08:31PM +0530 > Url: http://groups.google.com/group/excel-macros/msg/d3f27e6023d11481 > > Hi all, > > First of all I am very sorry to bother this group so much. > > I am trying to write a code but I don't know any thing about coding (all > right, you can laugh on this). I prefer searching Internet > for codes/solutions and then to use it. Recording Macros, Excel Help are my > other helping hands. > > Here is my query - > > There are 03 people - Name1, Name2 and Name3. These 03 people shares > expenses done for a cause that is bearable by at least 02 of them. Example - > If Name1 spends Rs. 300/- for a Dinner, it will be divided between atleast > 02 people (Name1 and Name2 or Name2 and Name3) or between all of them and > the cost would be divided between those who ate the dinner. (Expenses done > by any of these 03 which are not spent for atleast 02 of them, are > disregarded). > > I have prepared all necessary spreadsheet, forms, etc. to record these > transactions and they are working pretty fine. Now these transactions get > recorded for a month and at the end of the month all 03 adjust and > settle the differential amount. It almost never happens that all of them > spend the exact amount equal to their share, hence, these are the common > scenarios - > >> At the end of the month, there would be atleast one payer who will pay > certain amount to either 1 person or 2. >> There can be 02 payers who would pay to one person. > > Here is the example of the summary at the end of the month - > A B > C D > 1 Name of user Expenses borne > Share Stands > 2 Name1 2000/- > 1500/- +500/- > 3 Name2 1000/- > 2100/- -1100/- > 4 Name3 1600/- > 1000/- +600/- > 5 > 6 Total - 4600/- > 4600/- > > In this situation - Name2 will pay Rs. 500/- to Name1 and Rs. 600/- to > Name3. At the end of the month I want a Message Box stating this - > > Name2 has to Pay Rs. 500/- to Name1. > Name2 has to pay Rs. 600/- to Name3. > > then an input box for payments entry and updation in the workbook- I will do > coding for this myself. > > Suppose Name2 has paid Rs. 400/- to Name1 and Rs. 200/- to Name3. So the > next time the Message box should say - > > Name2 has to Pay Rs. 100/- to Name1. > Name2 has to pay Rs. 500/- to Name3. > > This will continue till the amount is settled. I tried and put some if > conditions, it is working for the scene of 02 payers and 01 payee but not in > case to 01 payer and 02 payees. I have also not wrote it further to adjust > amount till it settles. All I want is a code to prompt this Msgbox given the > conditions/scenerios above. > > I am again sorry for being so long but this will help me to learn to write > codes like this. > > > Thanks in advance. > > Best regards, > > Abhishek Jain > > > > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 2. Excel tutorials at http://www.excel-macros.blogspot.com > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com > 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com or > Ashish Jain @ 26may.1...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group. Our goal is to have 10,000 > subscribers by the end of 2009. Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe
-- Sent from my mobile device -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
