Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel UserForm to Collect Data for Access
I am trying to come up with a way of linking to an Access DB, via an Excel
interface, such as a UserForm, because many people in my firm do not have Access installed on their workstations. Im sure this is possible, but I dont know the best way to approach the problem. Im thinking of posting the Excel UserForm on our firms Intranet (WAN or LAN), and then ask users to open the UserForm, input some basic information, and then save the changes and so on and so forth. Is there some way to do all of this on a LAN or a WAN? Could the Excel file reside on a public network drive, and automatically download to am Access DB every time there is a chance (i.e., each time a user inputs something into the UserForm)? I would appreciate any and all help with this project. Regards, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
collect data from one excel sheet to another | Excel Discussion (Misc queries) | |||
collect data from one excel sheet to another | Excel Worksheet Functions | |||
Collect data from Excel files | Excel Programming | |||
Userform - need to access data from a particular sheet | Excel Programming | |||
using a worksheet to collect data for access import | Excel Programming |