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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't pass Recordset? 0
How do you set a recordset's bookmark? 5
adOpenStatic Recordset still changing my table 5
So disconnected means recordset can only be connected in same rout 1
Need help opening ADO recordset. 14
Send data from Access to Excel 1
Bulk Email From Access 1
Exporting Access table using a button click in exce 4

Back
Top