Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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!!



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
problem with "Refresh BackgroundQuery=False" NickHK Excel Programming 0 December 12th 06 03:20 AM
.Refresh BackgroundQuery:=False ikirin[_6_] Excel Programming 0 June 26th 06 04:01 PM
.Refresh BackgroundQuery:=False ikirin[_5_] Excel Programming 0 June 26th 06 03:46 PM
Problems with .Refresh BackgroundQuery:=False dmplacebo Excel Worksheet Functions 0 July 11th 05 12:39 PM
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) Anant[_2_] Excel Programming 1 August 6th 03 04:22 AM


All times are GMT +1. The time now is 10:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"