My pleaseure.
Dave
Date: Fri, 16 Jul 2010 10:30:44 +0530
Subject: Re: $$Excel-Macros$$ Using Excel to Control Shapes Drawn In A Workbook
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Dave,
Really attached sheet is imagingSpecial Thanks from my side too.
With
Thanks Ayush. . !!
Thanks for the lovely group, the opportunities to learn n to help others.
Big thanks to all the members of the group for sharing their queries /
solutions.
Best Regards,
DiLipandey
On 7/16/10, Ayush wrote:
> Hi Dilip,
>
> You always make me feel proud by your dedication towa
Hi,
I've just checked the sheet you have attached. Following problems were
there:
1. You have entered time in different formats i.e. the formatting in
column C is not consistent.
2. Excel treats date and time as a number not as time so the
multiplication that you do in column D will never give pro
Thanks. The Find option did not show any prior instances of the
variable occurring. The MsgBox idea gave me an error when I ran the
macro. I did find that in the Debug menu there are two things that
helped: "Add watch" gives an indicator when the value changes. When
running the macro, the firs
Thanks once more Gaurav for your help.
Leandro
On 16 jul, 11:32, GAURAV JAIN wrote:
> Hi Leandro,
>
> For this,
>
> I created one text box & button in my vsto form.
>
> Go to button and Click it.Then write this code.
>
> Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
> AsSystem.
Hi team,
Team I have a challenge, attached .xls file provides an example of roster
timetable which am monitoring. Each column contain names for different
employees and rows are dates, some cells in columns contain R and some B. R
= going leave, B = back to leave.
How can I automate email alert on
This doesn't work. It returns #VALUE! Thanks for trying.
From: Soni.Rajender
To: MS EXCEL AND VBA MACROS
Sent: Wed, July 14, 2010 8:57:16 PM
Subject: $$Excel-Macros$$ Re: Index match with 3 criteria
Hi
You can use the below formulae:
=IF(AND(A1=Sheet1!A1,
yr excel file VBA coding is password protected, how we can see the
programing behind
On Thu, Jul 15, 2010 at 8:07 PM, Nimesh Patel wrote:
> Hello everybody,
> *Now, Finish your 5 hours work just in 5 minutes in Excel*
>
> *You must be Surprised now, correct? ……No need to be….
> *
> *This is how
Hi Leandro,
For this,
I created one text box & button in my vsto form.
Go to button and Click it.Then write this code.
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e
AsSystem.EventArgs)
Handles Button1.Click
Dim x As Integer
x = TextBox1.Text
Globals.Sheet1.Range("A1:D1").
More information: I just played with it a little. Now, I can see
that it is suck on the first filter. It never changes. And this is
on the simple spreadsheet that I thought was working.
On Jul 16, 8:40 am, Ty wrote:
> My problem: Sometimes when I change my Report Filter to 1 of the 25
> fiel
Hi Dilip,
You always make me feel proud by your dedication towards the group.
Hats off to your knowledge and skills.
We all are your fan and look forward for your long association with
the group.
Best Regards,
Ayush Jain
Group Manager.
On Jul 14, 10:30 am, Mathan wrote:
> Hi Dilip,
>
> I hav
My problem: Sometimes when I change my Report Filter to 1 of the 25
fields in some of my spreadsheets the Row Labels and Values do not
change for that Filter.
My current solution: Go into the filter and manually check off the
columns/cells/data after checking the sheet to see what shows up on
th
I think u can use hlook up
Sent on my BlackBerry® from Vodafone
-Original Message-
From: geejesh
Sender: excel-macros@googlegroups.com
Date: Fri, 16 Jul 2010 16:55:33
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Link
Hi all,
Is there a way by which we can figu
Thanks Gaurav for reply. The form loaded right, the first doubt was
solved.
I have another one, maybe you can help me too. I have a button in this
form. I wold like to use the "click" event of this button to acquire
data from
user, put this data in a range of one sheet and them get some data
from
Hi all,
Is there a way by which we can figure out a specific name in many excel
documents contained in a particular folder.
Suppose a folder contains many excel documents with a specific reference
like a code.
Can a particular person figure out a name with the help of this code.
I believe Vlook
Dear Kishanreddy,
Thank you very much for your tip, the disclosed tip saves my clerical work
time a lot..!
Thank you once again.
And also I would like to take this opportunity to thank all the EXPERTS in
this excel macro group who are not only helping to "N" no.of members in
their p
Hello Everybody,
I am working on a access database where in I have to import data from
excel data on daily basis. I need a code so that i can update my
access table with my excel file daily.
Please help
regards,
Debasish
--
-
You Can go to the excel options button and go to save as and save the the
file in Excel 97-2003 format.After saving that you can open you excel 2007
file in older versions also.
Vijaykumar
On Thu, Jul 15, 2010 at 6:08 PM, Vijay Aggarwal wrote:
> Hi All,
>
> If I am receiving a file in exce
Hi Leandro,
Use this Code:
*Dim frm as New Form_Name*
*frm.ShowDialog*
This code will work for u.
Cheers,
Gaurav Jain
On Thu, Jul 15, 2010 at 9:15 PM, Leandro wrote:
> I am new in VSTO and have a doubt.
>
> I´ve created a project using VS2008. This is a VSTO in fact. I have
> a workbook with
HI IS THAT ANY FORMULA WHEN WE WRIGHT NUMERICAL AMOUNT AND WANT TO CONVERT
IN WORD. ANY BODY KNOW FORMULA ???
E.G = 25 ( TWENTY FIVE)
On Thu, Jul 15, 2010 at 12:48 PM, Kishanreddy Kethireddy <
kishanreddy.kethire...@gmail.com> wrote:
> Hi,
>
> You can use iserror() function to find out an
Dear Dave,
Really attached sheet is imagingSpecial Thanks from my side too.
With Thanks,
Noorain Ansari
On Fri, Jul 16, 2010 at 8:34 AM, Dave Bonallack
wrote:
> Thanks Anish.
> Dave.
>
> > Date: Thu, 15 Jul 2010 18:24:24 +
> > From: anish@gmail.com
> > Subject: RE: $$Excel-Macros$$ Us
21 matches
Mail list logo
