open access recordset as an excel spreadsheet

V

Van T. Dinh

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

Guest

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

Top