VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

**vijay21** · 11-17-2012, 07:14 AM

Hi experts,

Could you pls help to write a excel vba macro to capture Data of Current Date in dd/mm/yyyy, even though my system date format is in different one. I am using excel/office 2007.

Thanks in advance,

**benishiryo** · 11-17-2012, 07:20 AM

hi vijay21, you can record the following actions. assuming your dates are in column A, select the whole column
go to Data -> Text to Columns -> Next -> Next -> Date: MDY - > Finish

it will look something like this:

Please Login or Register  to view this content.

**vijay21** · 11-17-2012, 07:27 AM

I think I did not explain fully on my req. I am trying to capture the Entry Date in a excel cell thru an userform. I have done coding to get the current date in a variable. It works fine when the date is in brit format (dd/mm/yyyy). I wish to keep the same format of date even though my system format is changed to usa format (mm/dd/yyyy).

Thanks,

**oeldere** · 11-17-2012, 07:28 AM

I think VBA does that for you (but i'm no VBA expert).

Otherwise post an excel file,without confidentional information.

Please also add the desired result.

**vijay21** · 11-17-2012, 07:49 AM

Thanks for your reply.

I am looking to write a VBA code inside the macro. Could any one help me.

**oeldere** · 11-17-2012, 07:54 AM

In that case, you don't read my suggest in #2 well enough.

**HaHoBe** · 11-17-2012, 08:11 AM

Hi, vijay21,

the long for a date in Format dd/mm/yyyy should be equal to that of mm/dd/yyyy as long as Excel recognises the input as a Date. So maybe use the CLng-conversion for your search or apply the Autofilter (which in VBA would need a long value for putting up any result).

Ciao,
Holger

**vijay21** · 11-18-2012, 02:28 PM

hi,

I got an idea to store the date using NumberFormat in VBA macro.

Please Login or Register  to view this content.

I will try it to check ! Hope this works..... thanks for your guidence Holger.

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

LinkBack

Thread Tools

Rate This Thread

Display

VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Re: VBA Macro to capture DATA in dd/mm/yyyy even though system date format is mm/dd/yyyy

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions