| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| Form a circle (ie. color specific cells) given specific radius | Excel Programming | |||
| Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
| When I select from drop down menu I would like the next column to populate a specific cost. | Excel Worksheet Functions | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
Linear Mode
