VBA中,我想拖动listView里的某条数据到新的excel里面,怎样实现呢? VBA中,我想拖动listView里的某条数据到新的excel里面,怎样实现呢? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Dim oExcel As Object Dim oBook As Object Dim oSheet As Object Set oExcel = CreateObject("Excel.Application") Set oBook = oExcel.Workbooks.Add Set oSheet = oBook.Worksheets(1) 'Create the QueryTable Dim oQryTable As Object Dim sQryTable As String sQryTable = "....." Set oQryTable = oSheet.QueryTables.Add("OLEDB;" & strConnectString & ";", oSheet.Range("A1"), sQryTable) oQryTable.RefreshStyle = xlInsertEntireRows oQryTable.Refresh False 'Save the Workbook and Quit Excel oBook.SaveAs cdlSaveAs.FileName oExcel.Quit Set oSheet = Nothing Set oBook = Nothing Set oExcel = Nothing 帮我看一下这个复制的问题吧 怎样使键盘上的power,sleep键不起作用怎么办? 放分 我如何用VB调用SQL中已经写好的存储过程呢? 一个极简单的问题 菜鸟问题。 光盘中许多VB例子的窗体加了锁,请问怎么做的? VB 怎么用16进制替换指定的字节 (具有唯一性) 有无方法将繁体中文字转化成简体中文? 非常简单的问题,(VB用Install shield打包ADO数据库应用程序) 紧急求助 在VBA中合并表。
Dim oBook As Object
Dim oSheet As Object
Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
Set oSheet = oBook.Worksheets(1)
'Create the QueryTable
Dim oQryTable As Object
Dim sQryTable As String
sQryTable = "....."
Set oQryTable = oSheet.QueryTables.Add("OLEDB;" & strConnectString & ";", oSheet.Range("A1"), sQryTable)
oQryTable.RefreshStyle = xlInsertEntireRows
oQryTable.Refresh False
'Save the Workbook and Quit Excel
oBook.SaveAs cdlSaveAs.FileName
oExcel.Quit
Set oSheet = Nothing
Set oBook = Nothing
Set oExcel = Nothing