Hi!
I've been using a querytable to import a csv-file into a worksheet
with Office 2k. The text file contains blank lines which need to be
preserved for several reasons.
After upgrading to Office 2003, those blank lines disappear after the
call to qt.Refresh.

Here's the whole macro:

Set qt = wb.Worksheets(1).QueryTables.Add("Text;" + "fred.csv",
[A1])

With qt
.Name = p
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlOverwriteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFileThousandsSeparator = "."
.TextFilePromptOnRefresh = False
.TextFilePlatform = xlWindows
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = False
.TextFileSemicolonDelimiter = True
.TextFileCommaDelimiter = False
.TextFileSpaceDelimiter = False
.TextFileDecimalSeparator = ","
.Refresh BackgroundQuery:=False
End With

Is it that I'm to dumb to find the answer in the VBA Help?

Regards,

Uwe