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=mrdarcy;269018]I am having the exact same problem! Did you figure it out, or does anybody know how to get around this problem?[/quote] 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 |
The End.