我编译下面代码
Public Excelobj As excel.Application
Public Wordbook1 As Word.Document
Public WSheet1 As Worksheet
Public WSheet2 As Worksheet
Public Chobj As Chart
Dim i&, j&, k&, st&, m&
Dim CarType As Integer
时提示第一行user defined type not defined,要怎么才能弄好啊,请教各位VB程序员。
Public Excelobj As excel.Application
Public Wordbook1 As Word.Document
Public WSheet1 As Worksheet
Public WSheet2 As Worksheet
Public Chobj As Chart
Dim i&, j&, k&, st&, m&
Dim CarType As Integer
时提示第一行user defined type not defined,要怎么才能弄好啊,请教各位VB程序员。
解决方案 »
- 高手请进,数据转换需要帮忙
- VB6写变量名的时候有智能感知吗?也就是写了前面的字母后后面的字母就自动出现一个列表去选。
- 如何将PIctureBox控件中的彩色图片变成黑白灰阶颜色?
- 【问】如何让PopMenu弹出不在同一个层次的菜单?
- 哪位前辈知道如何用VB作两个文件的比较?
- 如处有 MDAC 2.6下载?
- VB 怎么做 自动按键
- VB6中如何将RichTextBox控件中加载的RTF格式内容以图像的形式输出?
- 拼图程序
- 如何弹出“任务栏 属性”的设置对话框?
- ADO连接SQL Server后,怎样执行建表、查找、插入、更新记录等SQL语句?
- 在access执行sql语句,怎样把选择到的值赋给变量
把Public Wordbook1 As Word.Document改为
Public Wordbook1 As Workbooks
Public Excelobj As excel
Public Wordbook1 As Workbooks
Public Excelobj As excel.Application
Public Wordbook1 As Word.Document
Public WSheet1 As Worksheet
Public WSheet2 As Worksheet
Public Chobj As Chart
Dim i&, j&, k&, st&, m&
Dim CarType As Integer
吗?还是不行啊……
把这一句Public Wordbook1 As Word.Document去掉。。
这句是打错了,还是。
调用Excel必须先应用Excel Library
然后如下声明和调用:
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.WorksheetIf xlApp Is Nothing Then
Set xlApp = CreateObject("Excel.Application")
End If
Set xlBook = xlApp.Application.Workbooks.Add
Set xlSheet = xlBook.Sheets(1)
(1)不用引用连接库
dim eapp as object
dim ewb as object
set eapp=createobject("escel.application")
set ewb=eapp.workbooks.add
(2)引用excel 9.0
dim eapp as new excel.application
dim ewb as new excel.workbook
以后怎么做就都明白了
但是无论使用哪种方法都要在已经安装了office的前提下