Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!
Option Compare Database Option Explicit Private Sub cmdImport_Click() CurrentDb.Execute "delete * from [Import_Access]" Dim strName As String Dim xlApp As Object Dim xlWB As Object Set xlApp = New Excel.Application With xlApp .Visible = False Set xlWB = .Workbooks.Open("J:\Corporate\Treasury\Compliance\Reporting and Key Dates for Compliance\Compliance Covenants - Financing and JVA.xls", , False) strName = "Deliverables" End With Set xlWB = Nothing Set xlApp = Nothing DoCmd.TransferSpreadsheet acImport, , "Import_Access", "J:\Corporate\Treasury\Compliance\Reporting and Key Dates for Compliance\Compliance Covenants - Financing and JVA.xls", True, strName & "!"
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.