From MS Access...open Excel and menu go to specific Name

[puforee]

I have a DB to track our users and their access to different systems/servers. Part of the user information is the users location..building floor cube etc.

My boss created an excel spreadsheet showing all the cubes and employee locations by name.

In the excel document I have defined each users name with Insert...Name...Define for each person. This will allow me to use the Edit..Go To...menu to go directly to the cell containg the selected users Name.

I want to use VBA from within MS Access DB to perform this operation. So, in the MS Access DB I would select a user...click a button to run VBA...the VBA should open the spreadsheet and perform the Edit Go To...function...passing the name from DB to excel to select the proper go to Name.

I hope this is not too confusing. Can anyone help with the code please.

 

[vbajock]

Why not simply attach the Excel spreadsheet to the Access database?

 

[puforee]

vgajock...thanks but...


Please explain...I have tried Inserting as object...Get External Data...Not doing what I need. Inserting as object expands the excel sheet to be cut off. I tried hyper link...it opens the spreadsheet but does not perform the function I need within the spreadsheet.

Can you explain "attaching

 

[vbajock]

If you don't understand table attachment you need to buy a book on Access and read it.