How to access the MS Excel in MS Access by clicking a button with vb script code?

[ravikumarmarapp]

i need to connect the MS Access and MS Excel by using vb script,if i click the button in MS-Access mean new MS-Excel sheet must be open with out using any database table,only coding vb-script

[TheSmileyCoder]

What you need is called Automation, in your case Excel Automation.

I suggest you read up on it, and return when you have a more specific question ready.

[NeoPa]

You might start with Application Automation.

Smiley's right about the question though. If you follow the guidelines available from the main forum page you'll be fine. Something like this is likely to be summarily deleted though.