如何在POWERPOINT中调用EXCEL?

lwsh

如何在POWERPOINT中调用EXCEL?紧急!!!谢谢 即用vba读取excel单元格中的数据!!

[此贴子已经被作者于2004-1-8 8:57:02编辑过]

colorliang

http://expert.csdn.net/Expert/topic/2624/2624557.xml?temp=.7014124

colorliang

打开工作簿： Sub OpenWorkBook1() Workbooks.Open FileName:="c:\temp\Welcome.xls" End Sub 关闭工作簿 Sub CloseAllWorkBook() Workbook.close End Sub Sub CloseWorkBook1() Workbooks("Welcome.xls").Close End Sub Sub CloseSaveBook1() Workbooks("Welcome.xls").Close SaveChanges:=True End Sub 将已打开的工作簿设定为活动工作簿 Sub ChangeActiveWindow() Windows("Welcome.xls").Activate End Sub 保存工作簿 Sub SaveActiveWorkbook() ActiveWorkbook.Save End Sub 新建工作簿 Sub CreateWorkSheet1() Worksheets.Add End Sub 选取工作簿 Sub ActiveWorkSheet2() Worksheets("Sheet3").Select End Sub 选取单元格内容 Sub RangeSelect1() Range("B5").Select 或Range("A1:D5").Select End Sub 显示单元格内容 Sub UseMsgBox() MsgBox Range("A1").Value End Sub