G
Guest
I have a macro that was in use by older version of excel and it worked great
importing and formatting a text file. Somce lines in the file are blank and
are needed to import for the macro formatting to be correct. However when a
user upgraded to Excel 2003, the macro no longer works right becasue excel is
not importing the blank lines. My file open from macro follows.
txtImportFile = "C:\Facs Projects\FDOE_FLAF1_0609.txt"
Workbooks.OpenText Filename:=txtImportFile, Origin:=xlWindows _
, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False,
Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 2), Array(2,
2), _
Array(3, 2), Array(4, 2), Array(5, 1), Array(6, 2), Array(7, 2),
Array(8, 1), Array(9, 1), Array(10, 1))
Can anyone tell me what excel overall system setting is doing this? I don't
want to rewrite the macro to add the balnk line back in, or rewrite the
process that creates the input file, becasue we have too many macros to
rewrite every one of them to insert blank lines.
Thanks for any help
importing and formatting a text file. Somce lines in the file are blank and
are needed to import for the macro formatting to be correct. However when a
user upgraded to Excel 2003, the macro no longer works right becasue excel is
not importing the blank lines. My file open from macro follows.
txtImportFile = "C:\Facs Projects\FDOE_FLAF1_0609.txt"
Workbooks.OpenText Filename:=txtImportFile, Origin:=xlWindows _
, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False,
Comma:=False _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 2), Array(2,
2), _
Array(3, 2), Array(4, 2), Array(5, 1), Array(6, 2), Array(7, 2),
Array(8, 1), Array(9, 1), Array(10, 1))
Can anyone tell me what excel overall system setting is doing this? I don't
want to rewrite the macro to add the balnk line back in, or rewrite the
process that creates the input file, becasue we have too many macros to
rewrite every one of them to insert blank lines.
Thanks for any help