what are you using to close the file?
normally, if you're using the .Close method
(as in: Workbooks(workbookname).Close)
you can use:
Workbooks(workbookname).Close SaveChanges:= False
Paul
From: "Randhir Singh, AGM CPM-1, LHO, CHD"
To: excel-macros@googlegr
hi all
I have written a macro which copies some data from other work-book but
before copying that data some changes are made in the file from which
data is copied. Thereafter that file (from where data is copied) is
closed without saving changes choosing the 'NO' option on message 'Do
you want to
Dear Ralf
Yes. It is working. Thanks
Yahya
On Sun, Oct 11, 2009 at 5:27 PM, RolfJ wrote:
>
> The simplest solution to this is to define names for your target
> cells.
>
> This is how you do that, e.g. for 'Ann': highlight the cell Ann in
> your Master sheet and then select Insert | Name | De
Thanks a lot Harmeet. It worked.
On Sun, Oct 11, 2009 at 2:28 PM, Harmeet Singh wrote:
> *Enter date in cell "A1" then **Use formula-
> =UPPER(TEXT(A1,"dd-mmm-"))**I hope this will solve the issue.*
>
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On
The simplest solution to this is to define names for your target
cells.
This is how you do that, e.g. for 'Ann': highlight the cell Ann in
your Master sheet and then select Insert | Name | Define; the name for
this cell automatically defaults to 'Ann' which is probably what you
want; now go to th
Hi Prashant, thanks for the effort.. I see that you have implemented
the suggestion offered by Rolf of using dateif function. but the main
problem still remains, i.e. of attributing each sale to its respective
purchase date. have you tried using my suggestion?? that of converting
the data which is
This pointer should help: http://www.ozgrid.com/Excel/run-macro-on-time.htm
On Oct 11, 1:59 am, Manish Pansari wrote:
> Hello Friends,
>
> I want to run a macro continuously after every five minutes. Is there
> any option, by using that I can set macro run time and can run macro
> automatically?
Once you include add a reference to the Microsoft Outlook library to
your VBA project (using Tools | References in VBE), you can send
messages with code like this:
Sub SendMail()
Dim objOut As Outlook.Application
Dim objMail As Outlook.MailItem
Dim strTo As String
Dim strCC As Str
I am not clear on what you want to write code for. Do you want to
eliminate the space or do you want to intercept Excel's response to
the (invalid) space in the e-mail address?
On Oct 11, 3:44 am, karthikeyan
wrote:
> Hi,
> I have enter E-mail id in one cell with space:e.g(karthi keyan
> sankar.
Hi,
I think I can get a way to solve your problem but I want a clear explanation
and example sheet. I want every condition which affect the result.
Regards
Sandeep
- Original Message -
From: "chinmay kamat"
To: "MS EXCEL AND VBA MACROS"
Sent: Thursday, October 08, 2009 2:01 PM
Subjec
Hi,
Try these links.
http://www.rondebruin.nl/sendmail.htm#Workbook
http://www.rondebruin.nl/mail/folder1/row2.htm
Regards
Saneep
- Original Message -
From: "Manish Pansari"
To: "MS EXCEL AND VBA MACROS"
Sent: Sunday, October 11, 2009 2:48 PM
Subject: $$Excel-Macros$$ Mail through MS
Hi,
You don't need VBA for this you can do this with custom validation. Check
column A in attached file.
To know how to do this
Select any cell in column A ad goto
DATA->Validation
and check SETTING and ERROR ALERT tab.
Regards
Sandeep
- Original Message -
From: "karthikeyan"
To: "
Hi,
Attach the sheet with macro for clear understanding also
Please clear me some points and you will get your answer if possible with
excel functions else with macro.
1. Are you using today date means 11OCT for today and 12OCT for tommorow or
a fixed date like 29OCT in your example?
2. Do yo
Hi,
Use this formula.
=UPPER(TEXT(C20,"dd mmm "))
Regards
Sandeep
- Original Message -
From: "Praveen Khunte"
To: "MS EXCEL AND VBA MACROS"
Sent: Sunday, October 11, 2009 7:37 AM
Subject: $$Excel-Macros$$ Converting Date to uppercase
I have a requirement where date needs to be
thanks harmeet its working
On Sun, Oct 11, 2009 at 4:27 PM, prashant bhawar wrote:
> thanks harmeet its working
>
>
> On Sun, Oct 11, 2009 at 2:25 PM, Harmeet Singh
> wrote:
>
>> *Tried to solve the issue in one column, i hope this helps :)**see
>> attached file*
>> *
>> *
>>
>> Than
Hi,
I have enter E-mail id in one cell with space:e.g(karthi keyan
sankar...@gmail.com).
Excel automatically validate when i click enter button popup message :
don't use space enter E-mail id. How to write coding.pls let me know.
Thanks
--~--~-~--~~~---~--~~
--
Hello Friends,
I want to set a macro, by using that I want to mail some data sheet on
regular basis to my team members.
The format is always same.
So I want to devolve a macro, but I am facing a problem that how can I
define body text of the mail.
Further, I want to put mail IDs in a worksheet i
Hi Praveen,
I think either you can define all 40 links in one workbook and than
you link that cell reference in macro.
Otherwise, Its better to upload a example sheet of the same.
-
Manish
On Oct 11, 12:13 pm, Praveen Khunte wrote:
> Hi Everyone
> There is a specific requirement I came across
Hello Friends,
I want to run a macro continuously after every five minutes. Is there
any option, by using that I can set macro run time and can run macro
automatically?
Thanks,
Manish
--~--~-~--~~~---~--~~
-
Hello Everyone,
Here is the solution of puzzle I asked on 3rd October. I used ITERATION for its
solution.
This may be new feature for many of members here so try to understand it. It is
a powerfull feature.
Thanks & Regards
Sandeep
- Original Message -
From: Sandeep
To: excel-mac
*Enter date in cell "A1" then **Use formula-
=UPPER(TEXT(A1,"dd-mmm-"))**I hope this will solve the issue.*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sun, Oct 11, 2009 at 7:37 AM, Praveen Khunte wrote:
>
> I have a requirement where date needs to be in u
*Tried to solve the issue in one column, i hope this helps :)**see attached
file*
*
*
Thanks & Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Sun, Oct 11, 2009 at 9:30 AM, Prashant Bhawar
wrote:
>
> Plz help here i attached a problem file with required ans. plz help me
> -
Hi Everyone
There is a specific requirement I came across while developing a tool
in excel. I am using 40 different links of the same website to extract
data in a single sheet of excel through feature "External Data from
Web". Now the problem is the link changes when month changes.
For example fo
Plz help here i attached a problem file with required ans. plz help me
--
Warm Regard
Prashant Bhawar
( CA Final )
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. E
I have a requirement where date needs to be in uppercase. Please reply
how to convert a cell which is displays today's date to uppercase. For
example 11 Oct 2009 to 11 OCT 2009. Using Upper function didn't help
me.
--~--~-~--~~~---~--~~
Hi Prabhakar,
The transactions pertaining to capital gains are not so straight forward,
say for eg whether the STT is paid on the same or what about the exemptions
available etc. There may be many other angles attached to such
transactions. Hence what I propose you that excel will never be suffic
26 matches
Mail list logo
