+ Reply to Thread
Results 1 to 3 of 3

Refresh BackgroundQuery:=False Error

  1. #1
    Registered User
    Join Date
    01-12-2014
    Location
    Plano, Tx
    MS-Off Ver
    Excel 2007
    Posts
    54

    Refresh BackgroundQuery:=False Error

    I am getting a Refresh BackgroundQuery:=False error on different PC's. The code below works on my PC Excel 2010 everytime, but does not on 2 different machines. One is 2010 and the other is 2007. I have tried to add DoEvents and this line of code(Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False) to replace but nothing seems to work. Can someone please help? Thank you.
    Application.ScreenUpdating = False


    Cells.Select
    Selection.ClearContents
    Range("A1").Select
    With ActiveSheet.QueryTables.Add(Connection:= _
    "TEXT;C:\Program Files\Remote\rwnode\652\SUBSCRIB\Master\3560.~su", _
    Destination:=Range("$A$1"))
    .Name = "3560"
    .FieldNames = True
    .RowNumbers = False
    .FillAdjacentFormulas = False
    .PreserveFormatting = False
    .RefreshOnFileOpen = False
    .RefreshStyle = xlInsertDeleteCells
    .SavePassword = False
    .SaveData = True
    .AdjustColumnWidth = True
    .RefreshPeriod = 0
    .TextFilePromptOnRefresh = False
    .TextFilePlatform = 437
    .TextFileStartRow = 1
    .TextFileParseType = xlFixedWidth
    .TextFileTextQualifier = xlTextQualifierDoubleQuote
    .TextFileConsecutiveDelimiter = False
    .TextFileTabDelimiter = True
    .TextFileSemicolonDelimiter = False
    .TextFileCommaDelimiter = False
    .TextFileSpaceDelimiter = False
    .TextFileColumnDataTypes = Array(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
    .TextFileFixedColumnWidths = Array(7, 32, 27, 10, 8, 5, 12, 12, 8, 8, 13, 9, 5, 11, 10, 9, _
    7, 11, 8)
    .TextFileTrailingMinusNumbers = True
    .Refresh BackgroundQuery:=False
    End With

  2. #2
    Registered User
    Join Date
    11-04-2013
    Location
    Chesham
    MS-Off Ver
    Excel 2010
    Posts
    33

    Re: Refresh BackgroundQuery:=False Error

    Probably a useless question but have you checked to ensure the file is in fact located in C:\Program Files\Remote\rwnode\652\SUBSCRIB\Master\3560.~su on the different machines?

  3. #3
    Registered User
    Join Date
    01-12-2014
    Location
    Plano, Tx
    MS-Off Ver
    Excel 2007
    Posts
    54

    Re: Refresh BackgroundQuery:=False Error

    Unfortunately, yes. All the same locations.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Refresh BackgroundQuery:=False Debugging Error
    By RedMug in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-25-2014, 02:09 PM
  2. [SOLVED] Run Time error ‘1004’: .Refresh BackgroundQuery:=False
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-06-2014, 12:37 AM
  3. .Refresh BackgroundQuery:=False error
    By oligo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-26-2014, 02:16 AM
  4. Macro error with Refresh BackgroundQuery:=False
    By Mulberry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-13-2013, 06:53 PM
  5. Run-time error '1004' for .Refresh BackgroundQuery:=False for loop
    By Robo25 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-12-2013, 01:16 AM
  6. Error in Macro: (Refresh BackgroundQuery:=False)
    By abehnamian in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2008, 12:45 PM
  7. Error with Selection.QueryTable.refresh BackgroundQuery:=False
    By rivets in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2007, 01:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1