Posted to microsoft.public.excel.programming

nanda via OfficeKB.com nanda via OfficeKB.com is offline

external usenet poster

Posts: 2

Date dd-mm-yy(EXCEL) manipulation in VB macro

I want to manipulate date entered in excel sheet using VB macro, ie want to
extract day, moth and year separately from the date entered in EXCEL sheet
(in dd-mm-yy format )and store it in three different variables. but since the
formats used in excel is dd-mm-yy and VB is mm/dd/yy could any body please
code a function to do the same Thanks very much

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200908/1

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date manipulation	Vsn	Excel Programming	0	April 22nd 06 05:52 PM
Date manipulation	JE McGimpsey	Excel Programming	1	April 21st 06 04:46 PM
Macro Date Manipulation	DKY[_99_]	Excel Programming	13	February 27th 06 07:45 PM
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation	vmegha	Excel Programming	2	December 19th 05 12:14 AM
Generating Code in Excel / Macro Recorder Manipulation	[email protected]	Excel Programming	2	August 18th 05 03:31 PM

All times are GMT +1. The time now is 02:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us