Excel 4.0 Macro Function OPEN.TEXT()
Marc
-
Marc -
Marc -
Hello,
I would like to use the function to automatically open a
.txt file
So I used:
OPEN.TEXT("C:\ResultM.txt";;1;1;1;TRUE;TRUE;TRUE;;;;;), which gives me a
satisfactory result; but I would like to set certain columns
(columns 9, 10, and 11) of my file to date format of type "MAJ" i.e.
MMYYDD.
I have identified that this configuration is related to the last term of the
OPEN.TEXT() function but I have not been able to find the syntax for it.
Is there anyone who can help me?
Thanking you in advance.
I would like to use the function to automatically open a
.txt file
So I used:
OPEN.TEXT("C:\ResultM.txt";;1;1;1;TRUE;TRUE;TRUE;;;;;), which gives me a
satisfactory result; but I would like to set certain columns
(columns 9, 10, and 11) of my file to date format of type "MAJ" i.e.
MMYYDD.
I have identified that this configuration is related to the last term of the
OPEN.TEXT() function but I have not been able to find the syntax for it.
Is there anyone who can help me?
Thanking you in advance.
Configuration: Windows XP Internet Explorer 6.0
1 answer
-
Good evening Marc,
Apparently, you need to put your columns (fields) between curly brackets {.....,...} now. I'm not sure if column 1 corresponds to field 0.
I just found the XL4 documentation in English in my attic (with a lot of dust... it doesn't make us any younger!):
https://support.microsoft.com/en-us
Michel