Overview: Looking for direction on the capability described below. Need general directions to know if this is feasible and list the topics that I should go study.
Objective: Store MS Access database and complex set of Excel macros on a server. This will serve about 30 to 40 individuals.
My Vision: Install mini-macro on 40 computers in the VBA Personal Folder section with icon on tool bar to execute mini-macro. Only function of Mini-macro will be to download Big-macro and start it running. Big-macro will download data from the databases and help users analyze data. User will export analyzed data back to an Access database.
My Question: Am I dreaming to big? Is this scenario feasible? Can someone shove me down the right path
Point to reference material? Examples?
Objective: Store MS Access database and complex set of Excel macros on a server. This will serve about 30 to 40 individuals.
My Vision: Install mini-macro on 40 computers in the VBA Personal Folder section with icon on tool bar to execute mini-macro. Only function of Mini-macro will be to download Big-macro and start it running. Big-macro will download data from the databases and help users analyze data. User will export analyzed data back to an Access database.
My Question: Am I dreaming to big? Is this scenario feasible? Can someone shove me down the right path
