Vb-how使用Vb 6.0软件进行Excel中的更改 [英] Vb-how To Moniter Changes Made In Excel By Using Vb 6.0 Software

问题描述

全部，


我想监控网络系统中各个用户对每个单元格的任何excel文件所做的更改。


请提供一些指导如何创建软件。


问候

Anup kumar

解决方案

< blockquote>

我想监视网络系统中不同用户对每个单元格的任何excel文件所做的更改。


友善提供一些指导如何创建软件。

将一些东西放在相关工作表的Worksheet_Change事件中可能是最简单的。例如，您可以每次在日志（文本）文件中附加一个条目。

可能最简单的方法是在有问题的工作表的Worksheet_Change事件。例如，您可以每次向日志（文本）文件追加一个条目。

我没有亲爱的。


Plz在更广泛的道路上解释这件事。因为我对Vb非常新。

我没有亲爱的。


Plz在更广泛的道路上解释了这件事。因为我对Vb非常新。

好​​的，在这种情况下，我们实际上是在讨论VBA。这是Visual Basic for Applications，它是内置于MS Office应用程序中的VB版本，用于通过编写宏来执行脚本编写（自动执行任务）。代码。


让我们一起为Excel抛出一个简单的小示例宏，它将每个对工作表所做的更改的细节附加到文本文件中。 />

要创建它，请按照以下步骤操作。 （希望他们的系统不会变化太大，但我们会看到）。

• 在Excel中打开一个新工作表。
• 下拉 T ools 菜单，展开[b] M acro子菜单，然后选择 V isual Basic Editor 。
• 在项目资源管理器窗口（可能在左上角，列出项目中的内容）中双击 ThisWorkbook 。
• 你应该在右边有一个空白的代码窗口。
• 在代码窗口的顶部，向下拉左侧列表框并选择工作簿。
• 下拉右侧列表框并选择 SheetChange 。
• 您现在位于工作簿的SheetChange事件过程的代码窗口中。每次在此工作簿中的任何工作表上进行更改时，都会执行此处输入的任何代码。
• 粘贴以下代码。这是一个非常简单的例子，但它将为您提供一个起点。然后您可以使用此代码并使用它。
  

  展开 | 选择 | Wrap | 行号

HI all,

I wanted to monitor changes made in any excel file of each and every cell by various users in networking system.

kindly provide some guidelines how to create the software.

Regards
Anup kumar

解决方案

I wanted to monitor changes made in any excel file of each and every cell by various users in networking system.

kindly provide some guidelines how to create the software.

It might be simplest to put something in the Worksheet_Change event of the worksheet(s) in question. For example, you could append an entry to a log (text) file each time.

It might be simplest to put something in the Worksheet_Change event of the worksheet(s) in question. For example, you could append an entry to a log (text) file each time.

I didn''t get dear.

Plz explain this thing in a bit more broadway. As i am very much new to Vb.

I didn''t get dear.

Plz explain this thing in a bit more broadway. As i am very much new to Vb.

Ok, well in this case we''ll actually be talking about VBA. That''s "Visual Basic for Applications", which is a version of VB built into MS Office applications to do scripting (automating tasks) by writing "macro" code.

Let''s have a go at throwing together a simple little example macro for Excel which will append the details of each change made to a worksheet into a text file.

To create this, follow the following steps. (Hopefully they won''t vary too much on your system, but we''ll see).

• open a new worksheet in Excel.
• Pull down the Tools menu, expand the [b]Macro submenu and select Visual Basic Editor.
• In the Project Explorer window (the one probably at top-left which lists what''s in the project) double-click on ThisWorkbook.
• You should get a blank code window on the right.
• At the top of the code window, pull down the left-hand listbox and select WorkBook.
• Pull down the right-hand listbox and select SheetChange.
• You are now in the code window for the workbook''s SheetChange event procedure. Any code you enter here will be executed each time a change is made on any of the worksheets in this workbook.
• Paste in the following code. This is a very simple example, but will provide you with a starting point. You can then take this code and play with it.
  

  Expand|Select|Wrap|Line Numbers

这篇关于Vb-how使用Vb 6.0软件进行Excel中的更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！