Search results

I am trying to import an excel worksheet into a new Access Table using the following code: Private Sub ImportXLSheets() Dim WrksheetName As String Dim i As Integer Dim xl As Object Set xl = CreateObject("Excel.Application") xl.Visible = True xl.Workbooks.Open "T:\FINANCE\Man_Acc\Month...

I have a query which prompts the user to enter a date. Using the following VBA code, which is assigned to a button: Sub GetMErateData() 'Displays all ME rate data DoCmd.OpenQuery "qry Divisional Analysis Month End Rate" End Sub When the prompt appears and I click cancel rather then...