Outputto

• • Reply

  14 years ago

  by daveyneedshelp

  David Hindley

  , United Kingdom

  Joined 14 years ago

  Dear all

  I cannot remember how to do this - am having a bad day!

  I want to use the Outputto method, as I want to export the results of queries.  However, I want to export several queries to one spreadsheet, on different sheets.  I know I can do it using the "TransferSpreadsheet" method, but I don't want to have to create all the tables first - it takes time and increases the size of the database to ridiculous levels.

  I know its possible to do it, but I cannot remember how - the Outputto method is simply overwritting the whole workbook, rather than adding to it.

  Help!??!!

  Cheers

  Report abuse