open a excel window and display the values

[ravindarjobs]

hello friends,

i am using ms access 2003,
i have a form,
when i click on a button, i should get the new excel window opened, displaying a particular table present in my access database.

so i went through this code

Dim oExcel As Excel.Application
Dim oWB As Excel.Workbook
Dim oWs As Excel.Worksheet
Set oExcel = New Excel.Application
'Set oWs = Excel.Worksheets.Application.ActiveSheet
Set oWs = Excel.ActiveSheet
oExcel.Visible = True
Set oWs = oExcel.ActiveSheet

i am not sure of this. i am struck here.
what should i do next

is this the correct way to proceed?
or else is there any easy way?

[Dököll]

hello friends,

i am using ms access 2003,
i have a form,
when i click on a button, i should get the new excel window opened, displaying a particular table present in my access database.

so i went through this code

Dim oExcel As Excel.Application
Dim oWB As Excel.Workbook
Dim oWs As Excel.Worksheet
Set oExcel = New Excel.Application
'Set oWs = Excel.Worksheets.Application.ActiveSheet
Set oWs = Excel.ActiveSheet
oExcel.Visible = True
Set oWs = oExcel.ActiveSheet
 

i am not sure of this. i am struck here.
what should i do next

is this the correct way to proceed?
or else is there any easy way?

Greetings and salutations, ravindarjobs!

It looks like you are not loading your MS access data to VB. Should you have added data from Access to Excel first?

Or are you saying data are alreayy added and you just need to view?