> Prosim o pomoc. Zase mi predelali v ucetnim programu jeden report a ja musim > znovunastavit makro. > Ted vypada takto: > Workbooks.OpenText Filename:="C:\cas", Origin:=xlWindows, StartRow _ > :=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ > ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=False > _ > , Space:=False, Other:=False, FieldInfo:=Array(Array(1, 9), Array(2, > 1), _ > Array(3, 9), Array(4, 4), Array(5, 9), Array(6, 2), Array(7, 9), > Array(8, 9), Array(9, 9), _ > Array(10, 1), Array(11, 9), Array(12, 9), Array(13, 9)), > ThousandsSeparator:="." > Muzete mi prosim nekdo vysvetlit, co jsou to ty udaje: > FieldInfo:=Array(Array(1, 9) > Prvni chapu, poradove cislo sloupce, ale co ta cisla za carkou? Co takhle stisknout F1? ---------------------------------------------------- Array(Array(3, 9), Array(1, 2)) If the source data has fixed-width columns, the first element in each two-element array specifies the position of the starting character in the column (as an integer; character 0 (zero) is the first character). The second element in the two-element array specifies the parse option for the column as a number between 1 and 9, as listed in the preceding table. The following example parses two columns from a fixed-width text file. The first column includes characters 1 through 10. Characters 11, 12, 13, 14, and 15 are skipped. The second column includes character 16 through the last character in the line. Array(Array(0, 1), Array(10, 9), Array(15, 1)) ---------------------------------------------------- Preklad treba? Druhe cislo vyjadruje druh sloupce 1 - obecny ... 9 - preskocit -- cao, Kamil
This archive was generated by hypermail 2.1.3 : 25. 07. 2003, 15:18 CEST