Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem with "Refresh BackgroundQuery=False" | Excel Programming | |||
.Refresh BackgroundQuery:=False | Excel Programming | |||
.Refresh BackgroundQuery:=False | Excel Programming | |||
Problems with .Refresh BackgroundQuery:=False | Excel Worksheet Functions | |||
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming |