如何在C驱动器中创建新的.xls文件并使用vb6打开，保存，更新 [英] how to create new .xls file in c drive and open,save,update with vb6

问题描述

如何在C驱动器中创建新的.xls文件并使用vb6打开，保存，更新

how to create new .xls file in c drive and open,save,update with vb6

推荐答案

^ ]

Found this on Google[^]

Dim xlApp As Excel.Application
Dim wb As Workbook
Dim ws As Worksheet
Dim var As Variant

Set xlApp = New Excel.Application

Set wb = xlApp.Workbooks.Open("PATH TO YOUR EXCEL FILE")

Set ws = wb.Worksheets("Sheet1") 'Specify your worksheet name
var = ws.Range("A1").Value

'or
var = ws.Cells(1, 1).Value

ws.Cells(1, 1).Value = "Sample Text"
wb.Close
xlApp.Save
xlApp.Quit

Set ws = Nothing
Set wb = Nothing
Set xlApp = Nothing

只需添加引用Microsoft Excel Object Library

Just add a reference Microsoft Excel Object Library

这篇关于如何在C驱动器中创建新的.xls文件并使用vb6打开，保存，更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！