如果是手工筛选后导出,参考代码:
Dim ex As New Exporterex.SourceTableName = "表a" '指定导出表ex.FilePath = "c:\" '指定目标文件路径ex.Format = "Fixed" '导出格式为固定宽度的文本文件ex.Fields = "第一列"ex.Header= "False"ex.NewTableName = "888" '指定文件名,注意无须扩展名ex.Filter = Tables("表A").Filterex.Export() '开始导出