Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening worksheet
Hi, I have a worksheet that contains a column of dates. If I double
click to open, or use File-Open etc, the dates format ok. I want to open using vba, so I recorded a macro, but when I run the macro, some dates format ok, august dates, others format as usa, september dates. then code I used is Workbooks.Open Filename:= _ "C:\Documents and Settings\Robert\Desktop\FOOTBALL\Soccer Predictions\E0.csv". Any ideas please. Regards Robert |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Worksheet | Excel Discussion (Misc queries) | |||
VBA Opening worksheet, name changes | Excel Discussion (Misc queries) | |||
Opening a New Worksheet | New Users to Excel | |||
OPening worksheet | Excel Programming | |||
Opening a worksheet in VBA | Excel Programming |