'首先添加对Microsoft Excel x.0 Object Library的引用Private Sub Command1_Click() Dim appXLS As Excel.Application '定义excel对象 Set appXLS = New Excel.Application '生成excel新实例 appXLS.Workbooks.Open "C:\Book1.xls" '打开excel文档 appXLS.ActiveWorkbook.SaveAs "C:\output.txt", xlText '另存为txt格式 appXLS.ActiveWindow.Close '关闭文档 appXLS.Quit '退出excel Set appXLS = Nothing '释放资源 End Sub
Dim appXLS As Excel.Application '定义excel对象
Set appXLS = New Excel.Application '生成excel新实例
appXLS.Workbooks.Open "C:\Book1.xls" '打开excel文档
appXLS.ActiveWorkbook.SaveAs "C:\output.txt", xlText '另存为txt格式
appXLS.ActiveWindow.Close '关闭文档
appXLS.Quit '退出excel
Set appXLS = Nothing '释放资源
End Sub
以后扩展就可以把doc文件转换为html文件,等等