Recent content by Parsnip

  1. P

    MSQuery failing to show columns

    I believe it could possibly have something to do with the exact Office package you have installed on your machine - some licenses I believe restrict the interoperability of Access with Excel. if you have a full professional licence though, this should not be the case. Just a thought. Richard
  2. P

    Problem with Access Report to Excel Code

    .Range(Cells(1, 1), .Cells(intMaxRow, intMaxCol)).CopyFromRecordset rs Hi Paul If this line is exactly as it appears in your module, then you have missed out a full stop before the Cells(1,1) term. Richard
  3. P

    Problem with Access Report to Excel Code

    What version of Excel are you using? Excel 97 doesn't support the CopyFromRecordset method using ADO connections, so maybe this could be a problem (this scuppered me from using ADO to connect Excel/Access).
See more
Back
Top Bottom