When I select a specific .XLT I want it to populate w/Access Form
 

I have created a userForm in Access. When I open a specific Excel spread
sheet I want this form to open. Basically, on-open populate excel with the
UserForm. This is an entry program to format the spread sheet based on user
entry in form.

When I select a specific .XLT I want it to populate w/Access Form
 

Not sure what you're actually doing, as "on-open populate excel with the
UserForm" does not make much sense to me.

You can use the Workbook_Open event in the Excel file to run code.
You can query a database or interact with Access via automation.

However, it sounds like Access is the driving app, so why not automate Excel
from Access ?

NickHK

"VBAstudent" wrote in message
...
I have created a userForm in Access. When I open a specific Excel spread
sheet I want this form to open. Basically, on-open populate excel with
the
UserForm. This is an entry program to format the spread sheet based on
user
entry in form.