Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    68

    Unanswered: Open Excel using Access Macro

    I have determined that using the File>Export menu option from Access truncates a field that contains more than 255 characters. Therefore, I must use the "Transferspreadsheet" method.

    I would like to use this in a macro. Is there a way to open Excel and the newly created file using an Access Macro?

    Thanks,
    Grace

  2. #2
    Join Date
    Jul 2004
    Location
    Blackburn, UK
    Posts
    169
    Use output to macro, select the table you want to output and the format then select auto start.
    Based on DAO 3.6 and Access 2000 + 2003
    VB.Net 2005 + ADO.Net

Posting Permissions

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