+ Reply to Thread
Posts 1 to 4 of 4
  1. #1

    Double Godlike!

    xoggoth's Avatar
    Join Date
    Jul 2005
    Location
    xoggoth towers
    Posts
    12,021
    Thanks (Given)
    2
    Thanks (Received)
    347
    Likes (Given)
    125
    Likes (Received)
    1149

    Default Excel update has screwed data connection

    Have an Excel accounts sheets that uses data connection to retrieve sales records from my shopping cart. Got a lot of Windows 10 updates today including a security update for Excel and now it's not working any more.

    The main code is:
    With ActiveSheet.QueryTables.Add(Connection:= thisurl, Destination:=Range("$C$10"))
    .Name = "showorders4_1"
    .FieldNames = True
    ----etc etc------
    .Refresh BackgroundQuery:=False
    End With

    Range("C10:C1000").Select
    Selection.TextToColumns Destination:=Range("C10"), DataType:=xlDelimited,TextQualifier:=xlDoubleQuote , ConsecutiveDelimiter:=False, Tab:=True, _
    Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _
    :=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
    ----etc etc---
    46, 1), Array(47, 1), Array(48, 1)), TrailingMinusNumbers:=True

    It gets to .Refresh BackgroundQuery:=False and hangs. If it delete that line it says "No data selected to parse". Can't see anything useful on the MS info on this update. Any data connection experts got an idea? Ta.
    bloggoth

    If everything isn't black and white, I say, 'Why the hell not?'
    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

  2. #2

    Super poster

    Scruff's Avatar
    Join Date
    Mar 2013
    Location
    Londres
    Posts
    2,357
    Thanks (Given)
    34
    Thanks (Received)
    103
    Likes (Given)
    443
    Likes (Received)
    359

    Default

    Uninstall the patch and turn off the automatic updates, as a start?
    We have a poverty of intellect....
    QDOS Referral Code http://www.qdoscontractor.com/code/QCL26507
    IPSE Referral Code http://www.ipse.co.uk/join/IPSE01396

  3. #3

    Double Godlike!

    xoggoth's Avatar
    Join Date
    Jul 2005
    Location
    xoggoth towers
    Posts
    12,021
    Thanks (Given)
    2
    Thanks (Received)
    347
    Likes (Given)
    125
    Likes (Received)
    1149

    Default

    Cheers Scruff but just tried it again today and it's working. Maybe some temp site problem, fault and update just a coincidence.
    bloggoth

    If everything isn't black and white, I say, 'Why the hell not?'
    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

  4. #4

    Double Godlike!

    xoggoth's Avatar
    Join Date
    Jul 2005
    Location
    xoggoth towers
    Posts
    12,021
    Thanks (Given)
    2
    Thanks (Received)
    347
    Likes (Given)
    125
    Likes (Received)
    1149

    Default

    Ah but the update has screwed Media Player! Crashes when I try and play MPG. Ta MS. (No date on that page but Google says 3 days ago)

    Windows 10 Media Player crashes since yesterday
    bloggoth

    If everything isn't black and white, I say, 'Why the hell not?'
    John Wayne (My guru, not to be confused with my beloved prophet Jeremy Clarkson)

+ Reply to Thread

Posting Permissions

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

Content Relevant URLs by vBSEO 3.6.0 ©2011, Crawlability, Inc.