Newhire

Hi,
I am developing a tool which working between MS Access & MS Excel. But I don't know how to open 1 Excel file (I mean show this Excel file in MS Excel, not just read data within it!). If you know, please tell me how to solve it!
Thanks ahead for your support.

Jonny

use the ShellExecute API... there is a link to an example at the bottom of the page.

thorran

Another approach to the shell execute function would be to create an object and then set the value of that object to the file that you need as long as you are know that file name. Below is an example of what I am talking about.

Dim xl As Object
Set xl = GetObject("c:\program files\BHA Builder\BHA.xls")
Then you make the object visible and off you go.

You will need to add a reference to MS Excel and/or MS Access in your project as well. Then you can call on all their functions in your code as well.

Good luck
Thorran

Kluz

You would want to read this automation tutorial for excellent information about automating Excel.

Newhire

Thank Jonny and all,
It worked. Many thanks again. :-)