Actually, I might be able to help here.
I'll have to wait until I get back to work on Monday though!
Paul
From: Chechu
To: MS EXCEL AND VBA MACROS
Sent: Saturday, October 3, 2009 7:48:53 AM
Subject: $$Excel-Macros$$ Re: Macro to update another Macro?
The VB
Somehow if you have date in format hh:mm dd/mm/yy and you try to
subtract you may not get accurate results in such a case use the
following formula. Suppose your start time and date is in cell A1 and
end time and date in cell B1 in C1 type
=B1+ (A1>B1) - A1
Since on subtracting dates Excel doesn'
Assuming that you already populated the listbox (named ListBox1) with
the file path names of Excel workbooks you could place this ListBox
click event handler in the VBA module of the UserForm containing your
listbox:
Private Sub ListBox1_Click()
If Dir(ListBox1.Value) <> "" Then Workbooks.Ope
The VBA code is Password protected AND resides in a remote computer. I
developed the protected VBA Code, and I know the password. This is an
Excel tool that I sent to all my department two weeks ago, and now I
figured out that has an error in a Macro. So instead of sending a NEW
tool, I wanted to
Hi, I need your expertise on this... Example attached. I have a list of
resources with different locations. There are 3 possible locations. I need to
split the list into three different tables, one per location, and add total on
each. Number of resources is not fixed, number of locations is alw
Assuming that you already populated the listbox (named ListBox1) with
the file path names you would need to add this ListBox click event
handler to the VBA module of the UserForm containing the listbox:
Private Sub ListBox1_Click()
If Dir(ListBox1.Value) <> "" Then Workbooks.Open (ListBox1.Va
Thx a lot
Sent from my BlackBerry® smartphone from Tata Indicom
-Original Message-
From: Dilip Pandey
Date: Sat, 3 Oct 2009 15:04:03
To:
Subject: $$Excel-Macros$$ Re: Enable V Look up Option on the Excel Sheet.
Hi,
As requested, v-lookup function is incorporated in the attached workbo
It's difficult to comment on this without seeing your whole code.
Please post it and I promise to take a look,
Rolf
On Oct 2, 10:47 pm, suyog_linux wrote:
> Hi Rolf,
>
> Thanks for responding.
>
> I made the changes as described. Now I am getting an error "Duplicate
> declaration in current sco
Hi,
As requested, v-lookup function is incorporated in the attached workbook.
Note, you have to define something else instead of "fund Name" as a
base data to be looked for because the same names are appearing more than
once. For example, fund Id or fund number can work. Thanks,
--
DILIP KUMAR
Hi Giorgio,
Suggestion for you:-
Alternatively, you should post a seperate query if you have some other
point to ask. This will help group member to track the emails seperately
and they would not forget these types of new queries, assuming that it is
something related to existing same query's cha
Hi Giorgio,
Please share a test file with the "Group". Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/2/09, Giorgio wrote:
>
>
> Ok I have a different problem now.
> In a column I am counting th
Thanks Sonia,
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 10/2/09, Sonia Singla wrote:
>
> Hi Dilip
>
> Its really great yar
> Sonia
>
> On Wed, Sep 30, 2009 at 5:15 PM, Dilip Pandey wrote
12 matches
Mail list logo
