View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
barnabel barnabel is offline
external usenet poster
 
Posts: 119
Default VBA "1004" error when .Refresh BackgroundQuery:=False

The query is read the text file breaking it into the fields based on the
widths in the TextFileFixedColumnWidths and store in fields typed as listed
in TextFileColumnDataTypes. With backgroundquery set false it won't proceed
until the file is read.

Interestingly, the first thing done after reading is to delete the first 6
rows which could be accoplished by setting TextFileStartRow = 7

Peter Richardson


"Dennis" wrote:

I got it!

Should have had a "\" after ..... SAP Downloads\"

Still would like to know where the "query" is

Thanks for all those who took time!!