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
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.
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
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
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:
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
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
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
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
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,
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
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:
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)
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
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
-- 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
16 matches
Mail list logo