excel - 使用 DoCmd.TransferSpreadsheet 将特定列导出到 Excel 工作表
问题描述
我有一个 VBA 模块,该模块当前将多个 Access 表导出到 Excel 工作表。
有没有办法选择性地导出列,以便只导出少数列?
这是一张 Excel 工作表的当前代码:
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tChart1_Reportable", SavePath, False, "Campus1"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tChart2_Reportable", SavePath, False, "Campus2"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tChart4_Reportable", SavePath, False, "Campus3"
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "tChart9_Reportable", SavePath, False, "Campus4"
解决方案
推荐阅读
- javascript - 如何通过常规 HTML 表单发送图像 blob 数据以在 PHP 脚本中使用
- python - How to write function that takes in a string message and returns a list of string messages with pagination
- java - 服务器处于无限循环时更新文本字段时出错
- python - How do I fix the screen not being displayed after function?
- freemarker - 如何准确输出带有大括号和引号的字符串?
- python - Selecting an item from the dropdown menu of a list using Python + Selenium
- python - Recursion within a class in python
- entity-framework - Getting space used by tables using Entity Framework Core
- node.js - Sequelize.sync({force: true}) 保留过时的模型架构
- makefile - Makefile producing some, but not all .o files