Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2015
    Posts
    23

    Unanswered: a Command Button that converts to Excel

    I want to create a command button on form that quickly converts and saves an Excel file on desktop rather than asking me Destination folder and other options..
    Please help..
    Thanks

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    496
    Provided Answers: 24
    DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, sQry, sFileName, True, sTabName

Posting Permissions

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