Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

is the VBA command TransferSpreadsheet starting an Excel process?

When I use the DoCmd.TransferSpreadsheet in my Access VBA code, do I need excel installed, and does it start an Excel process?

Update:

But is it the Access-process that reads/write the excel file, or is excel started?

1 Answer

Relevance
  • ?
    Lv 6
    9 years ago
    Favorite Answer

    Yes. You can use the TransferSpreadsheet action to import or export data between the current Microsoft Access database (.mdb) or Access project (.adp) and a spreadsheet file.

    :)

Still have questions? Get your answers by asking now.