用VB生成EXCEL,在上面生成流程图,
想先画几个框,总是报1004的错.代码
Private Sub cmdTest_Click()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
xlApp.Visible = True
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Activate
xlSheet.Range("C3").Value = "1"
xlSheet.Cells(1, 1) = "test" xlSheet.Range("A1").Select
xlSheet.Shapes.AddShape msoShapeFlowchartStoredData, 100, 100#, 100, 100 '执行到这就报,,这些参数无论怎么改都报错,是怎么搞的?
xlSheet.Shapes.AddShape msoShapeFlowchartCard, 10, 10, 10, 10
xlSheet.Shapes.AddShape msoShapeFlowchartProcess, 10, 10, 10, 10
想先画几个框,总是报1004的错.代码
Private Sub cmdTest_Click()
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Add
xlApp.Visible = True
Set xlSheet = xlBook.Worksheets(1)
xlSheet.Activate
xlSheet.Range("C3").Value = "1"
xlSheet.Cells(1, 1) = "test" xlSheet.Range("A1").Select
xlSheet.Shapes.AddShape msoShapeFlowchartStoredData, 100, 100#, 100, 100 '执行到这就报,,这些参数无论怎么改都报错,是怎么搞的?
xlSheet.Shapes.AddShape msoShapeFlowchartCard, 10, 10, 10, 10
xlSheet.Shapes.AddShape msoShapeFlowchartProcess, 10, 10, 10, 10
解决方案 »
- VB连接SQL方法
- [注意]此马甲最后50分只给贤迷,凡是李贞贤的FAnS,请大家来加群 5911468!一起来关注咱贤姐!
- 2个小问题:对象不支持属性或方法和data+dbgrid改为ado+datagrid
- 怎样才能将文本框的文字储存到文件中???
- 数据报表的问题?
- 关于OUTLOOK vba编程问题
- 英雄,vb与access结合实现查找的方法是what?
- 如果使用Ado访问access本地数据库,怎样解决数据保密的问题?(100分)
- 谁有看密码的程序 高分征集
- mousedown函数的参数x,y,是相对于什么的屏幕位置还是相对于容器的?
- 关于VB Sniffer不工作的问题
- vb读取注册表后怎么进行字符串比较?
也可以如1楼的,引用 microsoft Office 11.0 Object Library 后再引用动态库中的常量