Hello Everyone... Can anyone tell me the syntax for setting an object variable (specifically RANGE in Excel) through VBA in MS Access. This is what I have and the error is that the Range object (_Global) failed.
Thanks in Advance,Code:Set xlsApp = New Excel.Application xlsApp.Workbooks.Open Filename:=[filename] xlsApp.Cells.Range("B9:N30).Select With xlsApp.Selection .HorizontalAlignment = xlCenter End With
Glenn