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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PLEASE HELP with populating userform fields from access database 12
Use VBA to Populate Listbox from Open Spreadsheet 4
Firing Event in another user form 1
inconsistent dir() behavior 1
populate dropdown/combobox on userform with specific values from s 3
Macro to select, set, and print 12
time frame 1
Userform Text box Format to Currency 2

Back
Top