$$Excel-Macros$$ VBA Code for Locking/Unlocking excel sheet using password input form

2009-12-09 Thread punit poddar
Hi The above file will be used by two person - User and the Administrator, administrator can edit anywhere, while the user can edit only in the range specified, based on this I have done something in the file attached but would help you guys to pls help. Please find attached the excel file. 1. Fo

$$Excel-Macros$$ Re: Need help to select the data columns into pivot table data field using VBA code.....

2009-12-09 Thread nayag...@gmail.com
Hi Mathan, I used column A to determine the number of rows that should be included in the pivottable range. And I used Row 1 to determine the number of columns. I assume that the headers are all nicely valid--no duplicates and no blanks, right. And that you want Sum for each of those other fields

Fwd: $$Excel-Macros$$ Re: Need marco to take the print out of Web Page

2009-12-09 Thread Mahesh
Dear Friends, Please help On Tue, Dec 8, 2009 at 4:53 PM, Mahesh wrote: > Hi All, > > Please help on this issue > > On Mon, Dec 7, 2009 at 9:36 AM, Mahesh wrote: > >> Hi Bruce, >> >> Thanks for the help. >> >> But i need something diff. >> >> Attached is the xls with the links.

$$Excel-Macros$$ How to Protect Access Database from the Users ?

2009-12-09 Thread Deepak Rai
Hi All, I have created a Tool using Excel , Access & VBA. My both Excel GUI file & Access database is in the same folder. I want that user should not be able to open this Access Database. I need help in VBA part how to open a Access password protected database in excel. I am using ADO for database

Re: $$Excel-Macros$$ Very Urgent::Excel function to assign the 3rd substring of a string to a variable

2009-12-09 Thread bharghav r
Thanx Andy . On Wed, Dec 9, 2009 at 9:15 PM, Aindril De wrote: > 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))

Re: $$Excel-Macros$$ Very Urgent::Excel function to assign the 3rd substring of a string to a variable

2009-12-09 Thread Aindril De
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 On Wed, Dec 9, 2009 at 7:26 PM, bharghav r wrote: > All, > >

$$Excel-Macros$$ Very Urgent::Excel function to assign the 3rd substring of a string to a variable

2009-12-09 Thread bharghav r
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 -- -- Some important l

Re: $$Excel-Macros$$ Getting the maximum along rows and place they occured

2009-12-09 Thread Paul Schreiner
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 t

Re: $$Excel-Macros$$ Getting the maximum along rows and place they occured

2009-12-09 Thread Paul Schreiner
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 mac

Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007

2009-12-09 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ convert lotus file to excel

2009-12-09 Thread Paul Schreiner
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

Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007

2009-12-09 Thread Deepak Rai
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

RE: $$Excel-Macros$$ Require help on a condition

2009-12-09 Thread Chandra Gupt Kumar
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