open access recordset as an excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
Try

mobjXl.ActiveSheet.Columns("A:J").HorizontalAlignment = Excel.xlCenter

mobjXlRange("A1").Select

(assuming that you want to run the code from Access, i.e. after the code you
posted originally.)
 
Thanks! Works Great

Van T. Dinh said:
Try

mobjXl.ActiveSheet.Columns("A:J").HorizontalAlignment = Excel.xlCenter

mobjXlRange("A1").Select

(assuming that you want to run the code from Access, i.e. after the code you
posted originally.)
Click to expand...
 
Back
Top