I have put one listbox add some '.xls' file path through inputbox and
store as a button in a toolbar.
now want to open listindex files.e.g : listbox contains 5 '.xls'-files
when am clicking file path name its opening in new workbook.can any
body help me about this?.
--~--~-~--~~--
I'm making excel macros for the first time and getting things figured
out, but I have a few questions:
What code do I use to delete columns that have all empty cells EXCEPT
the top cell (row 1) that contains any of a number of headings? I need
to insert this into an existing macro.
What code do
Dear Friends,
I am attaching a portfolio. It is a mf portfolio.
If you can pls attach a v look up function to it that would be great.
The website from where the link can come is http://www.amfiindia.com/.
Looking fwd to your help.
--~--~-~--~~~---~--~~
--
Ok yar muje file attach karke bhejo nahito link bhejo
On Sat, Oct 3, 2009 at 6:35 AM, sheetallakho...@gmail.com <
sheetallakho...@gmail.com> wrote:
>
>
> Mr. Nandkumar kakvipure ...thanks for the link...but the rar file is
> also password encrypted :) ...plz provide the password... ty
>
> From
from vbaExpress (http://www.vbaexpress.com/kb/getarticle.php?kb_id=468)
Function IsFileOpen(FileName As String)
Dim iFilenum As Long
Dim iErr As Long
On Error Resume Next
iFilenum = FreeFile()
Open FileName For Input Lock Read As #iFilenum
Close iFilenum
iErr = Err
Hi Hanumant,
Below is the code you can use to find if the workbook is already opened….
Sub CheckIfOpen()
Dim Wkbk As Workbook
Dim Filename As String
Filename = InputBox("Type the name of the file you want to check.")
For Each Wkbk In Application.Workbooks
If Wkbk.Name = Filename
Hi Huzaifa,
This is very much possible to subtract dates. Simply subtract as you
subtract no.s and format the cell as "yy-mm-dd".
This works fine provided you are subtracting dates and not text written as
date.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From:
Dear all,
I need your help in formula, i need correct formula to get daily total
salary and ot amount..
please help me.. i have send the attachment too..
Thank®ards,
Ram,
--~--~-~--~~~---~--~~
-
Mr. Nandkumar kakvipure ...thanks for the link...but the rar file is
also password encrypted :) ...plz provide the password... ty
From: Nandkumar kakvipure
Date: Fri, 2 Oct 2009 17:12:11 +0530
Local: Fri, Oct 2 2009 4:42 pm
Subject: Re: $$Excel-Macros$$ Re: PDF password CRACKER
Reply | Reply
Hi Rolf,
Thanks for responding.
I made the changes as described. Now I am getting an error "Duplicate
declaration in current scope." for statement --> Dim path as string
Please help.
Suyog
On Oct 2, 1:49 am, RolfJ wrote:
> Got it. Try declaring fso this way:
>
> Dim fso As Object
> Set
hi guys,
can somebody pls tell me how to find if the workbook is open or not.
lets say i wanna open"hanumant.xlsx" file using macro. but b4 that i wanna
check if the file is open or not. if the file is already open then i won't open
it again. and if it is not open then only i will open it.
pls i
Hi Dilip
Its really great yar
Sonia
On Wed, Sep 30, 2009 at 5:15 PM, Dilip Pandey wrote:
> Hi Aligah,
>
> I have attached an image, which has the example of using auto-filter to
> solve your query. Thanks
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan
Is it possible to subtract dates in Microsoft Excel and get the result
in yy-mm-dd format? Please help me.
Thanks
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel
Sorry Giorgio your problem is not clear if you can then attach a demo file
for it.
Regards
Sandeep
- Original Message -
From: "Giorgio"
To: "MS EXCEL AND VBA MACROS"
Sent: Friday, October 02, 2009 8:04 PM
Subject: $$Excel-Macros$$ Re: Count consecutive negative values
Ok I have a d
Hi,
Paste this formula in column E
=IF(ROW()=1,$C$1,IF(INDIRECT("C"&ROW()-1)<$D$1,INDIRECT("C"&ROW()-1)+1,""))
Regards
Sandeep
- Original Message -
From: Dilip Pandey
To: excel-macros@googlegroups.com
Sent: Friday, October 02, 2009 10:17 AM
Subject: $$Excel-Macros$$ Re: How
Hi Rohith,
Use the subtotal function as below:
If you want total for column and your column has 500 rows, write formula in
row 510 =subtotal(c1:c500,9).
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@google
Ok I have a different problem now.
In a column I am counting the consecutive days in a drawdown like
this:
I5=IF(H5=0,0,I4+1)
I6=IF(H6=0,0,I5+1)
I7=IF(H7=0,0,I6+1)
And then I look at the max number among these, being the longest
drawdown in the column.
What I need to do is to build a hystogram sh
Please let me know how to insert the page totals for a particular
column in excel sheet.
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video
Hello to all,
Please let me know how to insert the page totals for a particular
column in excel sheet.
Regards,
Rohith
--~--~-~--~~~---~--~~
--
Some important links fo
Dear group members,
Please help to to write numbers into words automatically.
for. eg. if i enter "1,250/365" in any cell then formula or code should give
me asnswer in words in any other cell "[Currency Name] Öne Thousand Two
Hundred Fifty & [Currency Name for change] 365/1000 Only"
i.e Kuwaiti
Just a word of caution here...
the use of:
dim row as Range
is STONGLY discouraged!
VBA uses "row" as a Property of a range object
(among other things).
Now, you're redefining it as a range object.
so you end up with:
row.Cells(1.1).row ??
and you're expecting the Wizards of Microsoft
to figur
Dear group members,
Please help to to write numbers into words automatically.
for. eg. if i enter "1,250/365" in any cell then formula or code should give
me asnswer in words in any other cell "[Currency Name] Öne Thousand Two
Hundred Fifty & [Currency Name for change] 365/1000 Only"
i.e Kuwaiti
In order to figure out what is "not working",
I had to duplicate some data and copy your code.
I think the problem is pretty simple.
In your countif function, you're counting ALL the cells in "aRange"
not the row you're working on!
so, replace aRange with:
Range(Cells(j, 3), Cells(j, 42))
also,
I have two comments.
1) If I correctly understand what you are trying to accomplish, you
could simply put the formula COUNTIF(AR2:CE2,1) in cell K2 and copy it
down to K3:K250.
2) It seems to me that the problem with your code is that your COUNIF
formula references the whole range (arange) not s
Hi Pooja,
Go through this videoIt will help you to count as well as sort the colored
cells.
http://www.datapigtechnologies.com/flashfiles/SortonColor.html
Let me know if this resolves your problem.
--
Regards,
Archana
--- On Tue, 9/15/09, Dave Bonallack wrote:
From: Dave Bonallack
Try Dis One
http://rapidshare.com/files/41081546/adminviet.net_PDF.Password.Remover3.0.rar
On Fri, Oct 2, 2009 at 1:51 PM, vibhav shah wrote:
> please send me password cracker application
>
>
> THANKSIN ADVANCE
>
> VIBHAV
>
> On Wed, Sep 30, 2009 at 5:03 PM, Anish Shrivastava wrote:
>
>> I
Let's clarify something.
IS the VBA CODE PASSWORD PROTECTED?
or does it simply reside at a remote location?
There's a difference between having the VBA
code "protected" and it simply being "inaccessible".
If the VBA code is password protected, and
you don't know the password, then you can't do
Yes, that's the challenge!! I can't unlock the VBA Code, because the
file resides on each user's computer. I have to send a new file with a
Macro to update it
Thanks!
CC
On Oct 1, 3:49 pm, Paul Schreiner wrote:
> If you can unlock the VBA code, then it's fairly simple
> to remove an entire m
Got it. Try declaring fso this way:
Dim fso As Object
Set fso = CreateObject("Scripting.FileSystemObject")
On Oct 1, 10:34 pm, suyog_linux wrote:
> Hi Rolf,
>
> Thanks for responding.
>
> Please find the answers below :
>
> 1. I am getting the error which says:
> "User defined type -
please send me password cracker application
THANKSIN ADVANCE
VIBHAV
On Wed, Sep 30, 2009 at 5:03 PM, Anish Shrivastava wrote:
> I have a Password Cracker application...may be I can give it a try..plz do
> send ur file..
>
> Cheers!!
> ANISH
>
> On Wed, Sep 30, 2009 at 5:00 PM, vivek agrawa
Hi c,
Before running macro, go to Tools->Sort and sort your data col A-Ascending,
Col G-Ascending, Col H-Ascending, Col K - Descending.
Let me know if this helps.
Thanks and Regards,
Upendra Singh
+91-9910227325
-Original Message-
From: excel-macros@googlegroups.com [ma
Hi Anish
Can u pls fwd the same link for cracking MS Office Passward cracker file.
I wl be thankful to yoy.
Vaibhav
On 10/1/09, Anish Shrivastava wrote:
>
> Hi Ram,
>
> Actually I got tht passware from my frnd. It works nicely to crack MS
> Office passwords (I tried on excel files and and it g
Hi Everyone,
Need some help with this macro. Basically, I am searching through
rows and looking for any values in the cells that are >0 in columns AR
- CE.
After I find these cells in that range, I need to count the number of
columns. This can be done with the COUNTIF function. I also do not
w
Hi Everyone,
Thanks for your help. I am a newbie, but I have learned alot in the
past couple of weeks.
This is the problem.
I have a spreadsheet of employee names and projects with durations in
months. Now, I would like to delete the
employees that are supporting multiple projects and only kee
Hi everyone..
Any one can provide me the password crecker for MS Office/Excel.
Actually I forget my own MS file password. :(
-
Manish
On Oct 1, 3:08 pm, Anish Shrivastava wrote:
> Hi Ram,
>
> Actually I got tht passware from my frnd. It works nicely to crack MS Office
> passwords (I tried on e
35 matches
Mail list logo
