=TEXT(TEXT(A2,"\/00\/00"),"dd-mmm-")
Regards,
Sam Mathai Chacko
On Mon, Oct 31, 2011 at 12:52 PM, Aivi wrote:
> hi
>
> i have a column in excel with the following date format--
>
> Invoice Date 20111003 20111003 20111003 20111003 20111003 20111003
> 20111003 20111003 20111003
Please READ the RULES at the bottom of the page
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Aivi
Sent: Monday, October 31, 2011 2:22 AM
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$ ActiveX component can't create object
hi
i have a column in excel wit
pot.com/>
*http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>
-- Forwarded message --
From: Aivi
Date: Mon, Oct 31, 2011 at 12:52 PM
Subject: Fwd: $$Excel-Macros$$ ActiveX component can't create object
To: excel-macros@googlegroups.com
hi
i have
hi
i have a column in excel with the following date format--
Invoice Date 20111003 20111003 20111003 20111003 20111003 20111003
20111003 20111003 20111003 20111003 20111003 20111003 20111003 20111003
20111024 20111024 20111024 20111003 20111003 20111003 20111003
I need the date format like 01
Thanks Bro... It worked... :-) :-)
On Fri, Oct 21, 2011 at 1:47 AM, Sam Mathai Chacko wrote:
> Not tested. When you create the OutLook object, try using
> CreateObject("Outlook.Application.12") for 2007, or .11 for 2003 (assuming
> you have outlook in 2003)
>
> Regards,
> Sam
>
>
> On Thu, Oct 20
Not tested. When you create the OutLook object, try using
CreateObject("Outlook.Application.12") for 2007, or .11 for 2003 (assuming
you have outlook in 2003)
Regards,
Sam
On Thu, Oct 20, 2011 at 9:35 PM, deepu wrote:
> Hi Friends,
>
> Recently I've installed MS-Excel 2003 application on my sys
Hi Friends,
Recently I've installed MS-Excel 2003 application on my system however
I already MS-Excel 2007 on my system, now I can use both the versions,
however I've noticed while developing a code that I'm not able create
objects of other applications in MS-Excel, i.e., I's writing a code to
con
