我把Excel的部分数据复制到了剪切板中,想用VB保存成一个任意文件,用时通过VB打开临时文件再把保存的数据复制到剪切板中,在粘帖到Excel中。
'*************************************************
Option ExplicitDim xApp As Excel.Application
Dim xBook As Excel.Workbook
Dim xSheet As Excel.WorksheetPrivate Sub cmdRead_Click()
Set xApp = New Excel.Application
Set xBook = xApp.Workbooks.Open(App.Path & "\Temp.xls")
Set xSheet = xBook.Worksheets(1)
xSheet.Cells.Select
xSheet.Cells.Copy
xApp.Quit
Set xApp = Nothing
MsgBox "读取成功!"
End SubPrivate Sub cmdSave_Click()
Set xApp = New Excel.Application
Set xBook = xApp.Workbooks.Open(App.Path & "\Temp.xls")
Set xSheet = xBook.Worksheets(1)
xSheet.Cells.Select
xSheet.Cells.ClearContents
xSheet.Cells.Range("A1").PasteSpecial
xBook.Save
xApp.Quit
Set xApp = Nothing
MsgBox "保存成功!"
End Sub这样写把剪切板中的数据保存成了Object了,请某位路过的大拿帮帮忙,在线等,谢谢
'*************************************************
Option ExplicitDim xApp As Excel.Application
Dim xBook As Excel.Workbook
Dim xSheet As Excel.WorksheetPrivate Sub cmdRead_Click()
Set xApp = New Excel.Application
Set xBook = xApp.Workbooks.Open(App.Path & "\Temp.xls")
Set xSheet = xBook.Worksheets(1)
xSheet.Cells.Select
xSheet.Cells.Copy
xApp.Quit
Set xApp = Nothing
MsgBox "读取成功!"
End SubPrivate Sub cmdSave_Click()
Set xApp = New Excel.Application
Set xBook = xApp.Workbooks.Open(App.Path & "\Temp.xls")
Set xSheet = xBook.Worksheets(1)
xSheet.Cells.Select
xSheet.Cells.ClearContents
xSheet.Cells.Range("A1").PasteSpecial
xBook.Save
xApp.Quit
Set xApp = Nothing
MsgBox "保存成功!"
End Sub这样写把剪切板中的数据保存成了Object了,请某位路过的大拿帮帮忙,在线等,谢谢
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货