从Visual Basic将数据保存到Excel [英] Save data to Excel from Visual Basic

问题描述

大家好，


这是我第一次在论坛上获得帮助。所以我的问题是我有一个带有一些文本框的表单，我希望将键入内部文本框的数据保存为我创建的Excel格式和我想要保存的指定单元格。例如，我的Excel报告的名称是Manual Visual Report，其中一个vb文本框是Date。让我说我希望文本框日期保存在手动可视化报告，工作表LineA1，单元格（5,4），那么如何编写源代码？


谢谢求助。


*如果可以给我发送示例。

解决方案

为了澄清，你要打开一个Excel称为Manual Visual Report.xls的文档，激活名为LineA1的表格。并将文本框中的文本放入单元格F5？


现在正在处理...

展开 < span class =codeDivider> | 选择 | Wrap | Line数字

hi danp，


感谢您的帮助。我必须尝试源代码1st。希望它有效。 ^ _ ^

Hi all,

This my 1st time to get help at forum. So my problem is I have a form with some textbox inside and I want save the data that key in inside textbox to the Excel format that I create and the specified cell that I want it save into. Example, my Excel report''s name is "Manual Visual Report", and one of the vb textbox is "Date". Lets say I want that textbox date save inside "Manual Visual Report", worksheet "LineA1", cell (5,4), so how to write the source code?

Thanks for the help.

*if can send me the example.

解决方案

To clarify, you want to open an Excel document called "Manual Visual Report.xls", activate the sheet called "LineA1" and put in the text from your textbox into cell F5 ?

Am working on it now...

Expand|Select|Wrap|Line Numbers

hi danp,

thanks for you help. i have to try the source code 1st. hopefully it works. ^_^

这篇关于从Visual Basic将数据保存到Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！