Re: $$Excel-Macros$$ Re: delete workbook if password is not entered

2011-05-05 Thread C.G.Kumar
Hi Sam, The reader has sought for code to delete file if Password doesn't matches in three attempts. You have provided code to delete file without prompting for password match by oversight. Hope you will be amend the same. Regards, C.G.Kumar On Thu, May 5, 2011 at 1:58 AM, GoldenLance

$$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

2011-05-05 Thread Pravin Kumar
Folk I have different workbook with different name in different folder. the workbook name will be like SC231WK34, SC231WK35, SC231WK36 etc. all the sheet will be in the same format. is there any way to write vlookup where I can link the part of the name to any of cell.

Re: $$Excel-Macros$$ Excel on Mobile

2011-05-05 Thread rajan verma
http://download.cnet.com/Mobile-Excel-2004/3000-2064_4-10286226.html http://download.cnet.com/Mobile-Excel-2004/3000-2064_4-10286226.html On Tue, May 3, 2011 at 7:55 PM, Kantilal Badale kantilal.bad...@gmail.comwrote: Dear All Experts I am using HTC Incredible S Mobile (Android) Please

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

2011-05-05 Thread NOORAIN ANSARI
Dear Pravin, Please try it. =IFERROR(VLOOKUP(H17,[SCWK23134 .xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK35 .xls]Sheet1!$I$5:$K$20,H$15,0),IFERROR(VLOOKUP(H17,[SC231WK36 .xls]Sheet1!$I$5:$K$20,H$15,0),))) On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar

RE: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

2011-05-05 Thread Dave Bonallack
Hi Pravin, You could try using the INDIRECT function VLOOKUP(H17,INDIRECT([SC231WKA134.xls]Sheet1!$I$5:$K$20),H$15,0) Change the A1 ref to the cell that holds the book number you want Please note that I haven't tested this. I haven't tried VLOOKUP with INDIRECT before. Regards - Dave Date:

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

2011-05-05 Thread rajan verma
You can use Indirect Function for the same... VLOOKUP(H17,indirect(SC231WK34.xls]Sheet1!)$I$5:$K$20,H$15,0) On Thu, May 5, 2011 at 12:47 PM, Pravin Kumar pravin.si...@gmail.comwrote: Folk I have different workbook with different name in different folder. the workbook name will be like

$$Excel-Macros$$ Why can't I put an Excel workbook into protected status?

2011-05-05 Thread GregDC
Using Excel 2010 I have an excel workbook that we send to people, it contains several backend tables that we don't want them messing with. If I save the workbook as a .XLS it protects fine. However, we have some people with only open office. the workbook works fine as a .ODS, but it will not

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-05 Thread ashish koul
see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one

Re: $$Excel-Macros$$ data merged

2011-05-05 Thread ashish koul
hi save all your daily files in a single folder and try code on below links. see if it helps http://akoul.blogspot.com/search/label/Merge%20Data%20from%20sheet%201%20from%20multiple%20workbooks%20to%20single%20workbook

Re: $$Excel-Macros$$ data merged

2011-05-05 Thread ashish koul
or try this Sub sw() Application.ScreenUpdating = False Dim i As Long Dim s As Workbook Set s = Workbooks.Open(Application.GetOpenFilename) ThisWorkbook.Activate ThisWorkbook.Sheets(1).Rows(2: Sheets(1).Range(a1).End(xlDown).Row).Copy s.Activate s.Sheets(1).Range(a65356).End(xlUp).Offset(1,

Re: $$Excel-Macros$$ Calculate Due dates

2011-05-05 Thread ashish koul
try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining

Re: $$Excel-Macros$$ VLOOKUP(H17,[231.xls]Sheet1!$I$5:$K$20,H$15,0)

2011-05-05 Thread pravin . simsr
My friend I'll have data for all 34 35-53 soi there will be no error Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Date: Thu, 5 May 2011 18:04:26 To: Pravin Kumarpravin.si...@gmail.com; excel-macros@googlegroups.com Subject: Re:

Re: $$Excel-Macros$$ Re: delete workbook if password is not entered

2011-05-05 Thread GoldenLance
Thanks for highlighting my mistake C.G.Kumar. My apologies. Please find the entire code sought by reader. Sub TPWD() Static lngWrongPasswordCounter As Long Const strPWD = Password Dim strUserPassedPassword As String strUserPassedPassword = InputBox(Please enter password)

$$Excel-Macros$$ Copy Paste next blank row

2011-05-05 Thread Bob
I'm sorry , Still having trouble with copy on next available blank row. If I record a macro it's: Columns(A:E).Select Selection.Copy Sheets(Customer Record).Select ActiveSheet.Paste I want to keep what I have already copied. How do I make it go to the next available blank row. Thanks

Re: $$Excel-Macros$$ Copy Paste next blank row

2011-05-05 Thread ashish koul
can you share the sample file On Fri, May 6, 2011 at 5:22 AM, Bob bobandrich...@comcast.net wrote: I'm sorry , Still having trouble with copy on next available blank row. If I record a macro it's: Columns(A:E).Select Selection.Copy Sheets(Customer Record).Select ActiveSheet.Paste

Fwd: $$Excel-Macros$$ Copy Paste next blank row

2011-05-05 Thread NOORAIN ANSARI
-- Forwarded message -- From: Bob bobandrich...@comcast.net Date: Fri, May 6, 2011 at 5:22 AM Subject: $$Excel-Macros$$ Copy Paste next blank row To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com I'm sorry , Still having trouble with copy on next available blank row. If