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!!
|