Joined
Last Seen
0 Reputation Points
Unknown Quality Score
No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
0 Endorsements
Ranked #107.55K
1 Posted Topic
 | [QUOTE=SirWren;285617]Ok... here's the solution, add the [I]<local:=true>[/I] parameter to your VBA macro, e.g. Workbooks.OpenText Filename:="C:\Test1.csv", DataType:=xlDelimited, _ TextQualifier:=xlTextQualifierNone, FieldInfo:=Array(1, 4), Local:=True[/QUOTE] ================== I am also facing the same problem with date format using macro and I tried to apply your solution... but the command that I am using is Application.GetOpenFilename … |
The End.