Access Form --> Hyperlink to Excel --> Return to Original Access Form ?

[John]

I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.

The Hyperlink works great.

When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.

Is there a way to:

1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)

I just need help with #4.

Or, is there a better way to do this?

Thanks
John

[salad]

John wrote:

I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.

The Hyperlink works great.

When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.

Is there a way to:

1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)

I just need help with #4.

Or, is there a better way to do this?

Thanks
John

See if the code at http://www.mvps.org/access/api/api0018.htm works better.

[John]

Thanks for the response.
I will examine the code.

John

salad wrote:

John wrote:

I have an Access 2000 form that has a Hyperlink that opens an Excel
2000 worksheet located in the same network folder as the Access MDB.

The Hyperlink works great.

When users close the Excel File, they must choose the correct open
Access form on the Windows Desktop Taskbar to return to the Access form
that had the Hyperlink.

Is there a way to:

1. Open the Access Form
2. Launch the Hyperlink to the Excel Workbook
3. Exit Excel, then
4. Return to the original Access form automatically - without clicking
anything (such as the the TaskBar)

I just need help with #4.

Or, is there a better way to do this?

Thanks
John

See if the code at http://www.mvps.org/access/api/api0018.htm works better.