Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
VBA determine computer region
I have a macro for an Excel spreadsheet that I used to add dates.
Unfortunately I wrote it on a computer that was in the Canada region DD/MM/YYYY and when I moved it to a computer in US region MM/DD/YYYY it broke as it was adding on days. How can I use VBA to determine wether the date format is in MM/DD/YYY or DD/MM/YYYY the reason I need this I am inputing the day as a string (it has to be this way) in the format of DD/MM/YYYY and I need to add 1 day to it. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Region | Excel Discussion (Misc queries) | |||
Display size difference- PC computer vs. Mac computer? | Excel Discussion (Misc queries) | |||
How do I copy all Excel files from old computer to new computer? | Excel Discussion (Misc queries) | |||
how to shrink a region (because of a maverick) | Charts and Charting in Excel | |||
Autocomplete works with my home computer but not the office computer | Excel Discussion (Misc queries) |