Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 08-08-2013, 09:39 AM
BobBridges's Avatar
BobBridges BobBridges is offline Date format in excel vba Windows 7 64bit Date format in excel vba Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

First-pass translation, for those who don't read Portuguese:
Quote:
I have a problem that started recently and do not know how resolve. I have a system in excel VBA and this system saves certain data from a form on a spreadsheet that serves as a database. When it sends the data to the worksheet it saves the correct date format, which is dd / MM / yyyy, but when I do the search for data and make the change by adding another date, ie the date of the end, it's saved in MM / dd / yyyy—and where I live, in Brazil, this date is unacceptable. What can it be?
Laercio, three questions:

1) Is it VBA code that places the start date in dd/mm/yyyy? I mean, is the start date being placed in the worksheet by VBA code, or by some other method (such as by hand)? I'm not sure from your description.

2) Is it VBA code that places the end date in mm/dd/yyyy? I think you're saying it is.

3) Is it the same VBA statement in both cases? Surely it isn't.

So what I suspect is happening here is that the VBA statement that's putting the end date in your worksheet is doing it wrong; either it's specifying mm/dd/yyyy, or it isn't specifying the format at all and the default format is wrong. To find out which you'll have to look at that VBA statement, and to fix it you might have to change that VBA statement. So the first thing is to find it and post it here. Do you know how to do that? I can't tell from your first post whether you can find your way around a VBA program.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format in excel vba Date Value Format Error Tamarrissa Mail Merge 1 09-29-2013 07:37 PM
Date format in excel vba Timeline date format mikeg Project 1 04-19-2013 06:26 AM
Date format in excel vba excel 2010 to format a date jassie Excel 1 03-28-2013 02:33 AM
date format gsrikanth Excel 1 12-28-2011 05:06 AM
Date format in excel vba Mail merge will not format date field generated by Excel IF statement borntorun75 Mail Merge 3 12-16-2011 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft