访问Excel [英] Access to Excel

问题描述

我正在尝试将过滤后的表单上传到Excel。使用某人发给我的代码，我试图让这项工作成功。但就像newbee的所有优秀代码一样.. IT DOSENT WORK！有人可以帮我吗。

代码：

I am trying to upload a filtered form to excel. Using code someone posted to me I tried to make this work. But like all great code for a newbee.. IT DOSENT WORK! Can some one help me out.
Code:

展开 | 选择 | Wrap | 行号

推荐答案

您上传的代码没有解释什么正在工作，什么不起作用。请更清楚你的问题是什么。例如，是Excel打开的实例吗？

You have uploaded code without explaining what is working and what is not working. Please be clearer about what your problem is. For example, is an instance of Excel opening?

代码是采用主窗体，过滤子窗体，并将结果发送到excel表。最终用户想要指定格式化单元格，这是我在代码中的下一步。但首先我需要我的导出代码才能正常工作。想法是一个命令按钮将自动化该过程，然后用户可以将结果报告通过电子邮件发送给团队。我已附加数据库，以防它有所帮助。

The code is to take a main form, which filters a subform, and send the results to an excel table. The end user wants specified formating of the cells, which was to be my next step in code. But first I need my export code to work right. The idea is a comand button will automate the process and the user can then email the resulted report to the team. I have attached the database in case it helps.

附加文件

Export.zip （55.8 KB，61 views）

Attached Files

Export.zip (55.8 KB, 61 views)

我会试着说：

你的代码中哪些不起作用？

I''ll try saying it :
What is not working where in your code?

这篇关于访问Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！