Private Sub Command1_Click()
Dim ExApp As Object, Exb As Object, Exsh As Object
Dim I1 As Excel.RangeSet ExApp = CreateObject("Excel.Application")
Set Exb = ExApp.Workbooks.Open("f:\gzdmx.xls")
Set Exsh = Exb.Sheets(1)
ExApp.Visible = TrueI1 = Combo_czmd.SelectedItem
Exsh.Cells(2, 3) = I1ExApp.Workbooks.Close
ExApp.Quit
Set ExApp = NothingFor Each Exb In ExApp.Workbooks
Workbooks.Close True
NextEnd Sub目的实现功能:获取combo_camd中的值并且赋值到excel表格中特定单元格中。
已经有很多人帮忙修改,但是个人水平有限还是不能运行,请详细将错误指出
Dim ExApp As Object, Exb As Object, Exsh As Object
Dim I1 As Excel.RangeSet ExApp = CreateObject("Excel.Application")
Set Exb = ExApp.Workbooks.Open("f:\gzdmx.xls")
Set Exsh = Exb.Sheets(1)
ExApp.Visible = TrueI1 = Combo_czmd.SelectedItem
Exsh.Cells(2, 3) = I1ExApp.Workbooks.Close
ExApp.Quit
Set ExApp = NothingFor Each Exb In ExApp.Workbooks
Workbooks.Close True
NextEnd Sub目的实现功能:获取combo_camd中的值并且赋值到excel表格中特定单元格中。
已经有很多人帮忙修改,但是个人水平有限还是不能运行,请详细将错误指出
http://www.crazycoder.cn/VisualBasic/Article15845.html
应该会出现‘类型不匹配’的错误!试试这个:
Exsh.Cells(2, 3).Formula = Combo_czmd.Text
或者不是 VB6 的 标准控件/MS Forms 2.0对象库 ?说清楚你的 编程环境 和 是否用的第三方控件 吧!