Search results

Thanks arnelgp for the reply but I tried it and I get a compile error: User-defined type not defined and it highlights the line Dim xlWB as Excel.Workbook

Private Sub cmd_mn01_c2_Click() Dim sFile As String sFile = dir("O:\OMD Library\Snow Route Sectoring\Snow Sectoring FY17\Manhattan FY17\MN01\MN01 Critical Routes\MN01 Critical 01 Rev *.xlsx") If sFile <> "" Then Workbooks.Open FileName:=sFile Else MsgBox "Can't Find File: O:\OMD...

Minty I am kind of new to this whole coding thing....so would you be able to show me a sample code??

Thanks Minty! Any way of opening the file using a wildcard bc the date after Rev usually changes. So to make sure I always have the up to date file I wanted to use a wildcard.

I am getting a run-time error '424' object required when I run the following code: the line workbooks.open is where I am getting the error Any help would gratefully appreciated! Private Sub cmd_mn01_c1_Click() Dim excelfile As String excelfile = dir("\\FS125OMD02.dsnyad.nycnet\omd_data$\OMD...

Thanks Uncle Gizmo

Hi my name is Nick and I am new to this site. I am in the beginning phase of access programming.