Recent content by Ellie Sloss

  1. E

    1004 Select Method of Range Class Failed Error

    Oops, that's why it was misbehaving. I'll give it a try, thank you for your time, Bob! Ellie
  2. E

    1004 Select Method of Range Class Failed Error

    I was hoping someone may know how to resolve the 1004 Select Method of Range Class Failed error I'm getting. I’m using Bob's code for exporting data from Access to Excel via a macro. Here's the module code: Public Function SendTQ2XLWbSheet(strTQName As String, strSheetName As String...
  3. E

    Select Method of Range class failed - error

    Sorry to rehash this, but I was hoping I could get some help. Bob, I’m also using your awesome code for exporting data from Access to Excel via macro. I just need resulting data to spit out into a separate tab into 3 templates, so I have a series of runcode actions at the end for each query (ie...
See more
Top Bottom