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

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

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

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$$ convert lotus file to excel

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

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

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

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 bhargha...@gmail.com wrote:

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

Thanx Andy . On Wed, Dec 9, 2009 at 9:15 PM, Aindril De aind...@gmail.com 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))

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

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

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

Dear Friends, Please help On Tue, Dec 8, 2009 at 4:53 PM, Mahesh mahender.bi...@gmail.com wrote: Hi All, Please help on this issue On Mon, Dec 7, 2009 at 9:36 AM, Mahesh mahender.bi...@gmail.com wrote: Hi Bruce, Thanks for the help. But i need something diff.

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

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

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

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.