在Excel 2007中编程 [英] Programming in Excel 2007

问题描述

尊敬的专家，

我有一个项目，我将有一个Excel 2010工作表，其中包含一个按钮，该按钮用于从给定的.dat文件或.txt文件导入数据.这些文件中的数据将被复制到excel工作表中的指定单元格中.
我具有Excel和VBA的基础知识，但是我不知道如何开始该项目.

期待专家的帮助.
-Khoa

Dear Experts,

I have a project, I will have one Excel 2010 Sheet which has a button that in order to import data from given .dat file or .txt file. The data from those files will be copied to the specified cells in excel sheet.

I have a basic on Excel and VBA, but I do not know how to start with the project.

Looking forward some helps from experts.
-Khoa

推荐答案

在Excel 2007中，为了查看代码或启动项目，必须做一些基本步骤.

从Excel Toolbor(位于excel左上方)中选择Excel选项，然后选择流行"选项卡，然后选择在功能区中显示开发者选项卡".

这将为您提供Excel工作表中的开发人员标签.

选择它，然后单击"Visual Basic"，您可以在其中找到您的项目的代码.

将适当的调试器放入代码中，然后分析其中发生的情况.

如果在此过程中遇到任何问题，还会提出问题吗?

干杯！

In Excel 2007 in order to view the code or to start the project one has to do some basic steps.

Select Excel options from Excel Toolbor (present at top left of the excel) and then select popular tab and select show developer tab in ribbon.

This will provide you a developer tab in excel sheet.

Select that and click Visual basic there you can find the code for your project.

Place appropriate debbuger in the code and analyze what is happening there.

And raise issues if you get any in this process?

Cheers!

看看

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